Explore Excel Deeply
This is an interesting situation that often comes up. Namely, sometimes one needs to match data in two different columns or different sheets. So, let’s get started with a simple example, to illustrate how...
The TODAY() Function is used to determine the current date, as in the date one is actually opening the workbook. This function updates automatically, so let’s say you open the workbook on 1 April...
Have you ever wanted to change the color of the gridlines in Excel or perhaps print the gridlines in your worksheet? Well, look no further, since we will show you how to do just...
We have already covered how to format Excel Tables extensively in a previous tutorial. We are now going to look at using Table Nomenclature or structured Table references in formulas. Using structured Table References...
Most of us are familiar with standard Excel chart types such as a pie chart, a column chart, and a line chart, as well as the types of data they are used to showcase...
The Accounting Format is similar to the Currency format and can be applied to numbers where needed. The difference between the Accounting format and the Currency format is that the Accounting format puts the...
This is a question that is often asked (How to Print Excel Sheet on One Page), namely how to fit the contents of one’s spreadsheet on one page when printing. So we are going...
The FORMULATEXT Function is a new Excel function, which was introduced in Excel 2013 and later versions of Excel. Using the FORMULATEXT Function will allow you to select any cell containing a formula and...
So, you’re looking for free online Excel course with certificates. You’re at the right place. On this page, I’ve listed 40+ free Excel courses (online based) and after the completion of the courses, you...
Abstract: In this article, you’ll learn how to make a single line graph in Excel and some other tips related to Excel charting. Line charts are useful for showcasing trends over time, while they...
Editor’s Note: “How to make Excel tables look good?” – this is a general question by a new user of Excel. I asked Taryn to make a detailed article on this. I checked the...
Excel has themes, which have different default colors, auto shape effects, SmartArt effects, and fonts. When utilizing themes one can quickly change the look of the workbook, if necessary. One can also edit individual...
Advanced Excel / Functions / Macros & Excel VBA
by Taryn N · Published June 11, 2017 · Last modified June 14, 2017
Have you ever wondered how to count the frequency, i.e the number of times a specific text appears, in a range in Excel? We have already seen how to use the different COUNTING functions...
A pie chart is used to showcase parts of a whole or proportions of a whole. Charts are visual representations of data that can summarize large data sets and are useful for engaging one’s...
Advanced Excel / Macros & Excel VBA
by Taryn N · Published June 6, 2017 · Last modified June 8, 2017
You can utilize the built-in Excel Worksheet functions such as the VLOOKUP Function, the CHOOSE Function and the PMT Function in your VBA code and applications as well. In fact, most of the Excel...
Today’s post will be concerned with comments. We will be seeing how and when to use them. So let’s get started. Firstly, you normally insert a comment to a certain cell when you wish...
![Creating and Editing Excel Comments to Cells – [An Ultimate Guide]!](https://www.exceldemy.com/wp-content/uploads/2017/06/Creating-and-Editing-Excel-Comments-to-Cells-–-An-Ultimate-Guide-520x245.png)