Microsoft Excel Advanced Course

Advanced Microsoft Excel Training


Course Overview

This Advanced Excel course will further enhance on your existing Excel skills. Increasing your knowledge by understanding advanced functions and productivity tools. Following this course, you will work use a large range of functions. Analyse data effectively and quickly using Pivot Tables and Charts. You will gain a practical ability to use Excels productivity tools and Advanced Functions. This is a hands-on course and includes plenty of chances to try out what you are being taught and ask questions.


  • A moderate English language, literacy and numeracy skill is required.
  • Participants must bring their own laptop for training days.
  • Lunch:  Catering is provided, or you are welcome to bring your own (microwave and fridge available). Tea, Coffee and biscuits available.
  • Parking is available on site, or it is a short walk from Glendalough Train Station.

Learning Outcomes

At the completion of the program Excel Advanced participants should be able to:

  • Create If Functions to analyse data
  • use logical functions to test whether a statement is true or false
  • use a variety of data validation techniques
  • use a range of lookup and reference functions
  • create summaries in your spreadsheets using subtotals
  • understand and create simple PivotTables
  • construct and operate PivotTables using some of the more advanced techniques
  • create recorded macros in Excel

Course Content

  • Revision Exercise
  • Defined Names
  • Protecting Data, Worksheets and Workbooks
  • Logical Functions
  • Validating Data
  • Creating Drop Down boxes
  • Lookup Functions
  • Vlookup, Hlookup, Match
  • Summarising Data using Subtotals
  • Grouping and Outlining
  • Data Linking
  • Data Consolidation
  • Pivot Tables
  • Pivot Table Techniques
  • Macros
  • Attach Macros to buttons, Access Tootlbar and Worksheets

Choose A Date To Enrol

Course Price



MTA Training Facility in Osborne Park or;
on-site delivery with you (minimum 6 people)


Two (2) days.


Certificate of Attendance
RTO: 51586

Mine Training Australia will provide you with all the skills and knowledge you need for working in Mines in Australia

You can get in touch with us on our contact form, by email, or by phone on 1300 938 411. The x team are always here to discuss your training requirements in Perth, regional WA or throughout Australia.

WA Owned & Run Business


Nationally Recognised Certifications

Industry Specialists


Easy Help & Support

Easy & Flexible Payment Options


Specialised Trainers & Assessors