Expires in:
Expires in:
Expires in:
Self-paced course
Self-paced course
Excel Pivot Tables & Charts
Excel Pivot Tables & Charts
Rating 4.6
9,563 reviews
9,563 reviews
9,563 reviews
Course Description
Pivot Tables are essential tools for data exploration in Excel, giving you the power to sort, filter, and analyze data instantly—without touching your original source tables.
This course is a master class in Pivot Tables and Pivot Charts. You’ll learn when and how to use key tools, explore advanced filtering and calculation options, and follow along with interactive demos and expert tips. To wrap up, you’ll apply your skills to 10 real-world case studies—from burrito ratings to wine scores.
Whether you’re just getting started or looking to level up your analytics game, you’ve come to the right place.
Course Description
Pivot Tables are essential tools for data exploration in Excel, giving you the power to sort, filter, and analyze data instantly—without touching your original source tables.
This course is a master class in Pivot Tables and Pivot Charts. You’ll learn when and how to use key tools, explore advanced filtering and calculation options, and follow along with interactive demos and expert tips. To wrap up, you’ll apply your skills to 10 real-world case studies—from burrito ratings to wine scores.
Whether you’re just getting started or looking to level up your analytics game, you’ve come to the right place.
Course Content
16.5 video hours
Skills you'll learn in this course
Build PivotTables & PivotCharts that summarize in seconds
Slice & drill into details with interactive filters
Use calculated fields & grouping to customize analysis
Tell stories with dynamic, linked chart layouts
Meet your instructors
Chris Dutton
Founder & CPO
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.
Student reviews
Dear Maven Analytics, Thank you for the insightful Excel Pivot Tables & Pivot Charts course. The content was clear, practical, and greatly improved my skills. Looking forward to more courses!
Burhan Thekedar
Thank you Maven Analytics for this one new skill acquired.
Arthur
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
Excel Pivot Tables & Charts
Excel Pivot Tables & Charts
CPE Accreditation
CPE Credits:
0
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
*Last Updated: May 25, 2023
Course Description
Pivot Tables are essential tools for data exploration in Excel, giving you the power to sort, filter, and analyze data instantly—without touching your original source tables.
This course is a master class in Pivot Tables and Pivot Charts. You’ll learn when and how to use key tools, explore advanced filtering and calculation options, and follow along with interactive demos and expert tips. To wrap up, you’ll apply your skills to 10 real-world case studies—from burrito ratings to wine scores.
Whether you’re just getting started or looking to level up your analytics game, you’ve come to the right place.
Course Description
Pivot Tables are essential tools for data exploration in Excel, giving you the power to sort, filter, and analyze data instantly—without touching your original source tables.
This course is a master class in Pivot Tables and Pivot Charts. You’ll learn when and how to use key tools, explore advanced filtering and calculation options, and follow along with interactive demos and expert tips. To wrap up, you’ll apply your skills to 10 real-world case studies—from burrito ratings to wine scores.
Whether you’re just getting started or looking to level up your analytics game, you’ve come to the right place.
Curriculum
1
Orientation & Benchmark Assessment
1
Orientation & Benchmark Assessment
1
Orientation & Benchmark Assessment
2
Getting Started
2
Getting Started
2
Getting Started
3
PivotTable 101
6 MIN
6 MIN
3
PivotTable 101
6 MIN
6 MIN
3
PivotTable 101
6 MIN
6 MIN
4
PivotTable Formatting
6 MIN
4
PivotTable Formatting
6 MIN
4
PivotTable Formatting
6 MIN
5
Sorting, Filtering & Grouping
6 MIN
6 MIN
6 MIN
5
Sorting, Filtering & Grouping
6 MIN
6 MIN
6 MIN
5
Sorting, Filtering & Grouping
6 MIN
6 MIN
6 MIN
6
Calculated Values, Fields & Items
6 MIN
6 MIN
6
Calculated Values, Fields & Items
6 MIN
6 MIN
6
Calculated Values, Fields & Items
6 MIN
6 MIN
7
Pivot Charts
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
7
Pivot Charts
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
7
Pivot Charts
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
8
PivotTable Case Studies
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
8
PivotTable Case Studies
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
8
PivotTable Case Studies
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
9
Final Assessment
6 MIN
9
Final Assessment
6 MIN
9
Final Assessment
6 MIN
10
Course Feedback & Next Steps
10
Course Feedback & Next Steps
10
Course Feedback & Next Steps
Meet your instructors
Chris Dutton
Founder & CPO
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.
Student reviews
Dear Maven Analytics, Thank you for the insightful Excel Pivot Tables & Pivot Charts course. The content was clear, practical, and greatly improved my skills. Looking forward to more courses!
Burhan Thekedar
Thank you Maven Analytics for this one new skill acquired.
Arthur
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
Excel Pivot Tables & Charts
Excel Pivot Tables & Charts
CPE Accreditation
CPE Credits:
0
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
*Last Updated: May 25, 2023
More courses you may like
