Home > Store

Part VI: Pivot Tables, Downloadable Version

Part VI: Pivot Tables, Downloadable Version

Downloadable Video

  • Your Price: $8.49
  • List Price: $9.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 2013
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-13-344820-7
  • ISBN-13: 978-0-13-344820-7

Part VI: Pivot Tables

Probably the single most important feature of Excel covered in these 17 lessons. In less than two hours you’ll learn sweet skills that will make you the go-to person for cool spreadsheets!

54 Creating a Pivot Table

55 Changing a Pivot Table

56 Pivot Gotchas

57 Pivot Formatting, including Tabular & Repeat Item Labels

58 Drill Down

59 Pivot Calculations, Including % of Parent Row

60 Summarizing Dates, add Year-over-Year

61 Pivot Sorting

62 Filtering Row Fields

63 Top 10 Report, 4 Ways, including AutoFilter and Data Model

64 Filtering a Pivot Table with Slicers and Timelines

65 Pivot Tables - Slicers on Two Pivot Tables

66 50 Reports in 5 Seconds

67 Base on a table, force a new cache

68 Frequency Chart

69 Matching Two Lists

70 Using GetPivot Data


Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership