Register your product to gain access to bonus material or receive a coupon.
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.
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