Introduction to PivotTables & PivotCharts
Starting to analyse data with PivotTables and PivotCharts in Excel.
Stream this recording multiple times at your convenience.
- $180.00 incl. GST
- PD hours: 1
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.
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
|Magic bullets with Excel - data validations||Webinar Recordings|
|Mail Merge with Microsoft Word||Webinar Recordings|
|What-if Analysis Tools in Excel||Webinar Recordings|
|Business Analysis with Excel Part 3: PowerPivot, DAX and Excel||Webinar Recordings|