Course
Skills
Pivot Tables for Excel
This course is aimed at intermediate-level users of Excel 2010 and later (including 365) who are unfamiliar with Pivot Tables and who need to summarize and analyze list-based data and make better business decisions based on that data.
What you'll learn
Pivot Tables are one of the most powerful tools in Excel's data analysis armory. With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily summarize and analyze large amounts of raw data and get answers to those important questions on which you base your key business decisions.
Table of contents
Course Overview
1min
Introduction to Pivot Tables
33mins
Customizations and Calculations
30mins
Sorting, Grouping, and Filtering
36mins
Pivot Charts and Data Visualizations
17mins
Creating a Basic Pivot Table Driven Dashboard
25mins