Microsoft Excel Intermediate

Course Description

This course has been developed for people wanting to utilise Excel to perform calculations using a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells.

Performance Based Objectives

• Understand and use a range of common worksheet functions
• Understand and utilise Absolute Referencing
• Organise a database list by advanced filtering and subtotalling
• Utilise Conditional Formatting to change cell appearance
• Create and modify charts to create static dashboards

Course prerequisites

Participants will need to have attended or be familiar with the topics covered in the Microsoft Excel Introduction course.