Microsoft Excel Intermediate
Microsoft Excel is an incredibly useful program that most workplaces use, however the vast majority of Excel users only scratch the surface of its capabilities.
This one-day course builds on basic skills, or the knowledge learned in the beginner’s course, as participants learn how to create a systematic approach to Excel formulas and tasks. Becoming more efficient at spreadsheets is just the start.
The course helps people to un-learn bad habits they’ve picked up from learning Excel on the job, teaches more efficient steps to achieve calculations and outcomes, and unpacks why Excel is used for tasks.
Participants will learn relative and absolute formulas, and shortcuts and methodologies when entering text, formulas and functions. You’ll also be exposed to a range of the built-in Excel functions like financial and logical calculations.
Create more professional spreadsheets and reports via essential shortcuts, formulas, and functions. Fast.
Who should attend?
People who seek to increase their digital literacy in the workplace and create more professional spreadsheets utilising essential shortcuts, formulas, and functions within Microsoft Excel. It’s perfect for Excel users who wish to extend their knowledge and skills beyond simple workbooks.
Recommended: We recommend participants have basic understanding on Microsoft Excel in order to do the Excel Intermediate course.
Note: this course is taught on a Windows PC platform and is therefore suitable for Windows PC users only. This course is not suitable for Mac OS users.
Duration
1 day
Study modes
Face-to-face, Live online, workplace
Fees*
$415
(unless stated, Swinburne Professional courses do not attract GST)
“This course exceeded my expectations by far. Our facilitator was so professional, a great teacher and very patient. Great examples were used during the course too.”
Vanessa
Microsoft Office

Short Course Outline - Microsoft Excel Intermediate
Download this course brochure for more information about the short course. This can also be given to your employer to pitch for funding or support of your program.
Swinburne Live Online Short Courses and Qualifications
Our Live Online training is delivered to you live, providing similar interactions as face to face training with the benefits of remote access. The training is delivered through video conferencing and discussion board platforms. Workshops are broken into interactive video sessions, including presentations and distribution of materials and discussion board based activities.
Our Live Online delivery
Our Live Online delivery is a dynamic, engaging and interactive way to learn remotely. It’s just like face to face but with the added benefits of digital technology. Your facilitator will present in real-time, and you will be able to participate in group discussions and collaborate on exercises and group activities using our interactive platforms.
Course details
- Course delivery, learning objectives and benefits.
Course delivery
This one-day course teaches participants the scope of Excel and how it can be leveraged more effectively at work. Participants get paired up with a fellow student for the day so they can learn and practice together, while being taught and supported by their facilitator.
Learning objectives
Specific skills you will learn in this course are:
- Autofilling and Sequential Filling.
- Creating a Custom List.
- Editing a Custom List.
- Deleting a Custom list.
- Creating Formulas using Relative Addressing.
- Creating Formulas using Absolute Addressing.
- Using Functions.
- Using the VLOOKUP function.
- Using the IF function.
- Using the PMT function.
- Sorting.
- Auto Filtering.
- Calculations in an Auto Filter
Benefits
By completing this course, participants will be able to:
- Drive efficiencies.
- Reduce time spent on manual tasks that can be automated.
- Make your job easier.
- Manipulate data in multiple ways to provide new insights.
Course inclusions
- Participant course training manual
- Access to Customer Development Advisors to discuss further study options - to book an appointment call 1800 633 560
- Convenient Hawthorn, Melbourne location
- New Live Online delivery allows you to do the course from anywhere in the country
- Live online delivery available in the following states and territories – Adelaide, Brisbane, Canberra, Darwin, Melbourne, Perth, Sydney, Tasmania.
Course downloads
- Timetables, course brochures and further information.
Quarterly Course Calendar Australia - Current Quarter
Timetables for this and all other short courses for the current quarter.
Quarterly Course Calendar Australia - Next Quarter
Timetables for this and all other short courses for the next quarter.
Short Course Overview - MS Excel Intermediate
Download this document as a quick outline of the short course that can be printed and presented to your employer.
Find out more
Make an enquiry
Make an enquiry
Training Organisation Identifier (TOID): 3059