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

### How to Insert a Calculated Item into Excel Pivot Table!

In this article, I'll show you how you can insert a calculated item into an already created Excel Pivot Table. Some Excel users avoid these two items ...

### How to Create Pivot Table Calculated Field for Average

In this article, we shall show how you can create or add a pivot table calculated field for showing the average of two existing data fields. ...

### Multiple Groups from the Same Data Source

If you create more than one pivot table from the same data source, and you have created a group of items in a pivot table, this group will ...

### How to Make a Frequency Distribution Table & Graph in Excel?

You can make a histogram or frequency distribution table in Excel in a good number of ways. I have summarized total 7 methods in this article. In ... 