by Ilker | Nov 23, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to create a sequence of dates in Excel using the Auto Fill feature. Download Workbook AutoFill is the action of dragging the small square at the bottom-right corner of a cell. The small square is called the fill handle....
by Ilker | Nov 23, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to create a dynamically changing calendar in Excel. Download Workbook Populate variables First step is creating the variables to be used in the formulas. These variables need to provide the present day information so that...
by Ilker | Nov 20, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to change case in Excel using different methods. Download Workbook Unlike in Word, Excel doesn’t have any built-in features that can help modify the text case. However, some of the methods we will be looking at in...
by Ilker | Nov 18, 2020 | Excel Tips & Tricks
Did you know that Emojis have been around since 1997? They essentially became an integral part of most written communication methods. In this article, we are going to show you how to use emojis in Excel. Download Workbook How to insert an emoji in Excel You can insert...
by Ilker | Nov 9, 2020 | Excel Tips & Tricks
Adding symbols or icons into charts can enhance the visual representation, and make it easier to understand the data. In this article, we are going to show you how to use symbols on charts in Excel. Download Workbook Adding symbols to Excel Note that you can always...
by Ilker | Oct 26, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to find nth closest match in Excel. Download Workbook To find the closest match only, you can use a simpler version of this method here: How to find closest match in Excel. To find the nth match of an exact matched value,...
by Ilker | Oct 16, 2020 | Excel Tips & Tricks
A waterfall chart is a data visualization tool that shows how positive or negative values in a data series change in a sequential manner. A common scenario is to display the cumulative effect of income and expenses on net income. The values can be distributed either...
by Ilker | Oct 8, 2020 | Excel Tips & Tricks
A common problem when transposing data in Excel is that data is populated in their relative cells. This means that you may occasionally see messed up references when using the Paste function with transpose. In this article, we are going to show you how to cut and...
