Harness the Power of Excel

Find out why our students say “why didn’t I ever do an advanced Excel course before!”. This course will have you using Excel like a guru in no time. From Data Analysis using Pivot Tables to advanced spreadsheet manipulation, you will be amazed at the power of Excel.

Create lookup functions, enhance charts, protect worksheet data, perform advanced data operations using summarising, PivotTables, data consolidations, goal seeking, and Solver and use macros.

1 day | version: 2010, 2013 & 2016

Classroom CourseOnline Learning Excel 2016 AdvancedCustomised Group Training

Learning Outcomes

At the completion of this Microsoft Excel Advanced training course in Perth, participants will be able to:

modify Excel options
use logical functions to test whether a statement is true or false
use a range of lookup and reference functions
use data linking to create more efficient workbooks
group cells and use outlines to manipulate the worksheet
create summaries in your spreadsheets using subtotals
use the Data Consolidation feature to combine data from several workbooks into one
create, use and modify data tables
create and work with scenarios and the Scenario Manager
understand and create simple PivotTables
construct and operate PivotTables using some of the more advanced techniques
create and edit a PivotChart
use advanced filters to analyse data in a list
use a variety of data validation techniques
protect data in worksheets and workbooks
import data into Excel and export data from Excel
share workbooks with other users
create recorded macros in Excel

The Microsoft Excel Advanced training course in Perth utilises learning materials that are packed full of high quality content, step-by-step instructions with visuals and plenty of practice exercises offering exceptional value to the participant.

Detailed Course Outline & Course Files for the Microsoft Excel Advanced Training Course

Detailed Course Outlines - Click here for details

Suitable For

The Microsoft Excel Advanced training course in Perth is designed for users who need to use some of the more advanced features of Microsoft Excel.

Prerequisites

The Microsoft Excel Advanced training course in Perth assumes an understanding of the topics and concepts covered in the Microsoft Excel Introductory and Microsoft Excel Intermediate training courses in Perth. Attendees must be able to perform basic excel functions like SUM and perform basic arithmetic in excel.

Training Manual & Comprehensive Resources Included for MS Excel Course

Each class attendee to our Microsoft Excel Course is given the following;

Microsoft Excel Advanced 2016 Manual (online electronic version)
Handy Tips guide
Handy Tips for Excel 2016 Advanced (Summarising key tips and trick for using Microsoft Excel 2016)
“Quick Reference” Guide for Excel 2016
Excel 2016 Sample Chapter Files from the course
Excel 2016 Exercise Files
Excel 2016 Exercise File Solutions
Multiple Choice Test for each chapter

Microsoft Excel Advanced 2016 Online Training is a convenient, effective and affordable way to learn. You can complete the Microsoft Excel Advanced Online Training at your own pace and your own leisure. Whether you’re a beginner, an experienced user, or somewhere in between, you’ll find valuable knowledge that can be accessed again and again at a time and pace that suits you.

Sample Lessons from Microsoft Excel 2016 Online Learning

Learning Outcomes

At the completion of this Microsoft Excel Advanced Online Training, participants will have covered:

Over 250 Excel Advanced Lessons Online!

Lessons

Chapter 1

Chapter 1-1 Personalising Excel
Chapter 1-2 Setting The Default Font
Chapter 1-3 Setting Formula Options
Chapter 1-4 Setting Save Options
Chapter 1-5 Setting The Default File Location
Chapter 1-6 Setting Advanced Options

Chapter 2

Chapter 2-1 Using IF With Text
Chapter 2-2 Using IF With Numbers
Chapter 2-3 Nesting IF Functions
Chapter 2-4 IF ERROR
Chapter 2-5 Using TRUE And FALSE
Chapter 2-6 Using AND
Chapter 2-7 Using OR
Chapter 2-8 Using NOT

Chapter 3

Chapter 3-1 The CHOOSE Function
Chapter 3-2 The LOOKUP Function
Chapter 3-3 The VLOOKUP For Exact Matches
Chapter 3-4 Using Index Page
Chapter 3-5 Using MATCH

Chapter 4

Chapter 4-1 Linking Between Worksheets
Chapter 4-2 Linking Between Workbooks
Chapter 4-3 Updating Links Between Workbooks

Chapter 5

Chapter 5-1 Creating An Automatic Outline
Chapter 5-2 Working With An Outline
Chapter 5-3 Creating A Manual Group
Chapter 5-4 Grouping By Columns

Chapter 6

Chapter 6-1 Creating Subtotals
Chapter 6-2 Using A Subtotalled Worksheet
Chapter 6-3 Creating Nested Subtotals
Chapter 6-4 Copying Subtotals
Chapter 6-5 Using Subtotals With AutoFilter
Chapter 6-6 Creating Relative Names For Subtotals
Chapter 6-7 Using Relative Names For Subtotals

Chapter 7

Chapter 7-1 Consolidating With Identical Layouts
Chapter 7-2 Creating A Linked Consolidation
Chapter 7-3 Consolidating From Different Layouts
Chapter 7-4 Consolidating Data Using The SUM Function

Chapter 8

Chapter 8-1 Using A Simple What-If Model
Chapter 8-2 Creating A One-Variable Table
Chapter 8-3 Using One-Variable Data Table
Chapter 8-4 Creating A Two-Variable Data Table

Chapter 9

Chapter 9-1 Creating A Default Scenario
Chapter 9-2 Creating Scenarios
Chapter 9-3 Using Names In Scenarios
Chapter 9-4 Displaying Scenarios
Chapter 9-5 Creating A Scenario Summary Report
Chapter 9-6 Merging Scenarios

Chapter 10

Chapter 10-1 Recommended Pivot Tables
Chapter 10-2 Creating Your Own PivotTable
Chapter 10-3 Defining The PivotTable Structure
Chapter 10-4 Filtering A PivotTable
Chapter 10-5 Clearing A Report Filter
Chapter 10-6 Switching PivotTable Fields
Chapter 10-7 Formatting A PivotTable
Chapter 10-8 Creating Slicers
Chapter 10-9 Inserting A Timeline Filter

