Latest Posts

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

Creating a pivot table in a worksheet connecting to another worksheet in the same workbook

Sometimes it may be useful to create several pivot tables in a worksheet connecting data source in another worksheet in the same workbook. Say you ...

How to rename a default group name in Pivot Table

When you group some items in a pivot table, Excel provides a default group name such as Group1 for selected items, or Jan for dates in the month of ...

Excel Pivot Table Auto Grouping by Date, Time, Month, and Range!

The ability to combine items in groups is one of the most useful features of a pivot table. You can group items that are placed in the ROWS or ...

ExcelDemy
Logo