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:

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

Meet Your Instructor

Chris Dutton

Founder & Lead Instructor

Chris is an EdTech entrepreneur and best-selling Data Analytics instructor. As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world.

Qualifications

Best-selling Analytics & BI instructor
Certified Microsoft Excel Expert

Testimonials

"Truly amazing Excel course! Visually appealing platform, clear explanations supported with excellent project files, all in one! It makes the learning process a great joy and makes you eager to explore more with each lesson."

- Srdjan M.
"Such a great course, with a broad range of tips and tricks to fill the gaps in your excel knowledge. So many great lessons that will save me time and effort and help me do things I didn't even know were possible. Another brilliant course from Chris!"

- Ian A.
"I'm enjoying this course very much. Although I work with Excel on a daily basis and do pretty advanced stuff, I always learn something new or acquire a new perspective. I couldn't ask for anything more!"

- Francesca C.

Ready to become a

data rockstar?

Start learning for free, no credit card required!