Microsoft Excel Intermediate
$470
Overview
Upgrade your spreadsheet skills with our Microsoft Excel Intermediate short course to improve your efficiency and organisation at work.
You'll learn how to use shortcuts, complex functions, relative and absolute formulas.
Approach Excel tasks with more confidence as you explore useful methodologies and learn the tools for financial and logical calculations.
We'll also teach you timesaving tools such as Auto filling and Sequential filling to reduce the time spent on manual tasks. Discover how to work with Custom Lists and gain new insights faster by learning data manipulation with VLOOKUP.
Who should attend
This course is for anyone who used Microsoft Excel at work and wants to advance their skills and knowledge beyond simple workbooks to perform more complex tasks.
Skills you’ll learn
- Intermediate Excel
- Computing
- Problem solving
- Time management
Learning outcomes
- Autofilling and Sequential Filling
- Creating, editing and deleting a Custom List
- Creating Excel Formulas using Relative and Absolute Addressing
- Using Mathematical functions, VLOOKUP function, IF function and PMT function
- Sorting
- Auto Filtering
- Calculations using an Auto Filter
About your instructor
-
Terrence Yakub
Terrence has over 25 years of experience in training and management. He helps individuals develop competence and confidence in using software programs in a relevant, enjoyable and interactive manner. Terrence delivers courses and manages multi-national projects both overseas and in Australia for clients such as Australia Post, ANZ Bank, Telstra and realestate.com.au.
-
“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
Why Swinburne?
Delivered by facilitators who are industry experts
Participant course training manual
Live Online delivery allows you to do the course from anywhere
Access to our team of Customer Development Advisors
Download brochure
Course downloads
Timetables
Resources
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.