SPECIAL OFFERS
Keep up with new releases and promotions. Sign up to hear from us.
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.
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