Analyse Multiple Data Sets with Pivot Tables and Power Pivot

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

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

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.

About Ayrshire College

Provider Avatar

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.

See more courses from Ayrshire College

Location

Scotland

Blended Learning

A mix of both online and in-person sessions.

Level

Intermediate

Style

  • Lots of Hands On
  • Some Reading & Writing
  • Lots of Watching
  • Lots of Listening
  • Some Socialising

Find out more, enquire or book via the Ayrshire College website.