3D Referencing & External Reference in Excel
Creating 3D referencing in Excel within a formula involves referring to the same cell or the same range of cells, on different worksheets. Each of the sheets, one is using, to create the 3D...
ExcelDemy.com Blog
How to Compare Two Columns in Excel to Find Differences
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...
How to use the TODAY() and NOW() Functions in Excel
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...
How to Print Excel Spreadsheet with Grid Lines and Change its Color
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...
Using Table Nomenclature in Excel and Referring to Tables in VBA
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...
How to Create Doughnut, Bubble and Pie of Pie Chart in Excel
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...
How to Apply Accounting Number Format in Excel!
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...
How to Print Excel Sheet on One Page
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...
How to Use the FORMULATEXT Function in Excel
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...
40+ Free Online Excel Course with Certificates
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...
How to Make a Single Line Graph in Excel – [The Easy Way]!
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...
[8 Tips] How to Make Excel Tables Look Good!
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...
How to Modify Theme Color, Font, & Effects & Create Custom Excel Theme
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...
How to Count the Frequency of Text in Excel!
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...
How to Make a Pie Chart in Excel & Add Rich Data Labels to The Chart!
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...
Using Excel Worksheet Functions INDEX & MATCH in VBA Code!
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...
