Resources
Relative Named Range in Excel
Excel uses absolute references for named ranges by default. While absolute references can cover most scenarios, relative references in named ranges work as relative references do in formulas. This behavior can be useful in some scenarios, but can be a bit tricky! In...
How to Make Excel Change Scope of Named Range
Named ranges have a property named "scope". Usually, you do not need to adjust this property to use named ranges in Excel. On the other hand, it can become very useful if you have a number of sheets that are identical. The scope concept allows you to use the same name...
How to apply named ranges to existing formulas in Excel
The use of named ranges is a very powerful tool for creating references in Excel. In addition to making formulas easier to read, you don't have to remember the exact cell and range references when writing formulas. If you have already been using named ranges,...
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
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....
How to Make Excel Remove Named Range Containing Errors
Managing and removing named ranges in Excel can be a challenging task, as you would have to do this one by one for each field. In this guide, we’re going to show you how to make Excel remove named range containing errors. [button...
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
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 create dynamic images in Excel without VBA
Wouldn't be nice if images in Excel updated automatically with certain prompts? In this guide, we're going to show you how to create dynamic images in Excel. [button...