Microsoft Excel Advanced
Learn how to cover the aspects beyond building basic workbooks including automation, productivity, consolidation, linking, analysis tools and automating workbook operations using Macros.
Who should attend?
Excel users who wish to enhance their knowledge and skills beyond building sample workbooks by using analytical and productivity tools.
Prerequisite: Completion of Microsoft Excel Intermediate training course or equivalent skill level.
Duration
1 day
Fees*
$415
(unless stated, Swinburne Professional courses do not attract GST)
Course specifics for Tasmania
This qualification is available in Tasmania. For further information please click here to send an enquiry and one of our team will contact you or call us on 1800 633 560.
Swinburne Professional
This course is delivered by Swinburne Professional. Our courses enable you to move forward in your career with the confidence that comes from knowing your skills are in demand.
“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
Course details
- Course delivery, learning objectives and benefits.
Course delivery
What is covered in Excel Advanced Training
- Use and create the Outline function
- Use and create the Goal Seek & Scenarios function
- Use and create Validations
- Use and create Pivot Tables
- Linking data to other Applications
- Group Worksheets
- Consolidate data from various sheets into one
- Create and Record Macros
Benefits
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
Dates and registration
- Dates and registration information.
Option 1 - Register and pay online
Register and pay online via Credit Card. Please note that we accept Visa and Mastercard only.
Option 2 - Register and request an invoice
Use the below form if you would like us to invoice your organisation. If you want to book into courses and pay by credit card, then please use Option 1 above.
Download and complete this form and return it to us by post or email.
Registration process
Course downloads
- Timetables, course brochures and further information.
Quarterly Course Calendar Victoria
Timetables for this and all other short courses for the current quarter.
Facilitators
- Facilitator information.
Be taught by our team of facilitators who are experienced, academically qualified and passionate about excellence in professional practice. Find out more about our facilitators here.
Find out more
Make an enquiry
Make an enquiry
Training Organisation Identifier (TOID): 3059