Microsoft Excel Intermediate training

Course duration

(we will customise to your learning requirements and timeframe)

Target audience

This course is designed for those who need to know how to use formulas and functions in Microsoft Excel. Upon completion of the course, participants will be able to edit, group and delete worksheets, use simple formulas and functions and create basic charts.

Download the PDF Course Outline.

Course Objectives

At the end of the course participants will be able to:

• Use edit shortcuts to assist with inserting rows and columns
• Use AutoFill to create lists such as days of week, months, fortnightly pay periods, roster groups
• Work with formulas and functions to perform more accurate calculations within cells to produce totals, subtotals or averages
• Build formulas between worksheets to allow easier data management such as inclusion of summary pages
• Add formatting to cells, rows and columns such as currency, percentage, date, time
• Print whole worksheets or selected data and solve printing problems
• Create and modify a chart by using various charting techniques