Data Analysis with Excel

What-If Analysis in Excel with Examples: Complete Guide

Method 1 - What-If Analysis of House Rent in Excel Our first example is based on the house rent. Using the scenario manager, you can find out which ...

How to Group and Summarize Data in Excel: 3 Suitable Ways

The following dataset contains three months: January, February, and March, and products for three months. Let's see how to group the dataset by month ...

How to Summarize Data in Excel (8 Easy Methods)

Download the Practice Workbook Summarizing Data.xlsx 8 Useful Methods to Summarize Data in Excel We have some sales data for a fast-food ...

How to Do ANOVA in Excel (2 Suitable Examples)

If you are looking for ways to do ANOVA in Excel, then this article will serve this purpose. ANOVA is used to find differences among groups of data ...

How to Summarize a List of Names in Excel (5 Ways)

  Method 1 - Using the 'Remove Duplicates' Command Steps: Copy the ‘Sales Rep’ column and paste it below ‘Output’. To remove ...

How to Create Scenarios in Excel (With Easy Steps)

In this tutorial, I am going to show you the step-by-step procedures to create scenarios in Excel. The Scenario Manager can create simple summaries ...

How to Create Summary Table in Excel (3 Easy Methods)

  Let's use a summary of the Covid-19 epidemic between 2020 and 2022 as our sample dataset. Method 1 - Using UNIQUE and SUMIFS ...

How to Use a Data Model in Excel – 3 Examples

The sample dataset includes sales price, seller name, product name, and date. There's another dataset that contains the seller's name and gender. ...

How to Summarize Text Data in Excel – 3 Steps

The dataset showcases Products and their Groups. To summarize all products: Step 1 - Create a Pivot Table Select the whole dataset ...

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

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 Summarize Data by Multiple Columns in Excel

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Especially ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo