Explore Excel Deeply
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...
In this tutorial, we will be discussing how you can view worksheets of an Excel workbook in multiple ways. For example, look at this workbook. It has three worksheets. The first worksheet is Accounts...
Hi folks, we hope you are learning a great deal from our series on workbook and worksheet management. If you missed out on any information visit our archives as we have already discussed viewing...
With this post, we shall be starting our Excel Table series. Today’s post, in particular, will give you an overview of the topic at hand and walk you through the basics. Do let us...
When we create a table, Excel applies the default table style. Say I want to make the following range into a table. I just select any cell within the range. Press CTRL and T...
Advanced Excel / Formulas / Functions
by Taryn N · Published May 11, 2017 · Last modified June 8, 2017
There is a total of five functions used for counting, predominantly in Excel. These are namely the COUNT Function, the COUNTA Function, the COUNTIF Function, the COUNTIFS Function and the COUNTBLANK Function. The COUNT...
![Creating and Editing Excel Comments to Cells – [An Ultimate Guide]!](https://www.exceldemy.com/wp-content/themes/hueman/assets/front/img/thumb-medium-empty.png)
