(08) 9383 8000
Excel - PivotTables and PivotCharts
Level - Advanced
This course concentrates on creating PivotTables and PivotCharts to present business data for analysis. It also focuses on how best to manage the underpinning business data using List Management techniques.
1 Day
Overview
The Excel Pivottables and Pivotcharts course will give you an understanding of how to set up the data to be analysed using Tables. After completion of this course you will be able to create PivotTables and PivotCharts, group items and filter data and build formulas to better analyse your business data.
Content
- Work with business data using List Management (Tables)
- Create PivotTables
- Group items
- Filter data using Slicers
- Add formulas to the PivotTable using Calculated Fields
- Create PivotCharts
- Format PivotCharts.
Learning Outcomes
Participants should be able to:
- Set up the data to be analysed using Tables
- Create PivotTables and PivotCharts
- Build formulas to better analyse the business data.
Level - Fundamental
Using Microsoft Word efficiently will help you create good looking documents quickly. This course develops essential Word skills needed to create, edit, format and print documents.
Level - Advanced
This course builds on the Power BI Desktop - Level 1 course. It introduces you to more advanced DAX (Data Analysis Expressions) concepts including variable and advanced functions.
Level - Fundamental
This course provides you with the skills needed to create highly professional slides and presentations with Microsoft PowerPoint.
Level - Advanced
This course introduces the visualisation layer of Microsoft’s Power BI Desktop called Dashboards.