PivotTable I: Get started with PivotTable reports in Excel 2007

Course overview art

Make sense out of data. Learn about Microsoft Office Excel 2007 PivotTable reports, a fast and powerful way to analyze data and answer questions you have about it.

Start course button

About this course

This course includes:

  • One practice session for hands-on experience. The practice session does not require you to have Excel 2007 on your computer.

  • A Quick Reference Card you can take away from the course.

Goals

After completing this course you will be able to:

  • Use a PivotTable report to analyze and summarize your data.

Topics in this course

  1. Make your data work for you

  2. Review your source data

  3. Get started

  4. PivotTable report basics

  5. Build a PivotTable report

  6. See sales by country

  7. See sales by date

  8. Pivot the report

  9. Where did drag-and-drop go?

  10. Practice

  11. Quick reference card

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language