Microsoft Excel Advanced Course – Classroom or Online Learning

Harness the Power of Excel

Download A Course Guide

One day hands on classroom course
Online Excel Advanced Course with 250 tutorials

Study Options

Online Excel Advanced Course

Start Anytime

Over 250 Online Tutorials - Instructor demonstrated
Course manual - Electronic copy included
Unlimited 12 months course access
6 Hours CPD
$79

Online Learning Instant Access - Start NowEnrol Now

Classroom Excel Advanced Course

Hands On Classroom

Instructor led - Hands on classroom workshops
Course manual - Electronic copy included
Refreshments & lunch included
Expert Trainers
$339

Enrol Now - Classroom Courses

Online Learning - 250 Part Course

Microsoft Excel 2016 Advanced Online Training is a convenient, effective and affordable way to learn. You can complete the Microsoft Excel Intermediate 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.

Microsoft Excel Intermediate 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.

Learning Outcomes Chapters 1 to 9 - Click to View

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

Learning Outcomes Chapters 10 to 18 - Click to View

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

Instant Access to Online Learning - Sign Up & Start Now

Classroom Course

1 Day Hands On Classroom Course

The Excel Intermediate training course is designed for users familiar with Excel basics and want to really improve their productivity and get more out of their spreadsheets.

Use detailed functions and complex formulas to enhance your spreadsheet. Use simple tools like Goal Seek to quickly adjust your results in excel.

Duration – 1 day | version: 2010, 2013 & 2016

Classroom Training

Hands on classroom training in our modern facilities in Perth CBD

Learning Outcomes - Click to view

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.

Course Contents - Click to view

Setting Excel Options

Logical Functions

Lookup Functions

Grouping and Outlining

Summarising and Subtotalling

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

PivotTables

PivotTable Features

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

Validating Data

Protecting Data

Importing and Exporting

Sharing Workbooks

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