Chapter 11

Chapter 11-1 Using Compound Fields
Chapter 11-2 Counting In A PivotTable
Chapter 11-3 Formatting PivotTable Values
Chapter 11-4 Working With PivotTable Grand Totals
Chapter 11-5 Working With PivotTable Subtotals
Chapter 11-6 Finding The Percentage Of Total
Chapter 11-7 Finding The Difference From
Chapter 11-8 Grouping In PivotTable Reports
Chapter 11-9 Creating Running Totals
Chapter 11-10 Creating Calculated Fields
Chapter 11-11 Providing Custom Names
Chapter 11-12 Creating Calculated Items
Chapter 11-13 PivotTable Options
Chapter 11-14 Sorting In A PivotTable

Chapter 12

Chapter 12-1 Inserting A Pivot Chart
Chapter 12-2 Defining The PivotChart Structure
Chapter 12-3 Changing The PivotChart Type
Chapter 12-4 Using The PivotChart Filter Field Buttons
Chapter 12-5 Moving PivotCharts To Chart Sheets

Chapter 13

Chapter 13-1 Using An Advanced Filter
Chapter 13-2 Extracting Records With Advanced Filters
Chapter 13-3 Using Formulas In Criteria
Chapter 13-4 Using Database Functions
Chapter 13-5 Using DSUM
Chapter 13-6 Using The DMIN Function
Chapter 13-7 Using The DMAX Function
Chapter 13-8 Using The DCOUNT Function

Chapter 14

Chapter 14-1 Creating A Number Range Validation
Chapter 14-2 Testing A Validation
Chapter 14-3 Creating An Input Message
Chapter 14-4 Creating An Error Message
Chapter 14-5 Creating A Drop Down List
Chapter 14-6 Using Formulas As Validation Criteria
Chapter 14-7 Circling Invalid Data
Chapter 14-8 Removing Invalid Circles
Chapter 14-9 Copying Validation Settings

Chapter 15

Chapter 15-1 Providing Total Access To Cells
Chapter 15-2 Protecting A Worksheet
Chapter 15-3 Working With A Protected Worksheet
Chapter 15-4 Disabling Worksheet Protection
Chapter 15-5 Providing Restricted Access To Cells
Chapter 15-6 Password Protecting A Workbook
Chapter 15-7 Opening A Password Protected Workbook
Chapter 15-8 Removing A Password From A Workbook

Chapter 16

Chapter 16-1 Importing From An Earlier Version
Chapter 16-2 Importing Tab Delimited Text
Chapter 16-3 Importing Comma Delimted Text
Chapter 16-4 Importing Space Delimted Text
Chapter 16-5 Importing Access Data
Chapter 16-6 Working With Connected Data
Chapter 16-7 Unlinking Connections
Chapter 16-8 Exporting To Microsoft Word
Chapter 16-9 Exporting Data As Text
Chapter 16-10 Inserting A Picture
Chapter 16-11 Modifying An Inserted Picture

Chapter 17

Chapter 17-1 Saving To OneDrive
Chapter 17-2 Sharing Workbooks
Chapter 17-3 Enabling Tracked Changes
Chapter 17-4 Accepting Or Rejecting Changes
Chapter 17-5 Disabling Tracked Changes
Chapter 17-6 Adding Worksheet Comments
Chapter 17-7 Navigating Worksheet Comments
Chapter 17-8 Editing Worksheet Comments
Chapter 17-9 Deleting Comments

Chapter 18

Chapter 18-1 Setting Macro Security
Chapter 18-2 Saving A Document As Macro Enabled
Chapter 18-3 Recording A Simple Macro
Chapter 18-4 Running A Recorded Macro
Chapter 18-5 Relative Cell References
Chapter 18-6 Running A Macro With Relative References
Chapter 18-7 Viewing A Macro
Chapter 18-8 Editing A Macro
Chapter 18-9 Assigning A Macro To The Toolbar
Chapter 18-10 Running A Macro From The Toolbar
Chapter 18-11 Assigning A Macro To The Ribbon
Chapter 18-12 Assigning A Keyboard Shortcut To A Macro
Chapter 18-13 Deleting A Macro
Chapter 18-14 Copying A Macro

Microsoft Excel Advanced Online Training utilises learning materials that are packed full of high quality content, step-by-step instructions with visuals and plenty of practice exercises offering exceptional value to the participant.

Prerequisites

Microsoft Excel Advanced Online Training assumes an understanding of the topics and concepts covered in the Microsoft Excel Introductory Online Training. It would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Course Options

Options	Dates & Time	Includes	CPD Hours	Price
DVD Learning Excel 2010	Start any time!	– DVD (works on a pc only) – Course manual (hard copy) – 12 months email support – Postage	6	$99
Online Learning Excel 2016	Start any time!	– Online platform – Course manual (Electronic copy) – Training software – 12 months email support	6	$79

All prices are GST Free unless specified. Both of the above options are supplied with a Certificate to show you have participated in the course.

Customised Group Training for Microsoft Excel 2010, 2013 and 2016 – We can include the following;

Pre Course Questionnaire (Suitable for group training sessions if required)
Training Needs Analysis for Microsoft Excel Course
Tests available for download (Suitable for group training sessions if required)
Onsite with up to 12 laptops and projector
Use our computer training rooms venue in Perth CBD at no additional cost
Class sizes 2 to 24 attendees
Includes all resources, electronic manual for each attendee or hard copy additional fee

Please email us for a comprehensive details and proposal on how we can make your next corporate training event a success info@appliededucation.edu.au

Course Contents - Click here for details

Setting Excel Options

Understanding Excel Options
Personalising Excel
Setting the Default Font
Setting Formula Options
Understanding Save Options
Setting Save Options
Setting the Default File Location
Setting Advanced Options
Challenge Exercise
Challenge Exercise Sample

Logical Functions

Understanding Logical Functions
Using IF With Text
Using IF With Numbers
Nesting IF Functions
Using IFERROR
Using TRUE and FALSE
Using AND
Using OR
Using NOT
Challenge Exercise
Challenge Exercise Sample

Lookup Functions

Understanding Data Lookup Functions
Using CHOOSE
Using VLOOKUP
Using VLOOKUP for Exact Matches
Using INDEX
Using Match
Data Linking
Understanding Data Linking
Linking Between Worksheets
Linking Between Workbooks
Updating Links Between Workbooks
Challenge Exercise
Challenge Exercise Sample

Grouping and Outlining

Understanding Grouping and Outlining
Creating an Automatic Outline
Working With an Outline
Creating a Manual Group
Grouping by Columns
Challenge Exercise
Challenge Exercise Sample

Summarising and Subtotalling

Creating Subtotals
Using a Subtotalled Worksheet
Creating Nested Subtotals
Copying Subtotals
Using Subtotals With AutoFilter
Creating Relative Names for Subtotals
Using Relative Names for Subtotals
Challenge Exercise
Challenge Exercise Sample

Data Consolidation

Understanding Data Consolidation
Consolidating With Identical Layouts
Creating a Linked Consolidation
Consolidating From Different Layouts
Consolidating Data Using the SUM Function
Challenge Exercise
Challenge Exercise Sample

Data Tables

Understanding Data Tables and What-If Models
Using a Simple What-If Model
Creating a One-Variable Table
Using One-Variable Data Tables
Creating a Two-Variable Data Table
Challenge Exercise
Challenge Exercise Sample

Scenarios

Understanding Scenarios
Creating a Default Scenario
Creating Scenarios
Using Names in Scenarios
Displaying Scenarios
Creating a Scenario Summary Report
Merging Scenarios
Challenge Exercise
Challenge Exercise Sample

PivotTables

Understanding PivotTables
Recommended PivotTables
Creating Your Own PivotTable
Defining the PivotTable Structure
Filtering a PivotTable
Clearing a Report Filter
Switching PivotTable Fields
Formatting a PivotTable
Understanding Slicers
Creating Slicers
Inserting a Timeline Filter
Challenge Exercise
Challenge Exercise Sample

PivotTable Features

Using Compound Fields
Counting in a PivotTable
Formatting PivotTable Values
Working With PivotTable Grand Totals
Working With PivotTable Subtotals
Finding the Percentage of Total
Finding the Difference From
Grouping in PivotTable Reports
Creating Running Totals
Creating Calculated Fields
Providing Custom Names
Creating Calculated Items
PivotTable Options
Sorting in a PivotTable
Challenge Exercise
Challenge Exercise Sample

PivotCharts

Inserting a PivotChart
Defining the PivotChart Structure
Changing the PivotChart Type
Using the PivotChart Filter Field Buttons
Moving PivotCharts to Chart Sheets
Challenge Exercise
Challenge Exercise Sample

Advanced Filters

Understanding Advanced Filtering
Using an Advanced Filter
Extracting Records With Advanced Filter
Using Formulas in Criteria
Understanding Database Functions
Using Database Functions
Using DSUM
Using the DMIN Function
Using the DMAX Function
Using the DCOUNT Function
Challenge Exercise
Challenge Exercise Sample

Validating Data

Understanding Data Validation
Creating a Number Range Validation
Testing a Validation
Creating an Input Message
Creating an Error Message
Creating a Drop Down List
Using Formulas as Validation Criteria
Circling Invalid Data
Removing Invalid Circles
Copying Validation Settings
Challenge Exercise
Challenge Exercise Sample

Protecting Data

Understanding Data Protection
Providing Total Access to Cells
Protecting a Worksheet
Working With a Protected Worksheet
Disabling Worksheet Protection
Providing Restricted Access to Cells
Password Protecting a Workbook
Opening a Password Protected Workbook
Removing a Password From a Workbook
Challenge Exercise
Challenge Exercise Sample

Importing and Exporting

Understanding Data Importing
Importing From an Earlier Version
Understanding Text File Formats
Importing Tab Delimited Text
Importing Comma Delimited Text
Importing Space Delimited Text
Importing Access Data
Working With Connected Data
Unlinking Connections
Exporting to Microsoft Word
Exporting Data as Text
Inserting a Picture
Modifying an Inserted Picture
Challenge Exercise
Challenge Exercise Sample

Sharing Workbooks

Sharing Workbooks via the Network
Sharing Workbooks via OneDrive
Saving to OneDrive
Sharing Workbooks
Opening Shared Workbooks
Enabling Tracked Changes
Accepting or Rejecting Changes
Disabling Tracked Changes
Adding Worksheet Comments
Navigating Worksheet Comments
Editing Worksheet Comments
Deleting Comments
Challenge Exercise
Challenge Exercise Sample

Recorded Macros

Understanding Excel Macros
Setting Macro Security
Saving a Document as Macro Enabled
Recording a Simple Macro
Running a Recorded Macro
Relative Cell References
Running a Macro With Relative References
Viewing a Macro
Editing a Macro
Assigning a Macro to the Toolbar
Running a Macro From the Toolbar
Assigning a Macro to the Ribbon
Assigning a Keyboard Shortcut to a Macro
Deleting a Macro
Copying a Macro
Challenge Exercise
Challenge Exercise Sample

Course Options & CPD Hours - Click here for details

Register for a Microsoft Excel Advanced Training Course in Perth

Microsoft Excel Advanced

Rated 4.52 out of 5 based on 189 customer ratings

(189 customer reviews)

$79.00 – $339.00

Microsoft Excel Advanced training course in Perth (1 day | version: 2010, 2013 & 2016)
Online Learning Microsoft Excel 2016 Advanced Version

SKU: MS-Excel-Advanced Categories: 1 Day Microsoft Course, Microsoft Excel

Description

Microsoft Excel Advanced training course in Perth (1 day | version: 2010, 2013 & 2016)
Online Learning Microsoft Excel 2016 Advanced Version

Additional information

Course Start Date	10 Aug 2017, 23 Nov 2017, Choose Date or Learning Method, Online Learning and Manual (2016 Version), DVD and Manual (2010 version), Online Learning and Manual (2010 version), 14 Jul 2017, 6 July 2017, 21 September 2017

189 reviews for Microsoft Excel Advanced

Rated 5 out of 5

Renoy Francis – February 18, 2013

Found the course to be very useful. Highly recommend.
Rated 4 out of 5

Ruth – February 18, 2013

It’s a good class; well paced and very useful.
Rated 5 out of 5

kelly – February 18, 2013

Able to apply course material to work activity immediately making it well worth while.
Rated 4 out of 5

Sonya Laidley (verified owner) – February 18, 2013

Excellent. Found it interesting and will help me a lot in my job. Downloading the sheets afterwards will allow you to work through the practial exercises at your own pace to help with reinforcement. Thank you
Rated 4 out of 5

Joce Mato – February 19, 2013

In my opinion the course should be 2 days long to cover the whole book and to fit in assisted practical time. The course information is excellent, the tutor was very clear and well explained, the provided lunch was very nice and the location is convenient 🙂
Rated 4 out of 5

Tracey Russell – February 25, 2013

Excellent course, however the afternoon session was rushed as there was so much to try and cover. I would prefer a 2-day course to enable more practical exercise time. However, having the worksheets downloadable makes it possible to continue the learning outside of the course. Great tutor.
Rated 5 out of 5

Steve – March 8, 2013

Good course, taught well.
Rated 5 out of 5

Katie ♥ – March 8, 2013

Another awesome microsoft course. 🙂 the only problem was that there was a lot to cover in just one day..
Rated 5 out of 5

Jacinta Jakovcevic – March 8, 2013

Attended Excel Advanced after having done Excel Intermediate yesterday – certainly a LOT of material to cover. Lorraine is an excellent teacher – but I found this particular course a little hard after having done Intermediate only yesterday – perhaps a better idea is to have done Advanced after some time had elapsed to give me a chnace ot digest all the Intermediate content.

Wonderful courses – and the coursebooks are wonderful too !!
Rated 4 out of 5

Frances McCarhy (verified owner) – March 8, 2013

Exellent course, the tutor was very professional and thoughtful on understanding when you needed to go over things again.
Rated 3 out of 5

Steve – March 28, 2013

Great couse, Thanks Lorraine
Rated 4 out of 5

Deneil (verified owner) – March 28, 2013

Tutor was clear, well informed, approachable and helpful.
Great to have all of the course materials and workbooks to continue to work throught outside of the classroom.
Rated 3 out of 5

Heather Banach – March 28, 2013

Felt the course was a bit rushed especially in the afternoon. Overall very good, Trainer was good and helpful. Did Intermediate yesterday and feel one should have a break between courses to practice one before moving on to the next one.
Rated 4 out of 5

Emma – April 15, 2013

Great Course
thanks
Rated 4 out of 5

Jerry – April 15, 2013

Useful and practical, will definately use many of the techniques in this course for my role.
Rated 5 out of 5

Jarrad (verified owner) – May 9, 2013

Great course.
Learnt alot from it.

Thanks 🙂
Rated 5 out of 5

Michael Baxter – May 9, 2013

Great course even if you only know the basics.
Rated 4 out of 5

Rachel – May 9, 2013

Learnt a lot from today. The workbook directions are thorough and easy to follow. Lorraine is very patient and overall a great teacher.
Rated 3 out of 5

Mirella – May 9, 2013

The material provided & trainer (Lorraine) was well organised and thorough.
Rated 4 out of 5

Paul – May 9, 2013

grat course, very informative
thanks Lorraine
Rated 4 out of 5

Kathryn Holder – May 9, 2013

I really enjoyed the class, I thought it could have been a bit longer as it was quite a lot to take on board. Thanks
Rated 5 out of 5

Arkooliya Sherstobitova (verified owner) – May 23, 2013

Fantastic presentation, easy explanations, friendly environment, useful knowledge. Exactly what I needed.
Thanks a lot Lorraine.
Rated 4 out of 5

Natalie – May 23, 2013

The material in the course will be very helpful in my current role. The examples were great to work from, and Lorraine was very knowledgable and helpful. Thanks 🙂
Rated 4 out of 5

Angie – June 7, 2013

Great but needed a ilttle more time.
Rated 5 out of 5

Tammy Kelly – June 7, 2013

The course details was very intense, but thanks to Lorraine, the course appeared much simplier. I cant wait to play with all the information.
Thanks again.
Rated 4 out of 5

Daksh Kakkar (verified owner) – June 7, 2013

Great Course and good knowledge to gain. But Too much to gain in one day .
Rated 4 out of 5

Emma Henwood – June 7, 2013

Great course!!! great instructor. More time would have been great, maybe a day and a half course….
would love to be able to excel advanced 2011 for Mac…
Rated 5 out of 5

Bill Tate – July 4, 2013

Great, thanks
Rated 5 out of 5

Raquel Barros (verified owner) – July 4, 2013

Fantastic work! Appreciate all your help Brett. I look forward to use my new skills. Thank you
Rated 5 out of 5

Stephen M – July 4, 2013

Extremely helpful, well paced, adjusted course outline to suit needs of the class. Thanks.
Rated 5 out of 5

Claudette Jones – August 8, 2013

Excellent skills presentation….I am happy wih the presenter
Rated 5 out of 5

Denae Clinton – August 8, 2013

Thank you for anotherr great day Lorraine, A comprehensive look at Chart Tables, Pivot Tables and Macro’s.

Thank You
Rated 4 out of 5

Elise – August 8, 2013

Great Class !
Rated 4 out of 5

Paul (verified owner) – August 8, 2013

Really good course and excellent workbook to take home. Only problem is if you are still using Excel 2003.
Rated 4 out of 5

Mauricio Quinteros – August 8, 2013

Excellent course and very good presentation by the instructor
Rated 4 out of 5

Beth – August 8, 2013

Very clear instruction however purpose of each function wasnt always so clear. Too much content for one day training.

Aside from this, Lorraine is a very approachable trainer and accommodating to the different needs of the participants in the class.

Enjoyable day, thank you.
Rated 5 out of 5

