## How to Do Scenario Analysis in Excel (with Scenario Summary Report)

How to do scenario analysis in Excel? How to generate scenario summary report using Excel scenario manager feature? You will learn all these crucial data analysis topics in this article. So, let's ...

## How to create a one variable data table in Excel

In this article, I am going to explain how to create a one variable data table in Excel. Data tables are important parts of Excel What-If Analysis feature to perform the sensitivity analysis of a ...

## Performing manual what-if analysis in Excel

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide. A manual what-if analysis doesn’t require too much explanation. In fact, the example we have used in the ...

## Monitor Cells with Excel Watch Window!

Sometimes we have a great deal of data in the workbook. Everything is important but most important are the last row of the data containing, say, the daily sum of sales, or percentage of profits in ...

## Types of What-If analysis in Excel

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide. Excel can handle much-sophisticated models than the preceding example. To perform a what-if analysis ...

## A What-If example in Excel

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide. You can create dynamic models in Excel. This is one of the most appealing aspects of Excel. A dynamic ...

## How to Create Pivot Table Data Model in Excel 2013

So far, we have focused exclusively on pivot tables that are generated from a single table of data. Data Model feature has brought additional advantages to pivot charts. With the Data Model, we can ...

## How to create a pivot table report in Excel

You can convert a huge table of data into an attractively printed report using a pivot table. The following figure shows a small portion of a pivot table. This pivot table is created from a data ...

## A Pivot Table Example in Excel with Real Data

We are going to work with a pivot table example in this section. We shall learn some useful ways to work with pivot tables. The following figure shows part of a data table with 3,144 data rows. ...

## How to Create a Pivot Chart in Excel!

With a pivot chart, you can graphically represent the data summarized in a pivot table. If you know how to create charts in Excel, you’ll face no problem creating and customizing pivot charts. All ...

## How to Reference PivotTable Data in Excel Formulas with GETPIVOTDATA?

In this article, I have shown you how you can reference PivotTable Cell Data in Excel formulas using GETPIVOTDATA function. If you feel uneasy with the auto implementation of GETPIVOTDATA function in ...

## How to Create a Timeline in Excel to Filter Pivot Tables!

A Timeline is conceptually similar to a Slicer, but Timeline is specially designed to simplify time-based filtering in a pivot table. Note: Timeline is a new feature in Excel 2013. You will use ...