Looking for more? Try chatting with the Exceljet Chatbot.

Article

Pivot Table Tips

Many Excel experts believe that Pivot Tables are the single most powerful tool in Excel. This article provides more than 20 tips you should know to work productively with Excel Pivot Tables....Read more

Article

Excel Pivot Tables

Pivot tables are the fastest and easiest way to quickly analyze data in Excel. This article is an introduction to Pivot Tables and their benefits, and a step-by-step guide with sample data.Read more

Course

Core Pivot

Learn to use Excel Pivot tables to rapidly analyze data and create professional reports. This accelerated video training course guides you step-by-step.Read more
Term

Pivot Table

A Pivot Table is a special tool in Excel for summarizing data without formulas. The Pivot Table interface behaves like a report generator, allowing you to interactively add and remove fields as you like. The screen below shows the how fields have been configured to build the pivot table shown...Read more

Article

Can pivot tables save your job?

This article is for those of you who don't get pivot tables. Maybe you tried pivot tables once, and didn't see what the big deal was, or maybe you got frustrated when a pivot table wouldn't behave. They can be that way.Read more

Article

Excel Tables

Excel Tables have a boring (and confusingly generic) name, but they are packed with useful features. This article is a summary of the things you should know about Excel Tables.Read more

Formula

Get pivot table subtotal

To use the GETPIVOTDATA function, the field you want to query must be a value field in the pivot table, subtotaled at the right level.

In this case, we want a subtotal of the "sales" field, so we provide the name the field in the first argument, and supply a reference to the pivot table...Read more

PLC

Why Pivot Tables?

Quick Links Overview Why Pivot? Tips Examples Training Why Pivot Tables? This question comes up a lot when people are just getting started with pivot tables. You can try to explain how pivot tables are cool, how they make it easy to analyze data, how they're really good at summarizing in different...Read more
Formula

Get pivot table grand total

To use the GETPIVOTDATA function, the field you want to query must be a value field in the pivot table, subtotaled at the right level.

In this case, we want the grand total of the "sales" field, so we simply provide the name the field in the first argument, and supply a reference to the...Read more

Formula

Get pivot table subtotal grouped date

To use the GETPIVOTDATA function, the field you want to query must be a value field in the pivot table, subtotaled at the right level. When dates are grouped, they can be queried based on the numeric equivalent:

  1. Grouped by month - use numbers 1-12
  2. Grouped by quarter -
    3. ...Read more
Pivot Table

Pivot table remove deleted items

One of the quirks of pivot tables is that they may hold on to items that have been previously removed from the source data, even after refreshing the data. You may see these deleted "ghost" items when filtering a pivot table. In the example shown, the source data originally contained three...Read more

PLC

10 pivot table problems and easy fixes

With pivot tables, it's often the little things that are frustrating...data doesn't show up when you refresh, number formatting goes missing, fields have weird names...things like that. In this short video, we look at 10 common pivot table problems + 10 easy fixes. Here are the problems we look at...Read more
Video

How to clone a pivot table

Once you have one pivot table set up, you might want to see a different view of the same data. In this video, I'll show you how to base one pivot table on another...Read more
Video

How to make a self-contained pivot table

Each pivot table has a pivot cache, which is a true copy of the source data. In this video, we look at how the pivot cache works, and how it allows you to remove the source data from your workbook and still have a functional pivot table.Read more
Term

Excel Table

An Excel Table is a special object for managing data in Excel. Excel Tables have a name which appears in the name box when the entire table is selected. To quickly create an Excel Table, select any cell in the data, and use the keyboard shortcut...Read more

Video

How to group a pivot table by day of week

If you've used pivot tables at all, you understand the addictive power they give you for grouping dated information. You can group by year, by month, by quarter, and even by day and hour. But if you want to group by something like day of week, you'll need to do a little prep work first...Read more
Pivot Table

Pivot table show top 3 values

You can use a pivot table to display the top or bottom values in a set of data. In the example shown, one pivot table is used to show the top 3 scores in a set of data, and another pivot table is used to show the bottom 3 values in the same set of data. Because one pivot table...Read more

Pages