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

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

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