Latest Blog Posts

How to Display Page Setup Dialog Box in Excel (4 Suitable Ways)

Microsoft Excel is a powerful software. We can now access new Excel features to open the Page Setup dialog box quickly and effectively. Using this ...

Excel ISERROR vs IFERROR Functions (2 Suitable Examples)

Looking for differences between Excel ISERROR and IFERROR functions? Then, this is the right place for you. Sometimes, we may find different kinds of ...

How to Use Conditional Formatting with the IFERROR Function in Excel – 4 Examples

The dataset showcases Name, Salary, Week, and Per Week Salary. To determine per week salary by dividing Salary by Week: Use the following ...

How to Calculate Historical Volatility in Excel (with Easy Steps)

What Is Historical Volatility? In business aspects, the monetary value of different financial factors (i.e., stocks and currency) keeps fluctuating ...

How to Use Excel DGET with Dynamic Criteria (with Precise Steps)

Have you ever wondered how to apply the DGET function of Excel for multiple dynamic criteria? The DGET function of Microsoft Excel is one of the ...

How to Create an Approval Workflow in Excel (with Easy Steps)

Below is our dataset called “Running Project of DPR Construction”. Step 1: Open a Dataset from OneDrive Using Desktop App Go to your ...

How to Perform Drawing of Objects with VBA in Excel (2 Examples)

Example 1 - Drawing Simple Shapes with VBA Code We will design a rectangle, a cell-sized rectangle, and a cube. Steps: Open your worksheet. ...

How to Use AND and OR Functions in Excel (3 Practical Examples)

While working in Excel, we often use the AND function. Sometimes we also use the OR function. There are times when we might need to use both the AND ...

[Fixed!] Error Messages in Excel (10 Practical Solutions)

Without hesitation, Microsoft Excel is one of the most compelling computer software you can use. Using Excel's tools and functions, we can do an ...

How to Create an Attendance Roster in Excel (with Easy Steps)

In this article, I will show you how to create an attendance roster in Excel. As we know, Excel is a very handy tool for keeping track of employees’ ...

How to Create Weekly Duty Roster Format in Excel

Let's take a sample dataset that represents the roster format of a company. Step 1 - Insert Staff Details Insert 3 sub-headers ...

Plotting Vectors in Excel (with Easy Steps)

Plotting a vector in Microsoft Excel allows you to visualize the data contained in the vector in the form of a graph or chart. This can be useful for ...

How to Find the Distance Between Zip Codes Using a Formula in Excel – 2 Methods

The sample dataset has 2 types of columns (Location 1 and Location 2). Method 1 - Using a Geometric Formula to Find the Distance Between ...

How to Use IF and IFERROR Combined in Excel (3 Examples)

Example 1 - Calculate the Sales Bonus We have two columns containing Sales Target and Sales Achieved for some products. We’ll check in Column E if ...

Top 100 MCQ of Excel: Test Your Skills

In this article, you will find the top 100 MCQ of Excel to test your skills. Most of the questions are very basic. As a result, anyone with a basic ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo