Microsoft Excel Intermediate
This Microsoft Excel Intermediate short course will take your Excel skills to the next level, so you can start working smarter with spreadsheets and use them to improve your efficiency and organisation at work.
In this one-day Excel course, you will learn intermediate Excel skills including how to use shortcuts, complex functions and relative and absolute formulas. You’ll be exposed to functions for financial and logical calculations, and learn useful methodologies to approach tasks in Excel with more confidence.
Reduce time spent on manual tasks with Autofilling and Sequential filling, and discover how to work with Custom Lists. Gain new insights faster by learning how to manipulate data with VLOOKUP, IF and PMT functions and Excel data filtering.
Microsoft Excel is a powerful tool for a range of uses, but most users only scratch the surface of its capabilities. This Excel training course helps you to un-learn processes you may have picked up from learning Excel on the job, replacing them with the most efficient ways to achieve effective outcomes.
If you want to improve your Excel skills, create more professional spreadsheets and use shortcuts, functions and formulas to make your job easier, Microsoft Excel Intermediate is for you.
Who should attend?
Anyone who uses Microsoft Excel at work and wants to advance their skills and knowledge. This Excel short course is perfect for those wanting to learn Excel beyond simple workbooks to drive efficiency and perform more complex tasks.
Recommended: We recommend that participants have a basic understanding of Microsoft Excel to get the most out of the Excel Intermediate course. If you are a beginner or want to brush up on the fundamentals, check out our Microsoft Excel Introduction short course.
Every international student application is considered for a scholarship
Whether you’re living in Australia or overseas, you’re automatically considered for a scholarship of up to 20% off your course fees. Please check our updated entry requirements.
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
Full-time
“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.
“Such a good PD session. [The facilitator] was enthusiastic and got us engaged by asking us questions throughout. It was great we were all able to use the practice spreadsheet to put into practice what we were taught. Lots of opportunity to ask for help. Good sized group. Thank you very much for a great day!”
Kylie
Microsoft Excel Intermediate
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 Excel course equips you with a practical set of intermediate Excel skills for business that can be applied straight away in the workplace. You will be paired with fellow students for the day so you can learn Excel and practice together while being taught and supported by an expert facilitator.
Learning objectives
This Microsoft Excel intermediate course covers:
- Autofilling and Sequential Filling.
- Creating, editing and deleting a Custom List.
- Creating Excel Formulas using Relative and Absolute Addressing.
- Using Functions.
- Using the VLOOKUP function.
- Using the IF function.
- Using the PMT function.
- Sorting.
- Auto Filtering.
- Calculations using an Auto Filter.
Benefits
By completing this Excel course, you will be able to:
- Drive efficiencies and be more organised at work.
- Reduce time spent on manual tasks that can be automated.
- Make your job easier using more complex Excel spreadsheets.
- 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