Find out more

About

Discover a wider array of Excel functions to analyse data. This course will give you an overview of basic and advanced features of Excel's PivotTable tool which can rearrange and summarise huge data sets without using complex formulas. You will also explore PowerPivot, one of Excel's most popular Power Tools, which enables data analysis across multiple tables or data sets, from different data sources.

CPD: 1 hours

Full Programme

Table, Filter and Sort Features

  • How do you set up a table in Excel?
  • How do you filter data?
  • How do you sort data and apply conditional formatting?
  • How do you extract data based on a single criterion?
  • How do you extract data based on multiple criteria?

Basic Pivot Tables

  • What is a pivot table?
  • How do you create a pivot table?
  • What are the options for summarising values in a pivot table?
  • How do you show different calculations in pivot table value fields?
  • How do you group dates in a pivot table?
  • How do you add a report filter to a pivot table?

Advanced Pivot Tables

  • How do you add a calculated field to a pivot table?
  • How do you insert a calculated item into a pivot table?
  • How do you format a pivot table?
  • What does the GETPIVOTDATA function do?
  • How do you add slicers and timelines to a pivot table?
  • How do you create a pivot chart?

Power Pivot

  • What is Power Pivot?
  • How do you create a linked table?
  • How do you create relationships between tables?
  • How do you set up a pivot table in Power Pivot?
  • What is DAX?

Course leader

Paula Guilfoyle is a member of the Institute of Certified Public Accountants in Ireland. She practiced in Industry for over 15 years, working with both small and large private companies, before moving on to teach Excel and Power BI to accountants and professionals. Paula has given many talks and presentations in the areas of Excel, spreadsheet use, PowerBI and business intelligence, and has published many articles on the same subjects.

Booking information

This course is free

Book your place

Search ICSA