Categories
Badges
User Profile
Sharer Hub
Close
Summarise & Analyse Data with Microsoft Pivot Tables
This 1 day course is designed to provide participants with a solid foundation in creating and utilising pivot tables in Microsoft Excel.
Provider
Ayrshire College, Scotland (A mix of both online and in-person sessions)(For price, check with provider)
Enquire via the Ayrshire College website.
Description
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 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.
About Ayrshire College
Our aim is to serve the people, communities and employers across Ayrshire. Ayrshire College plays a key role in helping to develop the economy in Ayrshire, by ensuring that students develop the right skills and positive attitudes to support the local, regional and national workforce needs. Ayrshire College offers a range of courses targeted at individuals who are looking to develop their professional or technical skills and those who are simply interested in the joy of learning. We are offering, on-line, face-to-face and a mix of day and evening classes across a range of subjects including leadership and management, digital skills, and aeronautical sector specific courses All forthcoming courses are outlined here and on our website and we will continue to develop new offerings over this year and beyond so please watch this space! Book your place now and we look forward to supporting your training.
