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
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
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
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
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
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
In this article, we look at how to use a pivot table to group voting data by age. This is a good example of the "group by number" feature that all pivot tables share.Read more
One of the 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
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
A pivot table is a handy tool for estimating projects. As long as the data is well structured, a pivot table can easily handle hundreds or even thousands of line items. You can group these items by category, by phase, by contractor, and so on. Once the pivot table is created, you can easily...Read more
To group a pivot table by day of week (e.g. Mon, Tue, Wed, etc.) you can add a helper column to the source data with a formula to extract the weekday name, then use the helper to group data in the pivot table. In the example shown, the pivot table is...Read more
To create a pivot table with a filter for day of week (i.e. filter on Mondays, Tuesdays, Wednesdays, etc.) you can add a helper column to the source data with a formula to add the weekday name, then use the helper column to filter the data in the pivot table...Read more
Pivot tables have a built-in feature to calculate running totals. In the example shown, a pivot table is used group data by month and show both the monthly total and running total over a 6-month period.
The source data contains three fields: Date,...Read more