JL (verified owner) – August 22, 2013

Very good course. Well presented.
Rated 4 out of 5

Tegan – August 22, 2013

Very informative.
Rated 4 out of 5

Paola Demberger (verified owner) – August 22, 2013

It was good, but it was a lot of information in short tim, should be Advance 2. Thanks
Rated 5 out of 5

Janelle – August 22, 2013

Very informative, great instructor!

Thanks
Rated 4 out of 5

sam – September 19, 2013

very informative, could go into deeper detail
Rated 4 out of 5

Nicole – September 19, 2013

Very Helpful
Rated 5 out of 5

Leah Kempers (verified owner) – September 19, 2013

Great course, easy to understand, each step was explained well.

Thanks again.
Rated 4 out of 5

Mark Tangney – September 19, 2013

Excellent – a good refresher and some good tips even for those already a advanced level. Great instructor.
Rated 5 out of 5

Mal Kelly (verified owner) – October 24, 2013

Great!
Rated 5 out of 5

Claire Stabler – October 24, 2013

Great, well paced course. Would recommend
Rated 4 out of 5

Belinda – October 24, 2013

Very helpful and easy to follow. A good day and worhwhile
Rated 4 out of 5

Sandy (verified owner) – November 21, 2013

Good Course !
Rated 5 out of 5

Clare – November 21, 2013

Great course, learnt a lot. Thanks
Rated 4 out of 5

Brooke – December 5, 2013

Brett was very thorough and the lesson was well taught to enable understanding.
Rated 4 out of 5

Melissa (verified owner) – December 5, 2013

Good course, served as a good refresher on some topics, and an insight and education on others. Definitely recommended.
Rated 5 out of 5

Aaron – February 13, 2014

Very informative course
Rated 5 out of 5

Malcolm Gibson – February 13, 2014

A very good course. Was intended as a refresher course, but leaned some new features which should improve productivity. Well delivered and pace was appropriate.
Rated 5 out of 5

Pushpa Raghwani – February 13, 2014

Very informative , good training . Easy understanding on certain grey area.
Rated 4 out of 5

Bronwyn Green – February 13, 2014

instructor asks for our priorities so we can learn that which interests us most, and work through other sections of the work book by our selves, which is great if you already know certain sections
Rated 5 out of 5

Louisa Liland (verified owner) – March 6, 2014

Highly recommended, trainer was clear and very helpful.
Rated 5 out of 5

Peter Rampellini (verified owner) – March 6, 2014

Excellent course learnt plenty of practical information that I can apply at work. Lorraine was excellent and very patient with me
Rated 4 out of 5

Lu – March 6, 2014

Relevant material to help me in my day to day duties.

Thankyou Lorraine
Rated 3 out of 5

Tania Gibbs (verified owner) – March 27, 2014

Not bad – Presenter very nice, however modules didn’t seem to flow
Rated 4 out of 5

Tania M – March 27, 2014

Very good course learnt a few extra short cuts. Lorraine very self explanatory and patient.
Thank you
Rated 3 out of 5

Davina Goh – March 27, 2014

Not bad – Lorraine was nice 🙂

Would prefer a little more structue to the course maybe a one page checklist
Rated 5 out of 5

Teresita – March 27, 2014

Lorraine was very helpful. Happy on the course. Useful tools to help understand on the course. Thank you
Rated 4 out of 5

Ariana Brown – April 16, 2014

Huge step between Intermediate and Advanced.
Rated 5 out of 5

Moira Beaman – April 16, 2014

Thank you
Very good course, now I need to go and study!
Lorraine was excellent.
Rated 5 out of 5

Marie – April 16, 2014

Informative and met my needs of understanding the various Excel functions.

Thanks Lorraine. 🙂
Rated 4 out of 5

Sam (verified owner) – April 16, 2014

Very helpful having the opportunity to practice the skills learned from each chapter prior to moving on to the next.
Rated 5 out of 5

Moira Beaman – April 16, 2014

Excellent – Lorraine was very helpful.
Now I have to go home and study!
Rated 5 out of 5

Bree (verified owner) – May 8, 2014

Excellent course, teacher was very knowledgeable. Thanks!
Rated 5 out of 5

Pierre – May 8, 2014

Very good course.
Presenter was very clear and patient.
Workbook material and exercise files were of good quality and helped a lot with the learning.
Rated 5 out of 5

jose (verified owner) – May 8, 2014

very informative!
Rated 5 out of 5

Michael Andrews – May 8, 2014

Lorraine knows her subject very well and allows students to move in their pace.
Rated 5 out of 5

Daniel – May 8, 2014

Great knowledge and transfer, I would recommend Lorraine
Rated 5 out of 5

Jason Place – June 6, 2014

Excellent course, life changing!
Rated 5 out of 5

Luke Krohn – June 6, 2014

Really Great Course. Most Helpful
Rated 5 out of 5

Nashin Omar (verified owner) – June 6, 2014

This was a great course. Really useful. Pace was good. Instructor lovely and helpful.
Rated 3 out of 5

Priyanthie (verified owner) – June 6, 2014

Its really good. But little bit fast.
Rated 4 out of 5

Fab (verified owner) – July 10, 2014

Thank you very much Lorraine, enjoyed your holidays was a real pleasure and useful 🙂
Rated 4 out of 5

Hannah Pearson – July 10, 2014

Very good, easier to follow than I expected and the trainer was very patient and took the time to ensure we were all up to speed.
Rated 3 out of 5

Natalie – July 10, 2014

Very useful information.
Rated 5 out of 5

Tracey – July 10, 2014

Good Course, Very informative and helpful
Rated 5 out of 5

Lynette (verified owner) – July 10, 2014

Great detail, covers many aspects of Excel. Lorraine is a great trainer who is more then willing to answer any ‘silly’ questions we might come up with.
Rated 5 out of 5

Kenneth Mungai – July 10, 2014

Good tips on how to work through various examples of formulas using relevant data sheets(real life examples). The trainer was also knowledgeable and very friendly to assisting with the learning outcomes.
8/10
Rated 5 out of 5

