Latest Blog Posts

How to Create Data Dictionary in Excel (with Easy Steps)

If you want to create a data dictionary in Excel, you have come to the right place. Here, we will walk you through 3 easy steps to do the task ...

How to Make a Wind Rose in Excel: 2 Easy Methods

There are two possible ways to make a wind rose in Excel. We have a dataset of Wind Speed with their Direction for a specific time. Method ...

How to Create Project Pipeline in Excel: 2 Suitable Methods

Method 1 - Creating Project Pipeline Manually in Excel Step 1: Create Table for Project Pipeline Write all required terms that are important to ...

How to Create Test Cases for an ATM Machine in Excel – 3 Steps

Step 1: Setting Up Format Create the following fields - Test Scenario: The test scenario for the test cases. Tester: The person ...

How to Do Bookkeeping for Small Business in Excel: 6 Methods

Method 1 - Decide Which Accounting Method You Will Use Businesses primarily employ two accounting techniques: Accrual Accounting and Cash ...

How to Fix Excel to PDF Size Problem While Printing: 4 Methods

Method 1 - Utilize Print Option to Solve Excel to PDF Size Problem STEPS: Choose the intended sheet as the Active sheet. Go to the File tab. ...

How to Make a Picture Catalog in Excel (with Easy Steps)

In this article, we will describe a step-by-step procedure to make a picture catalog in Excel. As an example, we'll make a picture catalog to provide ...

How to Catalog Books in Excel – 2 Methods

Method 1 - Creating a Custom Catalog for Books Steps: Select the headings. Separate the columns with a borderline. Select a ...

SmartArt in Excel: Everything You Need to Know

OS Industries Ltd manufactures Men’s Shirts and sells in Texas, California, and New Mexico. The supply chain is showcased below with SmartArt. ...

How to Use Fuzzy LOOKUP Algorithm in Excel: 2 Easy Methods

Method 1 - Matching Obtained Marks by Fuzzy LOOKUP Algorithm Steps: In the first table, Name in column B and Science in Column C. In the second ...

How to Create a Workflow Tracker in Excel (with Easy Steps)

Step 1 - Creating a Dataset for the Workflow Tracker We have listed the tasks in the Task column. Input the starting dates in the ...

How to Create a Pipeline Report in Excel – 4 Steps

  STEP 1 - Create a List of Stages of the Deal A list of 4 stages is created. Lead indicates that the deal is in the primary stage. ...

How to Create Alerts in Excel (4 Easy Methods)

In the below dataset we have three columns displaying Client names, Meeting Dates, and Alerts. Method 1 – Using the IF Function to Create ...

How to Create a Tooltip in an Excel Chart (Easy Steps)

What is a Tooltip? Tooltip is a message or note that appears when the mouse pointer rests on an icon or any graphical interface. In Microsoft Excel, ...

How to Create a Sales Pipeline in Excel (with Easy Steps)

  Step 1: Prepare a Dataset We must create or import a dataset that includes the necessary data for creating a sales pipeline. Here, we will ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo