Meet the Guide Editor
Pivot Table Contributors

Guide to Excel Pivot Tables

Excel logoPivot tables provide a way to redisplay the data in a spreadsheet independent of its original layout and can be used to produce reports or summaries in a more readable fashion. These tables are one of the most powerful tools available in Microsoft's Excel software program, and learning how to use them effectively allows you to get the most out of an Excel spreadsheet.

This pivot table guide will show you how to create these tables and presents a number of scenarios where this powerful function can be useful. You will also find tips and tricks that will make your pivot tables look more polished and professional.

Latest Articles on Pivot Table
An Advanced Lesson Plan for Excel

Excel is the most commonly used spreadsheet package in the world, not least because it comes as part of Microsoft Office. This is a lesson plan for an advanced training course for Excel...

Microsoft Excel: Replace Blanks In A Pivot Table With Zeroes

Problem: Since you had no sales of a particular product in a particular region, Excel leaves those cells in the pivot table blank, as shown in Fig. 869. This seems like a really...

Microsoft Excel: See Detail Behind One Number In A Pivot Table

Problem: One number in the Pivot Table seems to be wrong. For example, maybe the Government region does not typically buy a certain product line from you, yet they are shown with...

Microsoft Excel: Group By Week In A Pivot Table

Problem: In the last example you noticed that the Grouping dialog allows you to group by second, minute, hour, day, month, quarter, and year. You need to group by week....

Most Popular Articles on Pivot Table
More About Pivot Table
Microsoft Excel: Eliminate Blanks In The Outline Format Of A Pivot Table

Problem: You have created a pivot table report and want to use this data as a database in another workbook. The pivot table report always uses this outline format. It may look great...

Microsoft Excel: Suppress Totals In A Pivot Table

Problem: Pivot tables are sometimes used just as an intermediate step in order to reach another result. If you are going to be copying the data to a new workbook that will be used...