Latest Posts

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

How to create a pivot table from non-numeric values/data

In this article, you will learn how to create a pivot table from non-numeric data or values. It's really fun. Let's start... From our previous ...

Copying Excel Pivot Table!

A pivot table is very flexible, but it has several limitations. Say you can't add new rows or columns to a pivot table, though you can add rows or ...

How to Modify an Excel Pivot Table

After you have created your pivot table, it is easy to change it. For example, you can add more summary information by using the PivotTable Fields ...

ExcelDemy
Logo