Excel tutorials, functions and advanced formula examples

How to use ISERROR function in Excel

When you write a formula that Excel does not understand or cannot calculate, it draws your attention to the problem by showing an error message. The ISERROR function can help you catch errors and provide an alternative when an error is found. Continue reading

Excel split screen - view different parts of a sheet at once

When working with large datasets, it can be helpful to see a few areas of the same worksheet at a time to compare different subsets of data. This can be done by using Excel's Split Screen feature. Continue reading

How to open Excel files in separate windows and instances

Having spreadsheets in two different windows makes many Excel tasks easier. One of the possible solutions is viewing workbooks side by side, but this eats a lot of space and isn't always the best option. Continue reading

Video: Format your tables in Google Sheets using Table Styles add-on

Make a statement with your Google Sheets tables using the updated Table Styles add-on! 50+ supplied styles, the ability to edit each or create your own style templates. Set font, colors, borders & other formatting, apply styles by parts – even the tailor-made tables now won't be left behind. Continue reading

Video: How to protect & unprotect multiple Google sheets in bulk

In this video, you'll learn one new feature our Sheets Manager introduced to Google Sheets: protect more than one Google sheet at the same time. Of course, the option to unprotect multiple Google sheets is included. Come take a look. Continue reading

Excel IFNA function to handle #N/A errors

Getting a lot of #N/A errors in your worksheets and are curious to know if there is a way to replace them with a user-friendly message? IFNA formula is the solution you need. Continue reading

ISNA function in Excel with formula examples

When Excel cannot find what it is asked for, a #N/A! error appears in a cell. To intercept and handle such errors, you can use the ISNA function. Continue reading

How to change Excel CSV delimiter to comma or semicolon

Imagine this: you want to export your Excel data to another application. Whatever CSV option you use, the result is a semicolon-separated file instead of comma-separated you really wanted. The setting is default, and you have no idea how to change it. Continue reading

How to highlight active row and column in Excel

When viewing a large worksheet for a long time, you may eventually lose track of where your cursor is and which data you are looking at. To know exactly where you are at any moment, get Excel to automatically highlight the active row and column for you! Continue reading

How to create dynamic Outlook email templates for the current user

Let's say, you have a really nice template, and your teammates would be happy to use it in their correspondence, but you're stuck on making this template dynamic. The problem is that each of your colleagues would like to get a different image, an individual attachment, and some specific text added to the template every time they use it. Continue reading

VLOOKUP to compare two columns in Excel for common values and missing data

When you have data in two different lists, you may often need to compare them to see what information is missing in one of the lists or what data is present in both. Comparison can be done in many different ways, which method to use depends on exactly what you want from it. Continue reading

Video: How to move multiple Google sheets to new, existing or several separate spreadsheets

Have you ever tried to move – cut & paste – Google sheets from one file to another? There's no such option available in spreadsheets. But it doesn't really matter if you have Sheets Manager at hand. It knows how to split your Google spreadsheet by tabs or simply move multiple tabs to a new or the existing file at once. Continue reading

How to use and store custom functions in Excel

Today we’ll continue exploring custom Excel functions. Now that you know how to create UDFs, let’s dig a bit deeper and learn how to use and store user-defined functions in Excel. Continue reading

RegEx in Excel: using regular expressions in formulas

At first sight, Excel has everything you could ever need for text string manipulations. Hmm… what about regular expressions? Oops, there are no built-in Regex functions in Excel. But no one says we cannot create our own ones :) Continue reading

Video: How to copy multiple Google sheets to the current, new, existing or several separate spreadsheets

In today's video, I'll show you why Sheets Manager is a better alternative when it comes to copying multiple Google sheets. You'll see the handiest way of duplicating several tabs and, what's more, learn how to copy them into multiple separate spreadsheets in one go. Continue reading

Debug user defined functions

As you already know how to create UDFs (and, I hope, you’ve also tried applying them in your Excel), let’s dig a bit deeper and see what can be done in case your user defined function is not working. Continue reading

How to remove whitespace and empty lines in Excel with Regex

Whichever input data you are using, you'll hardly encounter a dataset without spaces. In most cases, whitespace is good. In some situations, however, it may become evil - extra spaces can mess up your formulas and make your worksheets almost unmanageable. Continue reading

Video: How to lock several Google sheets, copy them, hide/unhide, move, etc. with a special add-on

Though Google Sheets offers its ways to process multiple tabs, there's a faster and user-friendly solution I'd like to share – our Sheets Manager add-on. It even knows a few tricks you won't cover with standard tools. But please, don't take my word for it – come watch today's video to see for yourself.  Continue reading

Custom UDF function vs VBA macros: advantages and drawbacks

This article will help you understand the differences between UDF and Macro. Also, custom functions have many advantages, but there are also many limitations when using them. Continue reading

How to extract substrings in Excel using regular expressions (Regex)

Microsoft Excel provides a number of functions to extract text from cells. Those functions can cope with most of string extraction challenges in your worksheets. Most, but not all. When the Text functions stumble, regular expressions come to rescue. Continue reading