Digital skills for business: analysing, handling and presenting data with Excel (intermediate)

About this course

The course examines how data can be handled and presented in workplace situations using Excel. Learners create automated budget sheets with functions, formulae and conditional formatting, including profit, loss and expenditure calculations. They link information across worksheets, identify trends and summarise data with pivot tables. Teaching uses guided, step-by-step tasks, with learners working independently and collaboratively on business-focused activities. The course also covers selecting suitable chart types and presenting data so that key information is clear and easy to interpret.

What you'll learn

• Create automated budget sheets using functions, formulae and conditional formatting
• Link related data across multiple Excel worksheets
• Identify and calculate trends in workplace data
• Summarise datasets using pivot tables
• Select and create charts to present data effectively

Is this course right for you?

This intermediate course is intended for learners who are already confident with Excel’s basic functions and want to apply them to workplace data tasks. Sessions involve both individual and group activities, with guided support from the tutor. Some work outside class is required, using Google Classroom.

• Basic Excel functions are expected
• Learners complete tasks independently and with other students
• Work outside the classroom forms part of the course

Before you go

• Learners should bring a pen, lined A4 paper and a file for keeping their work.
• Handouts and a Google Classroom code are provided for accessing online materials and communicating with classmates.