MS Excel Advanced

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