Excel 365 Tables & Pivot Tables

Overview

At the end of the course delegates will be able to create an Excel Table, change its formatting and perform simple analysis using the Totals Row.  Delegates will know how to create Pivot Tables, change the analysis the Pivot Table performs, and present the data in a Pivot Chart.

This course will enable you to

Excel Tables

• Create an Excel Table
• Add a calculated column
• Analyse data with the Totals Row

Analyse Data with Pivot Tables

• Create a Pivot Table
• Re-Pivot the table, using different fields
• Drill down to see underlying data
• Refresh a Pivot Table

Changing Pivot Table Design & Formatting

• Change Pivot Table layout
• Summarise data in different ways
• Understand how table filters work
• Use a Slicer to filter data
• Present results as percentages
• Analyse data by time period
• Present data with a Pivot Chart

Who is the Course aimed at

Anyone who works with tables of data that need to be summarised and analysed in Excel 365.