Introduction to PivotTables & PivotCharts

Description

When trying to analyse large-scale data, Pivot tables can help you quickly summarize data, revealing inherent relationships and trends. Pivot Charts can then enable you to visually see these connections.

The webinar will step through the process of creating both Pivot Tables and Pivot Charts including:
- Defining the PivotTable structure
- Filtering and using slicers
- Formatting PivotTables
- Using Calculated fields
- Defining the PivotChart structure
- Filtering PivotCharts

Suitable for Accountants or financial professionals who need to analyse or provide reports on data, particularly of a large scale.

This webinar will be presented using Microsoft Excel 2016, however the content will also be relevant and of interest to users of Excel 2013 and 2010. 

Webinar Learning Outcomes:
A demonstration of the processes involved in creating, filtering and viewing PivotTables and PivotCharts. Attendees will be able to take techniques used and apply them to analyse large-scale data.

Suited to:
Accountants at all levels across all industries.

Presenter bio:                                                                                                                                             For over 20 years, Jason Leiper has provided leadership while training in qualified systems, business and information management training in government, while also training in universities and private circles.

You will be provided with:
• PowerPoint presentation slide deck
• Supporting documentation
• Webinar Recording to view multiple times for up to 6 months
• An opportunity to ask questions to the presenter

Starting to analyse data with PivotTables and PivotCharts in Excel.

  • Webinar Recording
    • PD hours: 1
    Stream this recording multiple times at your convenience.
    • $180.00 incl. GST

Coming Soon

All Coming Soon >>

One-Connection-One-Fee

Our webinars operate on a 'one-connection-one-fee' basis so you can have your whole team participate for one cost effective price and claim CPD points.

Recordings

Like the topic but can’t make the time? Register for the Live Session and you’ll receive the Recording regardless! You can watch it as many times as you like for up to 6 months. You will also receive Supporting Documentation.