ruth elliott – July 10, 2014

Learned everything that I wanted to. The trainer knew her subject back to front, focused on the areas we wanted to develop and ensured the class understood what was going on at all times. Cheers Lorraine
Rated 4 out of 5

William Wang – August 7, 2014

Very useful!!
Rated 5 out of 5

Paleeta – August 7, 2014

Very helpful and informative. Lorraine is very clear and an excellent facilitator.
Rated 4 out of 5

Graeme – August 7, 2014

Well-paced, clear, thorough. The instructor (Lorraine) was very helpful.
Rated 5 out of 5

Biju – August 7, 2014

It is really informative and simple. Everyone would benefit it.
Rated 4 out of 5

Jade Marsegaglia – August 7, 2014

Great course. Lots of information covered. Lorraine is very friendly, helpful, and patient.
Rated 5 out of 5

Kimberley (verified owner) – September 11, 2014

Very helpful & answered all the extra questions I had.
Rated 5 out of 5

Lwin Khaing (verified owner) – September 11, 2014

This is an excellent course. The instructor explains well.
Rated 5 out of 5

Crystal – September 11, 2014

A very informative course. Nice environment and all the other people who attended were very friendly. Lorraine is a very good teacher and explains everything very thoroughly without leaving you behind.

Thank you 🙂
Rated 5 out of 5

shannen – October 9, 2014

a very informative course, well presesnted by Lorraine, went into detail with every section made it very easy to follow and understand.

thankyou
Rated 5 out of 5

Taylah – October 9, 2014

Thank you Lorraine. All three courses were really good & provided a lot of information, have a lot to take back to the work place 🙂
Rated 4 out of 5

Theresa Laas (verified owner) – October 9, 2014

Good and informative class 🙂 A nice environment and teacher.
Rated 5 out of 5

Jacques (verified owner) – October 9, 2014

Great learning and presentation , will come back for more
Rated 5 out of 5

Mairead – December 11, 2014

Really informative and great presentation
Rated 5 out of 5

Jodie – January 15, 2015

Thank you Lorraine!
Rated 5 out of 5

Harrison – January 15, 2015

Easier and better than Googling it.
Rated 5 out of 5

Kane – January 15, 2015

Great Stuff!

nice easy pace and relevant lessons!
Rated 4 out of 5

Jarrad – January 15, 2015

both content and delivery were excellent
Rated 5 out of 5

Rhys – January 15, 2015

Very informative and excellent presentation style. A lot of useful skills to take back to work!
Rated 5 out of 5

shayne Isbister – January 15, 2015

Really well presented, with clear communication. Great value add to the business.
Rated 5 out of 5

Alana – January 28, 2015

great fun & learnt lots of new things as well. Lorraine was an absolute legend & should get a pay rise
Rated 5 out of 5

Luke – January 28, 2015

Sensational course… very informative and helpful.

Thanks Lorraine 🙂
Rated 5 out of 5

Temisha – January 28, 2015

Learnt some great shortcuts and very well presented.
Thanks a bunch Lorraine!
Rated 5 out of 5

Emma – January 28, 2015

I found course to be very useful- I certainly learned alot!!
Thank you Lorraine, you were a great teacher 🙂
Rated 5 out of 5

Aimee – January 28, 2015

Great course! Highly recommended for everyone. Thank you Lorraine.
Rated 4 out of 5

Deborah Williams – January 28, 2015

Really good course – refresher of many things I knew and several new features I hadn’t used before. Enjoyed the course
Rated 5 out of 5

Sandra – February 12, 2015

Loved it, Highly recommended very easy to follow.
Rated 5 out of 5

Lisa O’Neil – February 12, 2015

Extremely helpful for a more efficient workplace
Rated 5 out of 5

Jeremy Smith – February 12, 2015

Enjoyed the course. Good refresher as well as a few new tips and tricks!
Rated 5 out of 5

Emma Fay – February 12, 2015

Great course. Learnt a lot to help me. Thanks Lorraine
Rated 4 out of 5

Robert Martin – February 12, 2015

Good Course, a few hidden Gems xx
Rated 5 out of 5

Irene Costello – February 12, 2015

The course was excellent – very informative and Lorraine was a fantastic teacher. Well worth doing!
Rated 5 out of 5

Dee He – February 12, 2015

Very informative, easy to follow course even for someone you have not used excel for a long time. Thanks Lorraine for your patience!
Rated 5 out of 5

Sophie – February 12, 2015

Great course – Learnt everything I wanted to learn and lots more! Would highly recommend. Thanks Lorraine!
Rated 5 out of 5

Dana Slater (verified owner) – March 12, 2015

Lorraine is extremely patient and provided the information to allow us to learn and explore back at the workplace. It assisted that I covered the intermediate program on the previous day, because the two days just flow together.
Rated 5 out of 5

Gary – March 12, 2015

Excellent feedback and informative course.
Rated 5 out of 5

Debbie Sykes – March 12, 2015

Very good course with good content. Lorraine was a very good and patient teacher.
Rated 4 out of 5

Jared (verified owner) – March 12, 2015

Informative and friendly.
Rated 5 out of 5

Renzo – April 16, 2015

Great course. Highly recommended. Dan is a great teacher
Rated 4 out of 5

Rachel – April 16, 2015

Great course.
Touched on some great topics and features of excel
Rated 4 out of 5

Leanne (verified owner) – April 16, 2015

Very Good – would love to do Intermediate 😀 Thanks Dan!!
Rated 5 out of 5

Linda – April 16, 2015

Good course and content, well delivered.
Rated 5 out of 5

Fred Hugo – August 27, 2015

Great new skills to use, especially Pivot Tables.
Rated 5 out of 5

Julie Pracy – August 27, 2015

Great Course!! So many new things to take back with me. Thanks Dan 🙂
Rated 4 out of 5

Kristen – August 27, 2015

Great class, Very interesting and helpful.
Rated 5 out of 5

Rasul (verified owner) – August 27, 2015

Learnt a lot of cool shortcuts and new functions to use in my work.
Rated 5 out of 5

