Mastering Excel Pivot Tables by Futurelearn
Enhance your data analysis skills and harness the potential of Excel pivot tables to measure business performance.
Course Highlights
- Demonstrate the creation and styling of a variety of pivot tables.
- Apply updates and filtering options to pivot tables.
- Calculate custom fields and apply pivot table connections.
- Discuss sophisticated and dynamic data visualisations from pivot tables.
Skills you will learn!
Curriculum
8 Topics
Getting started
Introduction to Week 1
Summarising data sets into pivot tables
Understanding areas of a pivot table
Exploring pivot table styles and style options
Layouts and interrogating a pivot table for results
Assessment
Bringing it all together
6 Topics
Introduction to Week 2
Refreshing the data
Updating the data source
Filtering options
Assessment
Bringing it all together
6 Topics
Introduction to Week 3
Exploring built in calculations
Calculating custom fields
Connecting data sources
Assessment
Bringing it all together
7 Topics
Introduction to Week 4
Creating pivot charts
Creating pivot filters
Exploring chart options
Assessment
Bringing it all together
What's next?
Mastering Excel Pivot Tables
Related Pivot Tables Courses
Thank You!
Your review has been submitted successfully.