Resources

How to use Wildcard criteria in Excel formulas

How to use Wildcard criteria in Excel formulas

Wildcard is a term for a special kind of a character that can represent one or more "unknown" characters, and Excel has a wildcard character support. You can use wildcards for filtering, searching, or inside the formulas. In this guide, we're going to show you how to...

How to simplify Nested IF statements

How to simplify Nested IF statements

Nested IF statements are useful for creating more complicated scenarios in Excel. However, things can get quickly out of hand as the number of conditions increase. For example, five conditions means at least four IF functions, hence lots of parenthesis to deal with....

Excel TEXTJOIN and CONCAT

Excel TEXTJOIN and CONCAT

Excel TEXTJOIN and CONCAT functions are relatively new, and welcome additions to Excel’s plethora of functions. Both functions have been released with Excel 2016 as a replacement for the CONCATENATE function to make it easier to merge multiple text strings. In this...

CONCAT vs CONCATENATE

CONCAT vs CONCATENATE

For a long time, the only option to combine text strings has been using the CONCATENATE function, which does nothing more than what the ampersand (&) operator does. Recently, Microsoft has released the CONCAT and TEXTJOIN formulas with Excel 2016. In this guide,...

How to prevent a #REF error in Excel

How to prevent a #REF error in Excel

A #REF! error in Excel indicates an invalid reference. This pesky error can pop up after removing a sheet, rows or columns, or copying a formula. In this guide, we're going to show you how to prevent a #REF error in Excel. [button...