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

How to Solve Quadratic Equation in Excel VBA

If you are searching for a solution or some special tricks to solve quadratic equations in Excel VBA, then you have landed in the right place. There ...

How to Solve 2 Equations with 2 Unknowns in Excel (2 Examples)

Method 1 - Combine MMULT and MINVERSE Functions Steps: Select the D13 and D14 cells. Insert the formula below to solve the equations: ...

Sensitivity Analysis for NPV in Excel – 4 Steps

  You have a three-year project. The revenue from the project depends on 3 variables: selling price, variable cost, and annual sales. To know ...

How to Calculate Average Letter Grades in Excel – 4 Methods

  Download Practice Workbook Download this practice workbook to exercise. Average Letter Grades.xlsx A sample letter ...

Using Excel VBA to Populate an Array with Cell Values – 4 Examples

The sample dataset showcases Month, Cost, and Sales. Example 1 - Applying a While Wend Loop to Populate an Array with Cell Values in Excel ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo