This live, facilitator led MS Excel PivotTables/PivotCharts training course is delivered to you online at your computer. You still have all the benefits of interacting with our facilitators in real time, just at your office or home desk. You can ask questions both during the training and afterwards with our free post course help desk.
Course Times
- 1pm to 4pm AWST (Perth local time)
Course Content
Preparing Data
- Understanding your source data & its limitations
- Importing/exporting data
- Removing duplicates
- Splitting columns
Store Data
- Understanding Excel lists and Excel tables
- Creating an Excel table
- Working with Excel tables
Analyse Data
- Understanding PivotTables
- Creating a PivotTable
- Manipulating PivotTable fields
- Working with data calculations
- Counting in a PivotTable
- Displaying values as the percentage of total
- Grouping in PivotTable reports
- Creating calculated fields and items
- Sorting in a PivotTable
- Updating data
- Adding and changing records in the PivotTable data source
Display Data
- Formatting Pivot Table values
- Assigning custom names
- Working with slicers
- Working with the timeline
- Creating PivotCharts
- Working with PivotChart elements
Advanced Pivot Tables
- Combing multiple PivotTables
Further Development
Continue building your skills with these related Excel courses:
Microsoft Excel – Analysing Data using Power Query
This course is designed to introduce you to the Power Query tool within Microsoft Excel. You will gain the practical skills to transform data from a variety of difficult dumped data formats into a useable table structure for further analysis.
Microsoft Excel Advanced
Objectives of this course are to enable experienced users of Microsoft Excel to increase their knowledge of the advanced features of this powerful spreadsheet application.
Get in touch
Excel in business with our premier Microsoft Excel training and more. Whether you’re looking to upskill through training or need tailored support through our consultancy services, we’re here to help.
To learn more about our Microsoft Excel course or how we can support your data goals, please contact us today or give us a call on (08) 9218 9059.
On completion of this course participants will be able to identify and prepare Excel data for analysis, create and manipulate PivotTables and PivotCharts.
Completion of Excel Intermediate course or equivalent knowledge is required.
