Data Analysis with Excel

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

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

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

Sensitivity Analysis for NPV in Excel – 4 Steps

What Is Sensitivity Analysis? Sensitivity Analysis determines the impact of a change in an independent variable associated with a product. ...

How to Use What If Analysis in Excel (with All 3 Features)

If you are searching for the solution or some special tricks to use What if analysis in Excel then you have landed in the right place. There are 3 ...

The Excel Data Model Relationships are Not Working – 6 Solutions

Overview of Data Model Relationships Data model relationships can be defined as a relationship that connects two different data tables. ...

How to Do IRR Sensitivity Analysis in Excel (with Detailed Steps)

Step 1: Input Basic Particulars Type 'IRR Sensitivity Analysis’ in some merged cells in a larger font size. That will make the heading ...

How to Build a Sensitivity Analysis Table in Excel (One-Variable and Two-Variable)

This guide will show you how to build sensitivity analysis tables in Excel, looking at both single factors and two factors at once. To illustrate, ...

The What If Analysis Data Table is Not Working – 4 Issues and Solutions

Consider the Fruit Sales Data below.   Issue 1 - The What if Analysis Data Table Returns the Same Value     ...

How to Do Sensitivity Analysis in Excel (3 Easy Methods)

Method 1 - Sensitivity Analysis with One-Variable Data in Excel Steps: Create a dataset like in the image below and mark the ...