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

Self-Paced Course

Excel Pivot Tables & Charts

Explore and analyze your data instantly using Excel Pivot Tables & Pivot Charts, and complete 10 real-world case studies along the way.

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

Not Sure Which COURSE or PATH is right for you?

Take our customized survey to find the perfect courses & paths for your skill level and goals!

Course Description

Pivot Tables are absolutely essential tools for data exploration in Excel, allowing you to instantly sort, filter, and analyze your data while keeping your source tables intact.

Consider this course a master class in Pivot Tables and Pivot Charts. We'll show you when, why, and how to use core tools and techniques, introduce advanced sorting, filtering, and calculation options, and guide you through interactive, hands-on demos and pro tips each step of the way. In the final section, we'll apply our skills to 10 real-world case studies, including burrito ratings, shark attack records, stock quotes, wine tasting scores, and more.

Whether you're looking for a quick primer or hoping to ramp up your analytics skill set, you've come to the right place.

Course Outline

WHO SHOULD TAKE THIS COURSE?

  • Excel users who want to build a solid foundation for advanced analytics

  • Analysts or BI professionals looking to extract insight and meaning from raw data, using expert-level PivotTable techniques

  • Anyone seeking to improve productivity and work more efficiently with data

WHAT ARE THE COURSE REQUIREMENTS?

  • Microsoft Excel 2010+ or Office 365, ideally for PC/Windows

  • Mac users are welcome to join, but may have challenges following along

Are you ready to become a DATA ROCKSTAR? Start learning today with your FREE 7-Day trial!

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?

Sign up today for a 7-Day Free Trial and start learning today!

Sign Up for Free