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.
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 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
|What-if Analysis Tools in Excel||Webinar Recordings|
|Microsoft Excel PivotTables 2016||Webinar Recordings|
|Power BI with Excel: Overview||Webinar Recordings|
|Business Analysis with Excel Part 2: Connecting Excel to the World of Data||Webinar Recordings|