Latest Blog Posts

How to Apply the Accounting Number Format (ANF) in Excel (6 Methods)

The following image provides a clear overview of the purpose of this Excel tutorial. The right side of the image presents the result of the methods ...

How to Use Excel FORMULATEXT Function?

The FORMULATEXT function is an Excel function first introduced in Excel 2013 and later versions of Excel. The FORMULATEXT function allows users to ...

Best price How to Use Excel FORMULATEXT Function?

40+ Free Online Excel Courses with Certificates

Coursera Excel to MySQL: Analytic Techniques for Business Specialization Free Enroll Excel to MySQL: Analytic Techniques for Business course! ...

How to Make a Single Line Graph in Excel (A Short Way)

What Is a Single Line Graph in Excel? We have data on sales of any particular store of different products. If we want to visualize this data or the ...

How to Make Excel Tables Look Good (8 Effective Tips)

How to Create an Excel Table Steps: Select a cell from the data set. Go to the Insert tab and choose Table. Excel will ...

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 ...

How to Create Excel Pie Charts and Add Data Labels to the Chart

A pie chart is used to showcase parts of a whole or the proportions of a whole. We will use a simple tennis related example to illustrate how to ...

How to Use the INDEX MATCH with Excel VBA – 9 Steps

  Download Practice Workbook Download the practice workbook and practice. INDEX-MATCH.xlsx Step1 - Apply the INDEX and the MATCH ...

Creating and Editing Comments in Excel (4 Practical Examples)

While working in Microsoft Excel Sometimes we feel the need to create and edit comments so that other users can see and reply according to them. I ...

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. ...

How to Hide and Unhide Excel Worksheets from a Workbook

If you are looking for how to hide and unhide Excel worksheets from a workbook, then you are in the right place. In some situations, while using ...

Excel Table vs. Range: What Is the Difference?

A Range in Excel An Excel Range is a set of two or more cells. It is represented by the combination of the reference of the first cell and the last ...

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 ...

How to Use Different Types of COUNT Functions in Excel?

Method 1 -Using COUNT Function to Count Cell Numbers The syntax for the COUNT function is: Steps: To count only the number of jobs in ...

How to Use Form Controls in Excel (Detailed Analysis)

  Download the Practice Workbook Form Controls.xlsm What Are Form Controls in Excel? Form controls in Excel are objects we can ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo