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

How to do scenario analysis in Excel? How to generate/create a scenario summary report using the Excel scenario manager feature? You will learn all ...

### How to Create a Two Variable Data Table in Excel

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide. In this article, we're going to create a ...

### 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 the Excel What-If ...

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

### Monitor Cells with Excel Watch Window!

Sometimes we have a great deal of data in the workbook. Everything is important but most important is the last row of the data containing, say, the ...

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

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

### 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. The Data Model feature has brought additional ...

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

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

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

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

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

### What is a Slicer in Excel

A Slicer is an interactive control. A Slicer makes your job easy to filter data in a pivot table. The following figure shows a pivot table with three ...

### How to Filter Excel Pivot Tables with Slicers!

Before proceedings to our main topic, you need to know what is actually a Slicer. What is a Slicer A Slicer is an interactive control. A Slicer ...