Overview

Note - there are two sessions on Excel Pivot Tables for Friday 27th March 2020 - Introduction session at 10am and this Advanced session at 11.30am - €40 per seat, €60 if you join both sessions

A pivot table is a reporting tool that produces 3D reports from spread sheet data. This session covers the more advanced features of Pivot Tables. Participants should be able to create a basic Pivot Table or have attended the Introduction virtual session.

Duration: 1 hour

Method of Delivery: Virtual

Topics:

· Review of the steps to create a Pivot Table

· Pivot Table Options for Formats, Totals and Filters, Display, Printing and Data options

· Update and refresh a pivot table when the source data is changed

· Sorting Field Items

· Grouping Fields (Date fields / Numeric fields)

· Turning on / off subtotals in the Table

· Create a Pivot Chart

· Field Settings for data analysis within the Table

· Creating Formulas in the Table – Calculated Fields / Calculated Items

· Drilldown options

· Using the Design options

· Creating a Pivot Chart

· Chart options

· Using Slicers and Timelines with a Pivot Table