Microsoft Excel Advanced Course. Classroom or Online

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.

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.

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.

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.

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

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!

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.

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.

Why Study With Us?

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.

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

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.

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.

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.

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.

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.