Rosana – August 27, 2015

Great Tips!! Very Helpful!!!!!!!!!
Rated 2 out of 5

Michaela – September 24, 2015

Great, learnt alot of cool trips and tricks. Very useful.
Rated 5 out of 5

Vanessa Abbott – September 24, 2015

I have cut down on work time by 2 to 3 days per month thanks to vlookup and macros.
Rated 4 out of 5

Debbie (verified owner) – September 24, 2015

Learnt some useful tips and shortcuts.
Rated 4 out of 5

Jessica – September 24, 2015

Great course, very detailed. Lorraine a fantastic teacher who is patient with the class.
Rated 5 out of 5

Annie (verified owner) – September 24, 2015

Thanks Lorraine – Lots of great tips to take away.
Rated 3 out of 5

Leah – November 18, 2015

Valuable course
Rated 5 out of 5

Cerina Harper – November 19, 2015

Great Course – Very informative – Thanks Lorraine
Rated 5 out of 5

Natalie Rodgers – November 19, 2015

Thank you Lorraine – great course.. now to book into the VBA!!
Rated 5 out of 5

Matt Kleczkowski (verified owner) – November 19, 2015

loved it. Lorraine rocks and should be cover girl for the website promotional material not the brunette with over- whitened teeth and glasses
Rated 4 out of 5

Jen – November 19, 2015

Lots of tips . Thanks.
Rated 5 out of 5

Claire Barclay – November 19, 2015

Thanks Lorraine – this is my second course with you and no doubt will be back for another. Very informative and easy to follow
Rated 4 out of 5

Amanda – November 19, 2015

I found the course very valuable and I have left with many tips & tricks .
Rated 5 out of 5

Rachel Cordeiro – November 19, 2015

Very informative and well presented course, the lecturer was excellent and adaptive to all students learning
Rated 5 out of 5

Sue Milner – November 19, 2015

The course was excellant. Very informative and our tutor lorraine was funny, smart and very knowledgeable. I would highly recommend it to anyone who was interested in learning more about Excel and how is operates.
Rated 5 out of 5

ben – December 17, 2015

Excellent
Rated 5 out of 5

Cassandra Palmer (verified owner) – March 16, 2016

great session. very educational!
would definitely recommend to anyone interested in widening there excel knowledge
Rated 4 out of 5

Andrew Bell (verified owner) – March 16, 2016

Very knowledgeable presenter with strong communication skills. Good and relevant course content
Rated 5 out of 5

Vesna Van Biljon – March 16, 2016

Great course – learnt a lot!
Rated 5 out of 5

Di – April 14, 2016

Very good -trainer excellent & ensured everyone got what they were looking for and more
Rated 4 out of 5

Kate – April 14, 2016

Great course! Learnt things about excel I had never used before and many handy tips!
Rated 4 out of 5

Yogita – April 14, 2016

Great informative session. Lots to learn.
Rated 4 out of 5

George – April 14, 2016

Good course – learnt some pretty cool new tips!
Rated 5 out of 5

Emma – April 14, 2016

Wonderful course – recommended
Rated 5 out of 5

LIU LIU (verified owner) – April 14, 2016

Great course, very informative!!
Rated 4 out of 5

Aiesha Roy – April 14, 2016

Was a fantastic course but wish we had more time so everything could sink in. Our presenter was great and extremely helpful in taking her time with me, so I had a grasp of what i wanted to take away.
Rated 5 out of 5

Donna – July 27, 2016

Excellent Course, very relevant.
Rated 3 out of 5

Susan – July 27, 2016

Challenging when only did the intermediate course the day before. Spaced out may of been better to be able to have put the intermediate learning to some practice first.
Rated 4 out of 5

Mandy (verified owner) – July 27, 2016

Quite a lot functions taught in this course. Will recommend to everyone
Rated 4 out of 5

Juanet – July 27, 2016

All good, thank you.
Rated 4 out of 5

Belinda Lee – July 27, 2016

Microsoft Excel Advanced is amazing. Learnt lots again and shall apply the knowledge to my current work/role.
Thank you Lorraine H!
Rated 4 out of 5

Michelle (verified owner) – July 27, 2016

Interesting course, intensely delivered. Amazing to see the hidden gems in excel that could help make my work more efficient.
Rated 5 out of 5

Chris Leather (verified owner) – July 27, 2016

Very comprehensive, learnt a lot and will be a much faster worker in Excel from now on.
Rated 5 out of 5

Htet Nyein – September 21, 2016

Excellent training. Very informative. Very useful tips. I’d recommend it.
Rated 5 out of 5

S Ryall (verified owner) – September 21, 2016

Excellent
Rated 4 out of 5

Lucy Booth – October 27, 2016

Lorraine is very helpful and adapts the class as required
Rated 5 out of 5

Chris Fisher – October 27, 2016

Excellent training. Lorraine is very knowledgeable and is an excellent communicator of sometimes difficult concepts.
Rated 4 out of 5

Tracey Shooter – October 27, 2016

Really informative. Lots of good tips… could spend another two days here going into more depth but very good in the time spent.
Rated 4 out of 5

Iwan Labuschagne (verified owner) – October 27, 2016

Great learning atmophere and had a lot of fun learning!
Thank you!
Rated 5 out of 5

Sujeewe – October 27, 2016

Fantastic lesson ! learned a lot and refreshed many basic and advanced formulas. Hope to see you again for VB class.
Rated 4 out of 5

Sarah Staveley – October 27, 2016

Lorraine was very helpful and insightful. When all else fails, always blame the program.
Rated 5 out of 5

Minsi Liang (verified owner) – October 27, 2016

Very informative, helpful and well organised training.
Rated 4 out of 5

Kate Anderson – October 27, 2016

Lorraine has a very comprehensive knowledge and presents the information very well. Thank you… I will be emailing you.
Rated 5 out of 5

Mikaela Bell (verified owner) – December 15, 2016

Thanks again Lorraine for your time, I have taken away so many useful learning’s from today’s session. Super interactive. This has helped with so many outstanding excel issues I have been working through.
Rated 4 out of 5

