Latest Blog Posts

How to Find Carriage Return in Excel (2 Easy Methods)

Carriage return is a very important element in Excel cells. It defines the cell length along with the information within it. In some cases, we need ...

The Quick Access Toolbar is Missing in Excel – 6 Solutions

This is an overview. Why is the Quick Access Toolbar Missing? Possible Reasons: It was Accidentally Removed. The Customized Quick ...

How to Filter Missing Data in Excel (4 Easy Methods)

This article will provide you with 4 easy methods to filter missing data in Excel. We'll use the dataset below representing some salesperson’s ...

How to Print Background in Excel (With Easy Steps)

Sometimes we need to print a dataset in Excel with a background. We can insert a background to our dataset if we choose the Background option from ...

How to Randomly Select Participants in Excel (4 Easy Ways)

We often need to randomly select data from our Excel sheet, especially text data. Microsoft Excel does not offer any dedicated function to select ...

How to Use Header and Footer in Excel (3 Quick Ways)

People like to have their things decorated. Header and Footer are one of the most amazing features to decorate Microsoft Excel worksheets. If you ...

How to Make Hierarchy Chart in Excel (3 Easy Ways)

We'll use the following dataset to show how to make a hierarchy chart. This dataset contains employee information. Method 1 - Using the ...

How to Flip Data from Horizontal to Vertical in Excel (6 Methods)

Dataset Overview We will be working with the following dataset, which includes product names and their corresponding total prices. Our task is to ...

Excel Macro to Create New Sheet and Copy Data (4 Examples)

Before demonstrating the examples of Excel macros to create new sheet and copy data, let's first learn how to add and apply a macro to a Workbook. ...

How to Analyze Quantitative Data in Excel (with Easy Steps)

We have a dataset that contains information about several working time of some men and women. We will analyze the quantitative data using the T-Test, ...

How to Draw CPM Network Diagram in Excel: 3 Easy Steps

Method 1 - Create a Primary Diagram with Boxes and Lines Create a cell with some borders, like the following screenshot. Draw some more ...

How to Reconcile Data in Excel – 4 Methods

Method 1. Finding Duplicate Values to Reconcile Data To find the duplicate values and reconcile data: Step 1 - Finding the Duplicates ...

How to Create Relationship in Excel with Duplicate Values

The sample dataset has Duplicate values. The common column is the Product Id. The Relationship will be based on this common column. Method ...

How to Do What-If Analysis Using Scenario Manager in Excel

In Microsoft Excel, the what if analysis scenario manager is a useful command. Using this command, you can analyze your dataset scenario with several ...

How to Do What-If Analysis Using Goal Seek in Excel

The goal seek is a handy feature in Microsoft Excel that helps us measure an input based on the desired output. It can be very useful in financing ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo