Download the 2007 Office release

Play Demo 

(Or download the demo.)

You may experience a delay while the demo is loading.

You have all the data for your sales report, and you want to make a dynamic presentation. With PivotTable reports in Microsoft Office Excel 2007, your sales report will sparkle with power, flair, and functionality. Show just the big picture, show all the details, or show anything in between.

Easily create multiple worksheets to switch back and forth between the various versions of your report. Sort, filter, and summarize your data any way you like. Even show the details of any summary value in your report. Quickly rearrange your data to spotlight different aspects of your data — change rows to columns and vice versa. And choose from a variety of professional-looking styles to make your report look great. In the demo, you'll learn how to do all this and more.

How to do it (text version):

Help topics

• Overview of PivotTable reports and PivotChart reports
• Create or delete a PivotTable or PivotChart report

Online training

• PivotTable I: What's so great about PivotTable reports?
• PivotTable II: Swing into action with PivotTable reports
• PivotTable III: Show off your PivotTable skills

 Problems watching the video? Try our troubleshooting tips.