book a course

Our Training

Build the confidence and skills you need to succeed with our practical professional development and IT courses, led by expert trainers with ongoing support.
See all courses

Explore our courses

IT & Digital Skills

Professional Development

PD Training

Build confidence, leadership, and workplace skills with our practical professional development courses. Delivered in Perth or live online, with expert trainers and ongoing support included.

read more

Explore our programs

Communication

Leadership

Project Management

Qualifications

Advance your career with nationally recognised qualifications and practical training. Delivered in Perth or live online, with expert trainers and ongoing support.
Learn More

Explore our Qualificationss

Microsoft Excel Advanced

Microsoft Excel new logo with Microsoft Partner written on it.
Free Post-course Support
100% Quality
Guarantee
Interactive
Learning
eCertificate of Attendance

Microsoft Excel Advanced

$980per person

In Person Virtual

Location: Level 1 Cloisters, 863 Hay Street, Perth WA 6000
Time: 9:00 am to 4:00 pm
Duration: Two consecutive days

Join in-person at our vibrant Perth CBD training centre. Lunch and refreshments are provided for all in-person attendees. Our training centre is centrally located and easily accessible by public transport.

Course Overview

Course Overview

This advanced Excel course helps experienced users build strong proficiency in powerful tools and techniques to manage, analyse, and work with complex data across multiple workbooks. Over two days, participants gain the confidence to tackle advanced Excel tasks efficiently.

Dates

Book a course

Course Information

Course Content

Review of Intermediate Concepts

  • Overview of topics covered during Intermediate Excel course

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 additional pivot table techniques

Excel Automation

  • Creating and editing simple Excel macros
  • Assigning macros to buttons, toolbars and other objects
  • Customising toolbars & ribbons
  • Use Power Query to import data
  • Basic data transformation using power query
  • 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 Intermediate course or equivalent knowledge is required.

“10 out of 10. This course will increase my proficiency with Excel” – Emanuel from PTA

“This course gave me more confidence with current abilities and tips to expand skillset. Very informative and engaging training! I will be recommending this to the rest of my team.” – Aidan from Dept. of Education

“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 DFES

“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

FAQs

Are your courses available online or in person?