CELEBRATE EARTH WEEK
Save 70% on video training and simulators now through April 27*—use code EARTH. Shop now.
Additional sample videos, individual lessons and other formats are available here.
Register your product to gain access to bonus material or receive a coupon.
Actual product comes full screen and in high resolution.
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