Excel Pro Tips: PivotTables

Explore and analyze your data with advanced PivotTable tools and techniques

 

What's Inside

ABOUT THE COURSE



This course is part of the Excel PRO TIPS series, designed to help everyday users develop expert-level skills by mastering the same tools and techniques used by top pros and Excel MVPs.

The series includes six separate Excel courses, including:

  • Excel Pro Tips: Productivity Tools
  • Excel Pro Tips: Formatting
  • Excel Pro Tips: Formulas & Functions
  • Excel Pro Tips: Data Visualization
  • Excel Pro Tips: PivotTables
  • Excel Pro Tips: Analytics Tools

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.



IMPORTANT NOTES:

  • This is a non-linear series, so you can jump to individual courses or lectures freely. Each video is an independent and self-contained demo, to help you learn with quick, bite-sized lessons.
  • Course includes a PDF ebook and downloadable Excel project file containing all demos and datasets, ranked by difficulty (1-5 stars), organized by category, and hyperlinked for quick access.

COURSE REQUIREMENTS:

  • Microsoft Excel 2007-2019 or Office 365 recommended (some tips may not apply to all versions)
  • This course is designed for PC users (some tools may not be available for Mac)

WHO SHOULD TAKE THIS COURSE:

  • Excel users who want to explore, analyze and manage data more effectively
  • Analysts or BI professionals looking to build PivotTable-based reports, dashboards, or analytics tools
  • Anyone seeking to explore some of Excel’s most useful PivotTable tools & techniques

Get started now!



Certificate Available
3934+ Students
21 Lectures
1+ Hours of Video
Lifetime Access
24/7 Support
Instructor Rating
Maven Analytics

Chris Dutton is a certified Excel Expert, EdTech entrepreneur, and best-selling instructor.


Chris has spent 10+ years specializing in data visualization and business intelligence. As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur.com, and the New York Times, reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics seeks to empower everyday people to change the world with data. Chris graduated summa cum laude and received the Charles G. Bluhdorn Prize in Economics at Tufts University.

Popular Bundles