About this course

Need to build on your existing skills and enhance your Microsoft Excel abilities with PivotTable and Charts?

Building upon Microsoft Excel Foundations, this course will equip you with the skills to develop your own spreadsheets, incorporating tables, creating charts, and graphics to best communicate your data. Add this 3.5 hour workshop to your portfolio to lift your Microsoft Excel game.

Delivered by an experienced Microsoft Office trainer (in person at our Rozelle Computer Training Lab), this course will teach you how to make the most of this powerful data analysis tool.

Further, this course compliments the Microsoft Excel – Intermediate Formulas, Functions and Lists 

class, also held on the same day, and you are encouraged to undertake both courses to maximise your learning potential.

As a participant, on course completion, you will receive a manual to provide you with additional guidance for use in the workplace.

Who should attend?

This course is appropriate for any staff member experienced with Microsoft Excel who need additional skills in creating PivotTable and charts.

What will you learn?

By the end of this course, you will be able to:

Use Microsoft Excel PivotTable to calculate, summarise, and analyse data – topics include:

1. Create and format pivot tables
2. Value (for example change from sum/count)
3. Filtering in pivot tables
4. Slicing in pivot tables
5. Grouping by date and solving grouping problems

Use Microsoft Excel charts to help visualise your data – topics include:

1. Creating charts with quick chart
2. Types of charts
3. Inserting charts as floating object
4. Category versus Legend
5. Change source data
6. Labels, axis, gridlines, series
7. Using REPT() function for graphic display
8. Sparklines
9. Conditional formatting data bars

Apply now

Course Feedback

Previous participants in this program told us they would recommend this course to others and that they feel more confident working with Microsoft Excel PivotTable and charts.

“The instructions and tips were so helpful with building spreadsheets”.

“Having the manual to work and take home was a real bonus”.

“Trainer was excellent and really knew Excel”.