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
  •  
    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 bad idea. You’ve...

  •  
    Microsoft Excel: Specify A Number Format For A Pivottable Field

    Problem: In a pivot table, a Data field will tend to inherit the numeric formatting assigned to the data in the original dataset. This may not always be correct. At a detail level, it might be appropriate...

  •  
    Microsoft Excel: Present A Pivot Table In High-To-Low Order By Revenue

    Problem: A Pivot Table organizes data alphabetically by default, as shown in Fig. 892. You want to produce a report sorted high-to-low by Revenue....

  •  
    Microsoft Excel: Calculated Fields In A Pivot Table

    Problem: You need to include a calculation in the pivot table that is not in your underlying data. Your data includes Quantity Sold, Revenue, and Cost, as shown in Fig. 980. You would like to report...

  •  
    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 for Windows 2007...

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



Popular Pages



More Info

Meet the Guide Editor
Pivot Table Contributors