Microsoft Excel Advanced – Virtual Class

This live, facilitator led MS Excel Advanced training course is delivered to you online at your computer. You still have all the benefits of interacting with our facilitators in real time, just at your office or home desk. You can ask questions both during the training and afterwards with our free post course help desk.

Course Times

• 9am to 4pm

Course Content

Review of Intermediate Concepts

• Overview of topics covered during Intermediate Excel course

Working with Multiple Sheets & Workbooks

• Add, remove and copy sheets
• Grouping sheets for editing & linking data from multiple sheets
• Create 3-dimensional formulae

Advanced Data Tools

• Consolidating data with identical and different layouts
• Filter data – auto & advanced filter
• Data validation & conditional formatting
• Sensitivity analysis with goal seek, scenarios & data tables
• Using outlines

Excel Functions

• Working with specific function groups
• Nesting & combining functions
• Using named ranges

Charts & Pivot Tables

• Apply advanced concepts to Excel charts
• Create pivot tables & charts
• Using calculated fields and other pivot table techniques

Excel Automation

• Working with templates & styles
• Creating and editing simple Excel macros
• Assigning macros to buttons, toolbars and other objects
• Customising toolbars & ribbons
• Applying protection to worksheets & workbooks

On completion of this course, participants will be able to use multiple files, link these with formulas, and work with three-dimensional ranges; as well as perform Data distribution analysis, attach passwords and have a fuller understanding of the features of Excel.

Completion of Microsoft Excel Introduction and Intermediate course or equivalent knowledge is required.

“Very professional from the moment I arrived. The trainer is highly recommended and I’d jump at a chance to complete another Excel course at ATI Mirage.” Nicole from Chevron

“Second excel course I have attended through ATI-Mirage and have gained a lot of useful and pertinent knowledge for my position within the organisation.” Vicki from North Metro TAFE

“Excellent training and instructor, very well-spoken, great pace and the facilities were also fantastic. Thanks!” Radek from Public Transportation Services

“Exceeded my expectations and I feel more confident in applying what I’ve learned. “ Suelynn from the Dept of Fire & Emergency Services

“Very satisfied with the course. Learnt a lot, look forward to apply these skills in the real world!” Rachel from the Dept of Water & Environmental Regulation