Microsoft PivotTables - Summarise and Analyse Data

This course isn’t currently open for applications, but you can still register your interest.

More information

Attendance / Duration

1 Day (9:00am - 4:00pm)

Overview

This 1 day course is designed to provide participants with a solid foundation in creating and utilising pivot tables in Microsoft Excel. They will learn how to summarise, analyse, and present large datasets effectively, making data-driven decisions with ease.

Cost

£180

Enquiry

For further information or to be added to our waiting list for future course dates please email engage@ayrshire.ac.uk

What's Involved?

A PivotTable is a powerful tool to calculate, summarise, and analyse data that lets you see comparisons, patterns, and trends in your data.

This course is designed to provide participants with a solid foundation in creating and utilising pivot tables in Microsoft Excel. They will learn how to summarise, analyse, and present large datasets effectively, making data-driven decisions with ease.

Participants should have a basic understanding of Microsoft Excel, including working with worksheets, using functions and formulas, and basic data manipulation. It is not suitable for those at a beginner Excel level.

The course is suitable for those using Microsoft Office 2013 or above

Course Content

Preparing data for use in pivot tables
Creating a pivot table
Designing a pivot table
Formatting and sorting data
Grouping data
Filtering a pivot table
Creating charts from pivot tables
Creating a multi-level pivot table to view multiple metrics
Changing measurement units to display data in different ways
Updating a pivot table
Using calculations in a pivot table

By the end of this course participants will learn how to summarise, group and display large amounts of data to communicate relevant information.