-
Computing
Summarise and Analyse Data with Microsoft Pivot Tables
-
Attendance / Duration
1 Day (9:30am - 4:00pm) ONLINE
-
Cost
£220
Book / Enquiry
Wednesday 15th May (Kilmarnock Campus) - Book here
Thursday 13th June (Online) - Book here
Thursday 11th July (Ayr Campus) - Book here
To be added to our waiting list for future course dates please email businessgrowth@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
- This course will cover the following:
- 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.
Places available
Campus
Kilmarnock
Start Date
17 Apr 2024
Places available
Campus
Kilmarnock
Start Date
15 May 2024