Excel Basics

Return Non Blank Cells from a Range in Excel (3 Suitable Ways)

The following dataset consists of two columns labeled Area and Sales Rep. It has several records that are missing important information. We are going ...

How to Stop Automatic Cell Formatting in Excel

This is an overview.   Unchecking the AutoCorrect Dialog Box Steps Click the arrow button above the ribbon and select More ...

How to Stop Excel from Auto Formatting Hyperlinks

Stopping Excel from auto-formatting hyperlinks refers to preventing Excel from generating hyperlinks automatically while pasting new links. Excel, by ...

How to Create a Networking Catalogue in Excel (with Easy Steps)

Networking equipment such as switches, routers, wireless, etc. is well-known in the technology industry. To promote the product, companies may often ...

Drawing Decision Trees in Excel (2 Easy Ways)

A decision tree is a kind of flow chart in Excel. It helps to visualize certain conditions clearly and take action according to them. There are ...

[Fixed!] NUM Error in Excel (4 Reasons with Solutions)

In this article, we will learn what are the reasons behind #NUM! error in Excel and show you how to solve the problem. When working with an Excel ...

How to Determine If a Number Is Even in Excel (4 Suitable Ways)

Microsoft Excel is a helpful program that lives up to its name. With Excel's tools and functions, we can do an almost endless number of things with a ...

How to Create a Custom AutoFill List in Excel – 2 Methods

    Method 1 - Using the Advanced Excel Options to Create a Custom AutoFill List Create a dataset. Select the range to ...

How to Perform Tab Navigation in Excel (8 Easy Ways)

Here are two simple ways to navigate worksheet tabs in Excel: To move to the adjacent sheet tabs, press Ctrl+PgDn to move to the next sheet, and ...

How to Create a Drawing Register in Excel (Easy Steps)

What Is a Drawing Register? A drawing register is essentially a list of drawings related to a project or a company. It includes essential details ...

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

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

Using Spin Button to Increment Decimal in Excel (2 Easy Ways)

While working in Excel, we often use the Spin Button to quickly change the values of a cell. But, the minimum increment value of the Spin button is ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo