Excel Pro Tips: Pivot Tables
Learn advanced PivotTable techniques like grouping values, applying complex filters, reviving data from cache, and defining custom sort lists.
The Excel PRO TIPS series is designed to transform everyday Excel jockeys into certified power users, by featuring the same tools and techniques used by top pros and MVPs.
In this course we'll focus on one of Excel's most powerful and flexible analytics tools: PivotTables. We'll start with some common topics like slicers, table layouts and field list options, then dive into more unique use cases like grouping values, enabling multiple filters, reviving source data from cache, defining custom sort lists, and more.
It's time to start working smarter, not harder. If you're ready to slice, dice and filter your data like a PivotTable pro, this is the course for you.
- Course Structure & Outline
- DOWNLOAD: Course Resources
- Setting Expectations
- Customizing the Field List
- Autofitting Column Width
- Outline & Tabular Layouts
- Counting Non-Numerical Fields
- Grouping Dates
- Enabling Multiple Filters
- Grouping Values
- Adding Value Calculations
- Showing Empty Items
- Configuring Slicers & Timelines
- Conditional Formatting
- Removing & Reviving Source Data
- Adding Custom Sort Lists
- Solve Order & List Formulas
- QUIZ: PivotTable Tips
- Course Feedback Survey
- Share the love!
- Next Steps
WHO SHOULD TAKE THIS COURSE?
Excel users who want to explore, analyze and manage data more effectively
Analysts or BI professionals looking to build custom, PivotTable-based reports, dashboards, or analytics tools
Anyone seeking to explore some of Excel's most useful PivotTable tools & techniques
WHAT ARE THE COURSE REQUIREMENTS?
Microsoft Excel 2007-2019+ or Office 365 for PC/Windows (some demos may be unavailable for Mac or Excel Online)
Completing the full Excel Pivot Tables & Pivot Charts course is recommended, but not required
Start learning for FREE, no credit card required!
Every subscription includes access to the following course materials
- Interactive Project files
- Downloadable e-books
- Graded quizzes and assessments
- 1-on-1 Expert support
- 100% satisfaction guarantee
- Verified credentials & accredited badges
Ready to become a
Start learning for free, no credit card required!