Home > Store

Power Excel 2007: Pivot Tables, Downloadable Version

Power Excel 2007: Pivot Tables, Downloadable Version

Downloadable Video

  • Your Price: $6.79
  • List Price: $7.99
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Additional sample videos, individual lessons and other formats are available here.

Register your product to gain access to bonus material or receive a coupon.

Audio & Video

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.


  • Copyright 2010
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-7897-4616-6
  • ISBN-13: 978-0-7897-4616-0

Pivot tables are the favorite feature in Excel. You can take 500,000 rows of data and reduce it to a useful summary in six clicks. These 15 lessons take you through everything you need to know to use pivot tables successfully.

Topics covered include:

  • Creating a Pivot Table
  • Changing a Pivot Table
  • Pivot Gotchas
  • Pivot Sorting
  • Drill Down
  • Summarizing Dates
  • Top 10 Report
  • Pivot Calculations
  • Pivot Formatting
  • Unique List
  • Ad-Hoc Queries
  • New Pivot Filtering Options
  • 50 Reports in 5 Seconds
  • Pivot Compatibility with 2003
  • Making Reports Pivotable


Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership