Your browser is not supported. Please download another browser to be able to use all of the Maven features.

Self-Paced Course

Excel Pro Tips: Pivot Tables

Learn advanced PivotTable techniques like grouping values, applying complex filters, reviving data from cache, and defining custom sort lists.

Course Hours3 hours
Skills Learned
Data Analysis
Tools
Excel
Course Level
Intermediate
Credentials
Paths

Course Description

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 CURRICULUM:

Course Outline

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
Sign Up Today

Ready to become a

data rockstar?

Start learning for free, no credit card required!

Sign Up for Free