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...
by Ilker | Nov 22, 2019 | Excel Tips & Tricks
Excel is a fairly an efficient software given that it can perform complex calculations. However, depending on your system, it can also get pretty slow when running complicated calculations. How formulas are used, and size of the workbook are typically the culprit if...
by Ilker | Nov 21, 2019 | Excel Tips & Tricks
A loop is an essential concept for any programming language, and VBA follows the same approach. You can use loops to repeat an action until a specified condition is reached, or move through objects in a group, e.g. all worksheets in a workbook. A loop is an essential...
by Ilker | Nov 19, 2019 | Excel Tips & Tricks
Control Shift Enter Excel shortcut, as known as CSE, is a key combination you can use to apply array functions.CSE abbreviation is also used for array formulas that are entered using the Control + Shift + Enter key combination when entering a formula. Array formulas...
by Ilker | Nov 18, 2019 | Excel Tips & Tricks
In this guide we’re going to go over 10 things you should know about the frequently-used-yet-not-so-easy-to-use VLOOKUP Excel function. Although this guide mainly focuses on the VLOOKUP function, these tips also apply to the HLOOKUP function, which essentially...
