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 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...
by Ilker | Jan 29, 2019 | Excel Tips & Tricks
Conditional Formatting is commonly used to highlight data fields to easily identify outliers, or narrow down the results. However, this feature works a bit differently when dealing with a Pivot Table. Pivot Tables are also dynamic elements, and conditional formatting...
by Ilker | Jan 24, 2019 | Excel Tips & Tricks
Comparing the data in two different columns is a frequently used method in data analysis. In Excel, you can compare using formulas or highlighting. In this guide, we’re going to show you how to compare two columns in Excel using these two methods. Compare two columns...
by Ilker | Jan 17, 2019 | Excel Tips & Tricks
By default, Excel will cut off the characters that don’t fit into a certain space. An alternative approach is wrapping the text to fully display it by increasing the cell height. In this guide, we’re going to show you how to wrap text in Excel. These methods...
by Ilker | Jan 14, 2019 | Excel Tips & Tricks
The Format Painter is the life saver when you need to copy only the formatting settings from one section to the other in your spreadsheet. In this guide, we’re going to show you how to use format painter in Excel. The best part is, this feature is supported by pretty...