Phil – December 15, 2016

Well paced good content.
Rated 5 out of 5

Hau Pham – December 15, 2016

Lorraine was very informative and helpful as well as patient. Enjoyed the class very much!
Rated 5 out of 5

Benny – February 16, 2017

Great course. Would actually recommenced all three courses as they all relate, and you pick up bits and pieces in each
Rated 5 out of 5

Paul Smith – February 16, 2017

Excellent course and definitely recommended to complete after intermediate course
Rated 5 out of 5

Sherrie (verified owner) – February 16, 2017

Lorraine had great classroom presence. The session was informative and allowed for questions to tailor towards specific needs.
Rated 5 out of 5

Faith – February 16, 2017

I learned a lot and it’s given me lots to think about. The course was well paced and Lorraine made it interesting. Thanks!
Rated 5 out of 5

susan carrick – February 16, 2017

Informative – Lorraine was extremely knowledgeable and the pace of learning was good. The class was flexible in responding to our questions and Lorraine waited till we all mastered each function. Well worth it.
Rated 3 out of 5

Donna (verified owner) – March 9, 2017

Useful content, a little fast paced in some areas for me but certainly informative
Rated 5 out of 5

Indi Nichol – March 9, 2017

Thank you Lorraine for your patience. Very good course. Highly recommended.
Rated 5 out of 5

tim – March 9, 2017

Very informative –
Rated 4 out of 5

Dooshika (verified owner) – March 9, 2017

Extremely useful tips. The workbook is absolutely fantastic and Lorraine is an amazing trainer. Quite a full-on class all in all.
Rated 4 out of 5

Kim (verified owner) – April 6, 2017

Very good.
Rated 5 out of 5

Judy Charleston – April 6, 2017

Thank you for a very informative learning experience. Lorraine was very informative trainer and provided lots of extremely useful tips.
Rated 4 out of 5

Adele – August 10, 2017

Was informative and helpful
Rated 5 out of 5

Joanrie – August 10, 2017

Great course, highly recommend it! Thanks
Rated 5 out of 5

Jenny Currin – August 10, 2017

Very informative and helpful 🙂 thank you Dan.
Rated 5 out of 5

Jo (verified owner) – August 10, 2017

Easy to follow instructions and informative materials.

Add a review

[twg_gpo_button]

Applied Education

4.5

Kalina Michalowska

15:56 14 Jul 17

I needed to complete two subjects in order to qualify for the tax agent licence. Applied Education offered the exact subjects I needed and they were at a very affordable price. I was able to study from home and if required, to communicate with their team with ease by e-mail. I feel that the assignments and exams prepared me adequately to the role of a tax agent. I would definitely recommend Applied Education to anyone who wants to study Accounting, Bookkeeping or Tax Agent courses.

Farah Itrana

03:33 18 May 17

I have done Advance Taxation with Applied Education. Material provided was easy to understand with practical examples. Assessors are very helpful. They are a good team. The most importantly it has very affordable fee. Thanks Applied Education Team. Regards

Kelly Townsend

05:43 04 May 17

Applied Education were helpful and I got my results and certificates promptly which I appreciated. I will be doing more study with them in the future.

Jackie Doorly

03:48 13 Mar 17

I have recently completed three courses varying in subjects through Applied Education. The course content was well covered and the assessment was clearly presented and directly related to the subject content. Thank you to the team at Applied Education for their assistance and prompt response to queries and requests. Having completed undergraduate and postgraduate degrees through other education providers in the past, I would most definitely recommend Applied Education for an organised, well presented and exceptional learning experience.

Ivan Teo

04:06 27 Feb 17

Recently completed my CERT IV dual qualification in Bookkeeping and Accounts online. Support staff were very prompt in their replies, and made my learning experience a very pleasant one. Will definitely recommend Applied Education to anyone.

cuiming xu

04:16 10 Feb 17

It's a very good training organisation and it's professional too. Admin staffs and assessor respond your query quickly. They also offer additional help even though it's something out of the scope. The course materials are clear and easy to understand, and it's very practical too.

Baljit Khare

04:52 10 Jan 17

I have recently completed two papers in Commercial Laws, it was fantastic experience. Highly relevant content in the course which enhance my knowledge to great extent. I highly recommend Applied Education as flexible study program and most comprehensive course content I had ever experience in my previous study courses.

Hilary Heah

07:38 28 Nov 16

I commenced and completed a course in Property Law recently with Applied Education, and the overall experience has been fantastic. Flexible study arrangements, easy to digest yet highly relevant content, and a great support network. Would certainly recommend to anyone who's already in the industry to further hone their knowledge as well as anyone else who might be interested in specific aspects of the financial and legal profession.

See All Reviews

About

Venue Hire

Certificate & Diploma

Tax Practitioners Board

Computer

Certificate & Diploma

Payroll & Taxation Courses

Microsoft Classroom & Online

Microsoft Online

Childcare Courses

Timetables

Perth

Melbourne

Adelaide

Brisbane

Sydney

Order & Checkout

Cart

Checkout

Forms

Terms & Conditions

Student Handbook

Forums

Certificate III-IV Bookkeeping & Accounting

Diploma & Advanced Diploma Accounting

Facebook

Blog Posts

Student Login

Online Platform

Harness the Power of Excel

Learning Outcomes

Detailed Course Outline & Course Files for the Microsoft Excel Advanced Training Course

Suitable For

Prerequisites

Training Manual & Comprehensive Resources Included for MS Excel Course

Sample Lessons from Microsoft Excel 2016 Online Learning

Learning Outcomes

Over 250 Excel Advanced Lessons Online!

Prerequisites

Course Options

Course Options

Register for a Microsoft Excel Advanced Training Course in Perth

Microsoft Excel Advanced

Attendee Name(s) *

Attendee Email(s)

Electronic Pdf or Hard Copy Manuals

Description

Additional information

189 reviews for Microsoft Excel Advanced

Related products

Microsoft Word Intermediate

Microsoft Excel Intermediate

Microsoft Excel Introductory

Microsoft Word Introductory