Certificate of Achievement
has completed the following course:
How to Use Pivot Tables to Analyse Data in Excel
The Excel Club
This online course, the third course in a series of three from an Expert track covered Pivot tables, charts, and advanced charting techniques with Pivot data. This course equipped the student with the skills required to create professional Excel dashboards using Pivot data.
2 weeks, 2 hours per week
Paula Guilfoyle
CPA, Excel MVP
The Excel Club
Transcript
Learning outcomes
- Summarise data with Pivot Tables and Pivot Charts
- Design and Develop Interactive dashboards with Pivot tables and Pivot charts
- Apply advanced features and formatting to Pivot tables
- Pivot data with helper columns to create advanced charts and chart features
- Report on data using Pivot tables, Charts and Dashboards
Syllabus
- How to set up and work with basic pivot tables in Excel
- How to use advanced pivot table features in Excel
- Understanding GETPIVOTDATA
- Use Pivot tables to create interactive and dynamic dashboards
In association with
Issued on 18th May 2025
The person named on this certificate has completed the activities in the transcript above. For more information about Certificates of Achievement and the effort required to become eligible, visit futurelearn.com/proof-of-learning/certificate-of-achievement.
This certificate represents proof of learning. It is not a formal qualification, degree, or part of a degree.