Microsoft Excel Advanced
At the advanced level, Microsoft Excel is indeed a tool to be reckoned with.
This one-day short course is perfect for experienced Excel users who want to take their skills to the absolute peak of the program’s ability.
You will learn automation, productivity, consolidation, linking, analysis tools, and automating workbook operations using Macros.
This course is our most interactive Excel course, with lots of exercises to reinforce the topics you’re learning. We teach you more complex formulas, more professional sheets, macros, and more. You can get complex, efficient, and very clever.
The program will also help you break bad habits and maximise Excel’s capabilities.
Who should attend?
Excel users who wish to enhance their knowledge and skills beyond building simple workbooks by using analytical and productivity tools.
Prerequisite: Completion of Microsoft Excel Intermediate training course or equivalent skill level.
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 Advanced
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 short course will pair you up with a buddy for the day, so you can work together and practice.
Learning objectives
Participants will be able to:
- Use and create the Outline function.
- Use and create the Goal Seek & Scenarios function.
- Use and create Validations.
- Use and create Pivot Tables.
- Link data to other Applications.
- Use and create Group Worksheets.
- Consolidate data from various sheets into one.
- Create and Record Macros
Benefits
- Gain confidence with advanced tasks in Excel.
- Reduce time spent on complex calculations using macros that can be automated.
- Enjoy a high level of digital literacy.
- Get advanced outcomes from Excel including highly complex tasks.
- Receive a participant course training manual to take with you.
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
Timetables for this and all other short courses for the current quarter.
-
Short Course Overview - MS Excel Advanced
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