Introduction to PivotTables & PivotCharts
Starting to analyse data with PivotTables and PivotCharts in Excel.
Feb 28Tue 10:30 AM - Tue 11:30 AM Online
- $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.
Jason Leiper from Excel Consulting Solutions has provided leadership and qualified systems, business and information management training in government, university and private circles for over 20 years.
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
|The Best of Microsoft Word 2016||Webinar Recordings|
|Higher Quality Financial Modelling with Lower Risk Using MS Excel||Webinar Recordings|
|Introduction to Power BI with Excel||28 Feb|
|The Best of Microsoft Excel 2013||Webinar Recordings|