Part VI: Pivot Tables, Downloadable Version
- By Bill Jelen
- Published Mar 21, 2013 by Que. Part of the LiveLessons series.
Downloadable Video
- Sorry, this book is no longer in print.
- 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.
Description
- 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
More Information
Other Things You Might Like
