Latest Blog Posts

[Fixed]: Conditional Formatting in Data Bar Percentage Not Working in Excel

To demonstrate the solutions, we'll use a dataset of 10 employees of a company and their salaries. Our dataset is in the range of cells B5:C14. ...

How to Make Games in Excel (with Easy Steps)

In this article, we will demonstrate how to create a Poker Machine Game in Excel. The free template of the game is downloadable at the bottom of the ...

Counting characters at the beginning of a word using the COUNTIF & LEFT Functions in Excel – 3 Steps

STEP 1 - Create a Dataset Create a dataset. Here, B4:C15. STEP 2 - Enter the Text You Need to Count In F6 (Search), enter B to ...

How to Make a Table Bigger in Excel (2 Useful Methods)

Excel table is one of the most useful tools that Excel offers as we can accomplish many tasks conveniently by using Excel Table. In this article, I ...

How to Create an Organizational Chart From Excel Data (Step-by-Step)

  Step 1: Creating an Employee Directory We will use this dataset to explain a company's hierarchy. The division is done based on the Role of ...

How to Link Excel Data to PowerPoint Chart (3 Simple Methods)

In this tutorial, I am going to show you 3 simple methods on how to link Excel data to a PowerPoint chart. You can use these methods mainly in large ...

Excel VBA Error Handling Best Practice

In this article, we are going to discuss the best practice for Excel VBA error handling. One will need advanced knowledge of Excel to understand the ...

[Fixed!]: Unable to Enable Macros in Excel (5 Quick Solutions)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Visual Basic ...

[Fixed!] Iterative Calculation Not Working in Excel

For research purposes, most of the time you may need to do an Iterative calculation. Sometimes, you may face the problem that you need to iterate but ...

[Fixed!] Paste Special Not Working in Excel (4 Possible Solutions)

We often need to paste special values or numbers or characters in Excel. Excel allows users to paste different types of data through a feature called ...

[Solved]: XML File Not Opening in Excel (3 Suitable Solutions)

The Extensible Markup Language is known as XML. This dialect is comparable to HTML. A markup language really employs tags to define text and is a ...

[Fixed!] Cursor Selecting Wrong Cell in Excel (6 Proven Solutions)

Here are the Quarterly Sales Data for 2021 shown in the B4:F14 cells, containing the Location and the four Quarters Q1, Q2, Q3, and Q4, respectively. ...

How to Add Blue Data Bar in Excel (3 Easy Ways)

We occasionally need to use the data bars feature to display our dataset. We can rapidly do it with Excel's Conditional Formatting feature. In this ...

How to Make a Conversion Table in Excel (8 Easy Examples)

This tutorial will demonstrate how to make a conversion table in Excel. In our day-to-day life, we need to convert different units. Sometimes we need ...

How to Add a Drop-Down List in Word from Excel (2 Ways)

Method 1 - Using the Paste Special Command Steps: Select the cell that contains the drop-down list in the Excel file. In this case, it will be ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo