by Ilker | Mar 8, 2019 | Excel Tips & Tricks
Excel Table is a tool for managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which includes filtering, formatting, sizing, and auto populating formulas dynamically. In this guide, we’re going to go over some...
by Ilker | Mar 6, 2019 | Excel Tips & Tricks
In Excel, a blank cell doesn’t always mean a cell with an empty string (“”). An example to this is invisible characters like a new line character which can be entered by pressing the Alt + Enter key combination when you’re in a cell. You can...
by Ilker | Mar 5, 2019 | Excel Tips & Tricks
If you lost a worksheet or cannot find the worksheet tabs section in your workbook, fear not! In this guide, we’re going to show you how to unhide sheets and various methods to restore disappeared worksheet tabs. Unhide Sheets in Excel Excel allows hiding...
by Ilker | Feb 21, 2019 | Excel Formulas, Excel Tips & Tricks
With the introduction of the dynamic arrays and spill concepts, Microsoft has also released a spill range operator (#). This operator is designed to reference spill ranges dynamically. For example, the cell D3 has =UNIQUE(B3:B16) formula which spills the return values...
by Ilker | Feb 21, 2019 | Excel Tips & Tricks
The term spill in Excel’s literature is defined as populating multiple cells with a single formula. With the announcement of the dynamic arrays in September 2018, Excel formulas can now return (spill) an array of values into neighboring cells by starting with...
by Ilker | Feb 20, 2019 | Excel Tips & Tricks
Dynamic arrays can populate a range of cells from the values of an array. With dynamic arrays, any formula that returns an array of values will spill the results into the adjacent empty cells automatically. You can create tools like interactive pricing applications...
by Ilker | Feb 13, 2019 | Excel Macros, Excel Tips & Tricks
Excel doesn’t always update the range of cells you’ve used in worksheets when you modify them. This can result in a larger file size and have performance impacts, even after you clear cell contents. The easiest way to fix this is by deleting the blank rows...
by Ilker | Feb 6, 2019 | Excel Tips & Tricks
Lookup functions are extremely useful when working with large data sets. Although they almost always work instantaneously with small data, larger data sets is when things can get rough in terms of performance, as large operations can require more computational power....
by Ilker | Jan 30, 2019 | Excel Tips & Tricks
Nested IF statements are useful for creating more complicated scenarios in Excel. However, IFS and SWITCH formulas can work more efficiently when dealing with more than one condition. These formulas work a bit differently than the legacy IF function. Let’s start...
