Ayrshire College homepage
Back to all courses

Microsoft PivotTables and Power Pivot - Analyse Multiple Data Sets

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

  • Qualifications Other Programmes
  • SCQF Level SCQF Level 5
  • Study mode Professional Learning
  • Campus Ayr
  • Start date On-demand
More information

Attendance / Duration

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

Overview

This 1 day course is suitable for individuals who want to enhance their data manipulation and analytical capabilities for business intelligence and reporting tasks.

Cost

£TBC

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?

Excel has a range of power tools which will greatly enhance your data analysis. A PivotTable is a powerful tool to calculate, summarise, and analyse data that lets you see comparisons, patterns, and trends in your data.

With standard pivot tables, you are limited to only one table of data.

Power Pivot enables you to import millions of rows of data from multiple sources and create relationships between the different tables of data. You can then build pivot tables and pivot charts to analyse the data.

This course is suitable for individuals who want to enhance their data manipulation and analytical capabilities for business intelligence and reporting tasks.

Participants should have should have a good understanding of Microsoft Excel, including basic data manipulation, formulas, and familiarity with PivotTables and PivotCharts. This course is not suitable for those new to pivot tables.

Microsoft Office 2016 or above is required.

Please note: The Excel Power Pivot add-in should be enabled before attending the course if using own device.

Course Content

  • Importing data into Power Query
  • Creating relationships between data sources
  • Using formulas to add new data and analyse data
  • Creating KPIs to use in pivot table reports
  • Creating pivot table reports and charts from multiple tables
  • Filtering pivot tables

On completion of this course participants will be able to leverage Power Query to import, clean, and transform data from various sources, and then utilise Power Pivot to create dynamic data models and perform sophisticated data analysis.