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...
ExcelDemy.com Blog
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...
![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)
Creating and Editing Excel Comments to Cells – [An Ultimate Guide]!
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...
Viewing Excel Worksheets in Multiple Ways
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...
Hide and Unhide Excel Worksheets from a Workbook
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...
What is the Difference between a Table and a Range in Excel?
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...
Excel Table Formatting Tips – Change the Look of the Table
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...
The Different Ways of Counting in Excel
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...
How to Use Form Controls in Excel
Introduction You can give your worksheets form-like functionality without ever having to use VBA. In order to achieve this, you will have to use form controls. Form controls are accessed from the Developer Tab...
