Certificate of Achievement

Miriam Jafari

has completed the following course:

Mastering Excel Pivot Tables

The University of Adelaide

This online course way explored how to interpret data and communicate key business metrics to stakeholders. The course covered the ways data can be analysed and presented in order to track key performance indicators in real-time and identify trends to inform business decision-making.

4 weeks, 1 hour per week

Jennie Shaw

The University of Adelaide

88%
overall score

Transcript

Learning outcomes

  • 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.

Syllabus

Week 1: How do I create visually appealing pivot tables?

  • 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

Week 2: How do I calculate custom business metrics?

  • Refreshing the data
  • Updating the data source
  • Filtering options

Week 3: How can I connect multiple data sources?

  • Exploring built in calculations
  • Calculating custom fields
  • Connecting data sources

Week 4: How do I present data as a story?

  • Creating pivot charts
  • Creating pivot filters
  • Exploring chart options

In association with

Issued on 6th November 2024

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.

Free online course:

Mastering Excel Pivot Tables

The University of Adelaide