Excel – Data Handling and Analysis with PivotTables & PivotCharts

Course Times

• 1pm to 4pm

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.