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.

Naomi has extensive experience in the computer training industry and is a Microsoft Office Master Instructor. Evaluations reflect Naomi’s passion for facilitating learning and helping participants achieve their goals. Naomi has extensive experience delivering training across all industry sectors and developing specialist training materials to suit different clients. Naomi is enthusiastic about the products and how to work effectively and as quickly as possible using them and the aim is for all participants leave the room excited to get back to using the product more efficiently.


  • A moderate English language, literacy and numeracy skill is required.
  • Participants must bring their own laptop for training days.

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


Group bookings only – minimum of 6 people per group.
MTA Training Facility in Osborne Park or;
on-site delivery with you

Two (2) days.

Certificate of Attendance
RTO: 51586

Other Courses

Microsoft Excel Essentials Course
Learn the essential skills of using the spreadsheet management program Excel. In this course you will learn how to enter data, edit and move around a spreadsheet. You will learn how to format and print spreadsheets.

Microsoft Excel Essentials Course

Microsoft Excel Intermediate Course
This is an intermediate Excel course that will build on your existing Excel skills. Following this course, you will work smarter in Excel, helping you to better organise and present your data.

Microsoft Excel Intermediate Course

Microsoft Excel Advanced Course
This Advanced Excel course will further enhance on your existing Excel skills. Increasing your knowledge by understanding advanced functions and productivity tools.

Microsoft Excel Advanced Course

Microsoft Word Essentials Course
This hands-on course aims to give the learner a sound grounding in the use of Microsoft Word to create everyday documents required either at work or at home.

Microsoft Word Essentials Course

Microsoft Word Intermediate Course
This hands-on course will enable the learner to enhance their Microsoft Word documents to include Tables, watermarks, and Pictures.

Microsoft Word Intermediate Course

Microsoft Word Advanced Course
This hands-on course aims to give the learner a sound understanding of all that is involved in working with long documents, including cross references, Table of Contents and Indexing.

Microsoft Word Advanced Course

Microsoft PowerPoint Essentials Course
This course is for those aiming to use PowerPoint to produce presentation materials for seminars, training sessions, presentations or workshops.

Microsoft PowerPoint Essentials Course

Microsoft PowerPoint Advanced Course
This course is for those looking to advance their to use PowerPoint presentation materials.

Microsoft PowerPoint Advanced Course

Microsoft Outlook Essentials Course
You will find out how to use Microsoft Outlook as a time management tool, so you can manage the flow of emails and manage your calendar.

Microsoft Outlook Essentials Course

Microsoft Project Introduction Intermediate Course
Master using Microsoft Project to plan and manage your projects on this two-day introduction.

Microsoft Project Introduction Intermediate Course


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. The Mine Training Australia team are always available 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