Microsoft Excel PivotTables / PivotCharts

Course Times

• 1pm to 4pm

Course Content

Preparing Data for Analysis

• Understanding your source data & its limitations
• Importing/exporting data

PivotTables

• Understand PivotTable
• Creating PivotTables
• Dropping fields into a PivotTable
• Manipulating PivotTable fields
• Working with data calculations
• Working with the slicer

PivotTable Features

• Using compound fields
• Counting in a PivotTable
• Formatting PivotTable values
• Working with PivotTable totals
• Finding the Percentage of total and the Difference from
• Grouping in Pivot Table reports
• Creating calculated fields and items
• Providing custom names
• Sorting in a PivotTable

PivotCharts

• Creating PivotCharts
• Working with chart elements
• Advanced chart options

• Better understand how PivotTables can help you to make sense of large data sets
• Use field grouping techniques to extract meaningful summaries of your data
• Create PivotCharts from your data

Completion of Microsoft Excel Intermediate course or equivalent knowledge is required.

“The skills I learnt will help me tackling future projects” Sheryl from Dept. of Finance

“This course was extremely factual without overwhelming me with information” Tiffany From Dept. of Training and Workforce Development

“Very well prepared. It was great that all the files were ready to go and easily accessible, meaning we could focus our time on the content. The handout was also very easy to follow and is a great takeaway from this course” Jade from Dept. of Training and Workforce Development

“Good explanation of the utility of Pivot Tables in categorising and sorting data” Alex from Landgate

“Good course with relevant and useful tools. I would recommend to others in my area” John

“The best feature of this course was the use of multiple examples and how they tied into the workbook” Rennie from Rio Tinto

“Trainer was extremely helpful and flexible in answering all queries” Lisa

“I enjoyed the hands-on approach and comfort of completing tasks together and at the same pace” Kelly from WA Salt Supply

“The best features were the simple instruction provided along with a step by step guide” Siti from BHP

“Clear examples and the right pace for beginners like myself” Cathy from City of Busselton

“The presenter knowledge and pace of the course was excellent. I am highly likely to recommend ATI-Mirage” Mary