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
Starting to analyse data with PivotTables and PivotCharts in Excel.