-
Business
Microsoft Excel Pivot Tables
-
Attendance/Duration
Delivery Method: Face to Face delivery
Course Duration: 6 hours (1 day)
Delivery Method: Online Delivery
Course Duration: 4 hours total. 2 x 2 hours live interactive tutorial sessions
-
Cost
For further information on course dates and prices please email businessgrowth@ayrshire.ac.uk

Whats 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 suitable for those with a basic knowledge of pivot tables who want to be able to summarise and display useful and relevant information to enhance decision making.
This course will cover the following:
- Creating more advanced pivot tables
- Using slicers and timelines
- Grouping items in pivot tables
- Changing measurement units
- Copying pivot tables
- Using calculated fields and items with pivot tables
- Consolidating ranges using pivot tables
- Creating pivot table relationships
- Refreshing pivot tables
By the end of this course participants will learn how to summarise, group and display large amounts of data to communicate relevant information.
Funding and Fees
For further information please email businessgrowth@ayrshire.ac.uk
Enquiries
For further information please email businessgrowth@ayrshire.ac.uk