by Ilker | Nov 2, 2021 | Excel Tips & Tricks
Using blanks instead of repeating values is a common approach to express the hierarchy between columns. You may recognize the structure from Pivot Tables from older Excel versions. Although you can use the formulas to populate these empty cells, it may become...
by Ilker | Nov 2, 2021 | Excel Tips & Tricks
Apparently, Excel doesn't have a hover (mouse over) event support for cells. However, we can use the HYPERLINK function to mimic this functionality, thanks to mouse-over support for hyperlinks in Excel. In this guide, we’re going to show you how to trigger a macro by...
by Ilker | Nov 1, 2021 | Excel Tips & Tricks
It is common to lose your way in a big table of data. Even though Excel's freezing features help you to display selected row and column's primary data, no feature can beat highlighting to express the selected data. In this guide, we’re going to show you how to...
by Ilker | Oct 27, 2021 | Excel Tips & Tricks
Although Excel doesn't lack functions to generate random numbers, there is no built-in option to generate unique numbers. On the other hand, we can assume that it would be very uncommon to get same number from Excel's random number functions. Anyways, we can eliminate...
by Ilker | Oct 26, 2021 | Excel Tips & Tricks
Errors may be inevitable in worksheets containing complex formulas. Thankfully, you do not need to investigate and correct each of them. It is OK to hide errors you expect and not to correct them to improve the look and feel of your worksheet. In this guide, we’re...
by Ilker | Oct 18, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to set different colors to positive and negative numbers in area charts in Excel. Download Workbook In charts, the colors and shapes are the most important elements which can express the differences between data series....
by Ilker | Oct 13, 2021 | Excel Tips & Tricks
Color differences are probably the first thing that human eye can catch. Because a visualization should be easy to understand, different colors may be your best option to express opposite data like positive and negative values. In this guide, we’re going to show you...
by Ilker | Oct 5, 2021 | Excel Tips & Tricks
The more people work on an Excel file, higher the risk of corrupting it. Let's say that you have created a layout that clearly indicates where the input cells and output cells are. It's almost impossible that your file will maintain its initial state when it has been...
by Ilker | Oct 1, 2021 | Excel Tips & Tricks
As data grows in a worksheet, it gets harder to manage it. Even a large monitor doesn't help while dealing with thousand rows and hundreds of columns. Fortunately, Excel allows you to split the window up to 4 panes which you can focus on different parts of the...
