Excel 365 Tables & Pivot Tables

  • 7 place(s) remaining
  • 14th Dec 21
  • 10am-11.30am
  • Remote Via MS Teams
    Remote via MS Teams
  • £20for members £for non-members

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.

Excel 365 Tables & Pivot Tables

  • 7 place(s) remaining
  • 14th Dec 21
  • 10am-11.30am
  • Remote Via MS Teams
    Remote via MS Teams
  • £20for members £for non-members
Book
Can't make this training?

Get notified when this
course is on next.

Get notified of next event