PDF Course Outline

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 Intermediate (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

Customised Group Training

Customised Group Training for Microsoft Excel 2010, 2013 or 2016

Group Training - Click to view

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

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

Classroom Dates & Schedule - Perth

Course Duration

Location: Level 1, 524 Hay St. Perth WA 6000

Duration: 9am-4pm

Hands On Classroom Workshops - Modern Computers Supplied, pens, mints, refreshments & lunch

View Dates & Enrol

See what our previous students have to say about us.

Completed the cert IV in bookkeeping and accounting. Very much enjoyed the online aspects of the course and the support from the Applied Education staff was always prompt and clear. Highly recommend if you are wanting to do an online course at your own pace.read more

Audrey

06:56 13 Sep 18

I completed the Certificate IV in Bookkeeping & Accounting in August 2018. I did it online. I found the course content had a good mix of theory and practice. The support team was helpful. Upon completion I got the job I wanted: Office and Finance Manager. I keep the motion going and have now enrolled for the Diploma of Accounting with this RTO.read more

Johanna Hersey

04:36 05 Sep 18

I am a Tax Agent and had to complete 1 further unit of study as requested by the Tax Practitioners Board which was Property Law. The Unit offered by Applied Education was practical and relevant to my line of work, and very happy to say I have learnt quite a bit of useful information to help me with my practice. The course was also self paced and whenever I contacted the team to ask a question, or ask for an assessment to be escalated due to time constraints I had, they were very happy to accommodate me or discuss to manage my expectations. All in all I am very happy to recommend Applied Education to any tax agents in training who need to complete one further course.read more

Tristan Perry

13:06 12 Aug 18

I have completed Property Law unit for my tax agent licence. The course was focused on learning and practical work. The assessments are marked fairly quick. Both the admin staff and the assesors are always there to answer your questions. I would recommend this course to anyone.read more

Nico SETIAWAN

08:18 12 Aug 18

I found Applied Education to be an excellent provider of education. Helpful assessors, relevant material for the course I did and a really reasonable cost for the course and materials needed. I highly recommend Applied Education to anyone wanting to study onlineread more

Robyn Milligan

09:05 24 Jul 18

I found the study material and assignments complemented the scope of the module and the relevance thereof very well. Course advisors were readily available and very competent resulting in a smooth study environment.read more

Robert Hutchons

08:27 17 Jul 18

Very supportive and make the process as easy as it can be. I Done BAS and Payroll courses

Christian King

03:28 04 Jul 18

Applied Education Platform was easy to use for a 'first time online learner' Marking of Assessments was within the time limits. Assessors are quick to respond to questions. Forums and chat groups are highly valuable. The online classrooms need to be more current, but otherwise they were good.read more

Cindav Cindav

22:23 29 May 18

Applied Education was very good, the lecturers were very helpful, the online materials & tutorials made learning easy. I found the turnaround for marking assignments sometimes took longer then 10 working days, but once contacting them, action was taken very quick & the marked assignment was received. The feedback on assignments was always helpful and clear. I recommend Applied Education.read more

Suzanne Robson

03:02 14 May 18

Great course with user friendly student access to online courses and learning material. Staff are very helpful and respond promptly to questions and problems. Thanks to Darren Roxburgh for assisting with RPL and required courses to be completed.read more

helen tricker

10:17 18 Apr 18

I have recently finished the Tax Agent Units and can tell they are awesome! Easy to use the dashboard, easy to understand everything and everybody was very helpful. I had got answer for all of my questions within 24 hours. Thank you!read more

Diana Takacs Juhaszne

07:31 20 Feb 18

I did BAS Agent Registration Course and found it was great. I enjoyed the course as the focus was more on learning rather than getting good marks. I would like to recommend it to others.read more

Dipendra Panta

04:39 20 Feb 18

I just completed Tax Return for Companies subject and found it was great learning platform through Applied education, really helpful staff & tutor. I will recommend it to others as well.read more

Hard Rock

12:06 14 Nov 17

I did BAS Agent Registration Course and found it was great. I enjoyed the course as the focus was more on learning rather than getting good marks. I would recommend it to others.read more

Mali M

07:36 07 Nov 17

Just completed my Dual Cert IV in Bookkeeping and Accounting and was extremely happy with the quality of service Applied Education gave. The course content was relevant and staff always helpful. I would definitely recommend to others thinking of studying this course and may further my studies in this area through Applied Education. I really enjoyed it thank you!read more

Nicki Motuzas nicola.motuzas@google.com

06:20 30 Aug 17

I just completed Property Law through Applied Education. The unit is easy to understand and very practical. Awesome experience!!!read more

Veronica Canlas

22:33 14 Aug 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.read more

Kalina Michalowska

15:56 14 Jul 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.Regardsread more

Farah Itrana

03:33 18 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.read more

Kelly Townsend

05:43 04 May 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.read more

Jackie Doorly

03:48 13 Mar 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.read more

Ivan Teo

04:06 27 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.read more

cuiming xu

04:16 10 Feb 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.read more

Baljit Khare

04:52 10 Jan 17

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.read more

Hilary Heah

07:38 28 Nov 16

‹

›

Download A Course Guide

Microsoft Excel Advanced Course – Classroom or Online Learning

Harness the Power of Excel

One day hands on classroom course
Online Excel Advanced Course with 250 tutorials

Study Options

Online Excel Advanced Course

$79

Classroom Excel Advanced Course

$339

Online Learning - 250 Part Course

Instant Access to Online Learning - Sign Up & Start Now

Classroom Course

1 Day Hands On Classroom Course

Classroom Training

Hands on classroom training in our modern facilities in Perth CBD

Training Manual & Comprehensive Resources Included for MS Excel Course

Customised Group Training

Classroom Dates & Schedule - Perth

Course Duration

See what our previous students have to say about us.

Home

Courses

Students

Contact

Microsoft Excel Advanced Course – Classroom or Online Learning

Harness the Power of Excel

One day hands on classroom courseOnline Excel Advanced Course with 250 tutorials

Study Options

Online Excel Advanced Course

$79

Classroom Excel Advanced Course

$339

Online Learning - 250 Part Course

Instant Access to Online Learning - Sign Up & Start Now

Classroom Course

1 Day Hands On Classroom Course

Classroom Training

Hands on classroom training in our modern facilities in Perth CBD

Training Manual & Comprehensive Resources Included for MS Excel Course

Customised Group Training

Classroom Dates & Schedule - Perth

Course Duration

See what our previous students have to say about us.

Home

Courses

Students

Contact

One day hands on classroom course
Online Excel Advanced Course with 250 tutorials