Overview

Excel can look busy and a little intimidating: a giant grid and a wall of buttons. The good news is that almost everything you will ever use lives in a handful of named areas, and once you can name them, the rest starts to make sense. This course is built to get you there, gently and at the keyboard.

You cannot break Excel by having a go. Nearly everything can be undone with Ctrl + Z. The fastest way to learn a spreadsheet is to click around in one.

Who It’s For

Beginners, and anyone who wants to tidy up skills they half-remember. No prior Excel experience is assumed beyond basic comfort with a computer: using a mouse and keyboard, and opening and saving files. It suits people heading into administration, retail, community services, and remote-community roles, where keeping a simple list, budget, or roster in a spreadsheet is part of the work.

What You’ll Work With

The practice files use everyday, work-ready scenarios rather than made-up data, so every skill lands on something familiar:

• A contact list for an office or community service, to practise data entry, sorting and filtering.
• Dave’s T-Shirt Shoppe, a small retail stock list, to work out profit with a simple formula.
• A weekly budget and expense tracker, to add up totals and find the average, biggest and smallest.
• An attendance and work-hours roster, to record hours and total them.
• An events register of Territory suburbs and people, to sort, filter and report on.

Resources