by Ilker | Jan 6, 2020 | Excel Tips & Tricks
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...
by Ilker | Jan 2, 2020 | Excel Tips & Tricks
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....
by Ilker | Dec 31, 2019 | Excel Tips & Tricks
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. Download Workbook Filtering named ranges with...
by Ilker | Dec 31, 2019 | Excel Tips & Tricks
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...
by Ilker | Dec 30, 2019 | Excel Tips & Tricks
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,...
by Ilker | Dec 27, 2019 | Excel Tips & Tricks
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. Download Workbook Preparing the Dynamic Images First, we need to place our images somewhere in the...
by Ilker | Dec 17, 2019 | Excel Tips & Tricks
Duplicate values in a dataset can cause headaches if you do not know how to deal with them. In this guide, we’re going to show you how to find duplicates in Excel and also go over how you can remove or consolidate them using a few examples. Download Workbook How...
by Ilker | Dec 13, 2019 | Excel Tips & Tricks
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. Download Workbook There are 3 common...
by Ilker | Nov 25, 2019 | Excel Tips & Tricks
Data doesn’t always come in a nice table layout, especially, when you retrieve it from an external source like a web site. Thanks to the Excel Text to Columns feature, you can split data into multiple columns. In this article, we are going to show you how to use...
