Microsoft Excel Courses

Understanding Excel - Classroom or Online Learning

Introductory

Intermediate

Advanced

Study Options

Online Learning

Start any time and study at your own pace

$99
per course

Affordable and convenient

Log in at any time to access the course material, so you can study the course at a time that fits in with your lifestyle or other commitments.

Electronic manual included, plus 12 months unlimited access to course material.

Follow along with the sample exercises provided.

6 CPD hours per course

Instructor-demonstrated video tutorials

Pause, rewind and re-watch as many times as you need to assist in understanding the course material.
Here's a sample:

Classroom Workshop (Perth)

Hands-on classroom training in the Perth CBD

$339
per course

Hands-on classroom environment led by an expert trainer

One-day intensive workshop

All resources and computers provided

Talk to the course trainer, ask questions and receive handy tips to aid with your use of Excel.

Refreshments and lunch included

12 months access to electronic materials after completion of the class

6 CPD hours per course

Training manual and comprehensive resources included with Microsoft Excel course

Each class attendee will receive access to electronic materials to reference after the course. The online learning materials are packed full of high-quality content, step-by-step instructions with plenty of visuals and practice exercises offering exceptional value to the participant and valuable knowledge that can be accessed again and again.

- Microsoft Excel 2016 course manual
- Handy Tips guide (key tips and tricks for using Excel 2016)
- Quick Reference Guide
- Exercise Files to practise with

Get the Course Guide

Which level should I choose?

Introductory

A beginner's course that covers the basics of creating and working with workbooks and worksheets using Microsoft Excel 2016. Learn basic formulas and functions, formatting techniques, how to filter your data, plus much more.

Intermediate

Expand on your knowledge of Excel and learn how to create more productive workbooks with more complex formulas and functions. Learn to apply a range of number formatting and conditional formatting techniques.

Advanced

Perform advanced data operations including lookup and reference functions, creating summaries, and import and export data. Work with PivotTables and PivotCharts, create scenarios and use a variety of data validation techniques.

Understanding Excel from the basics

Our Microsoft Excel Introductory course is designed to give the new spreadsheet user the skills to start using Excel in the workplace. From using simple formulas such as the SUM function to formatting data and the basics of spreadsheets.

The course covers topics such as creating a workbook, functions, filtering data, charting and more.

Learning Outcomes Chapters - Click to View

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

navigate around Microsoft Excel 2016
create and work with a new workbook
open and navigate within workbooks and worksheets
make changes to data in a workbook
understand and work with ranges in a worksheet
copy and paste data in Excel
use the fill operations available to fill a data series
move the contents of cells and ranges within and between workbooks
understand, create and work with formulas and functions
understand and use formula cell referencing
use font formatting techniques
align the contents of cells in a number of ways
understand and use the number formatting features in Excel
format rows and columns in a worksheet
work with elements that make up the structure of a worksheet
sort data in a list in a worksheet
filter data in a table
print your workbook data
create effective charts in Microsoft Excel
obtain help for Excel whenever you need it
understand points to consider to avoid problems in your worksheets

Online Learning
Study at your own pace
49 Part course
6 CPD hours per course
12 Months unlimited access
Instant access, start NOW!

Introductory Online Learning

49-part course

Instant Access to Online Learning -
Sign Up & Start Now

$99

Enrol & Start Now

Introductory Classroom (Perth)

1-day intensive workshop

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

Duration: 9am-4pm

$339

View Dates & Enrol

Complete Online Course Bundle

55% Saving off RRP of $1090
Over 50 hours on-demand tutorials
Detailed training manuals e-book
Access anytime
Certificates of completion

All our Microsoft Online Learning - Excel, Word, PowerPoint, Project, Access & Outlook

Enhance your day-to-day use of Excel

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

Use detailed functions, complex formulas and tools like Goal Seek to quickly adjust your results in Excel.

Learning Outcomes Chapters 1 to 7 - Click to View

Chapter 1

Chapter 1-1 Filling Data
Chapter 1-2 Filling A Growth Series
Chapter 1-3 Filling A Series Backwards
Chapter 1-4 Filling Using Options
Chapter 1-5 Creating A Custom Fill List
Chapter 1-6 Modifying A Custom Fill List
Chapter 1-7 Deleting A Custom Fill List
Chapter 1-8 Extracting With Flash Fill
Chapter 1-9 More Complex Flash Fill Extractions
Chapter 1-10 Extracting Dates And Numbers

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 The CHOOSE Function
Chapter 2-5 The LOOKUP Function
Chapter 2-6 Using Counting Functions
Chapter 2-7 The Round Function
Chapter 2-8 Rounding Up And Rounding Down
Chapter 2-9 Manipulative Functions
Chapter 2-10 The MOD Function
Chapter 2-11 The TODAY Function
Chapter 2-12 The NOW Function
Chapter 2-13 The DATE Function
Chapter 2-14 The PMT Function

Chapter 3

Chapter 3-1 Scoping A Formula
Chapter 3-2 Preparing For Complex Formulas
Chapter 3-3 Creating The Base Formula
Chapter 3-4 Adding More Operations
Chapter 3-5 Editing A Complex Formula
Chapter 3-6 Adding More Complexity
Chapter 3-7 Copying Nested Functions
Chapter 3-8 Switching To Manual Recalculation
Chapter 3-9 Pasting Values From Formulas
Chapter 3-10 Documenting Formulas

Chapter 4

Chapter 4-1 Understanding Defined Names
Chapter 4-2 Defining Names From Worksheet Labels
Chapter 4-3 Using Names in Typed Formulas
Chapter 4-4 Applying Names To Existing Formulas
Chapter 4-5 Creating Names Using The Name Box
Chapter 4-6 Using Names To Select Ranges
Chapter 4-7 Pasting Defined Names Into Formulas
Chapter 4-8 Defining Names For Constant Values
Chapter 4-9 Creating Names From A Selection
Chapter 4-10 Scoping Names To A Worksheet
Chapter 4-11 Using The Name Manager
Chapter 4-12 Documenting Defined Names

Chapter 5

Chapter 5-1 Using Goal Seek

Chapter 6

Chapter 6-1 Inserting And Deleting Worksheets
Chapter 6-2 Copying A Worksheet
Chapter 6-3 Renaming A Worksheet
Chapter 6-4 Moving A Worksheet
Chapter 6-5 Hiding And Unhiding A Worksheet
Chapter 6-7 Changing Worksheet Tab Colours
Chapter 6-8 Grouping Worksheets
Chapter 6-9 Hiding and Unhiding Rows And Columns
Chapter 6-10 Freezing Rows And Columns
Chapter 6-11 Splitting Windows

Chapter 7

Chapter 7-1 Using Margins
Chapter 7-2 Centring
Chapter 7-3 Changing Orientation
Chapter 7-4 Specifying The Paper Size
Chapter 7-5 Setting The Print Area
Chapter 7-6 Inserting Page Breaks
Chapter 7-7 Setting And Clearing The Background
Chapter 7-8 Setting Rows As Repeating Print Titles
Chapter 7-9 Printing Gridlines and Headings
Chapter 7-10 Scaling To A Percentage

Learning Outcomes Chapters 8 to 14 - Click to View

Chapter 8

Chapter 8-1 Applying A Border To A Cell
Chapter 8-2 Applying A Border To A Range
Chapter 8-3 Applying A Bottom and Top And Bottom Border
Chapter 8-4 Removing Borders
Chapter 8-5 The More Borders Command
Chapter 8-7 Erasing Borders
Chapter 8-8 Formatting The Drawing Pencil

Chapter 9

Chapter 9-1 Applying Alternate Currencies
Chapter 9-2 Applying Alternate Date Formats
Chapter 9-3 Formatting Clock Time
Chapter 9-4 Formatting Calculated Time
Chapter 9-5 Creating Descriptive Custom Formats
Chapter 9-6 Custom Formatting Large Numbers
Chapter 9-7 Custom Formatting For Fractions
Chapter 9-8 Padding numbers Using Custom Formatting
Chapter 9-9 Aligning Numbers Using Custom Format
Chapter 9-10 Customising The Display Of Negative Values

Chapter 10

Chapter 10-1 Formatting Cells Containing Values
Chapter 10-2 Clearing Conditional Formatting
Chapter 10-3 More Cell Formatting Options
Chapter 10-4 Top Ten Items
Chapter 10-5 More Top And Bottom Formatting Options
Chapter 10-6 Working With Data Bars
Chapter 10-7 Working With Colour Scales
Chapter 10-8 Working With Icon Sets
Chapter 10-9 Creating Sparklines
Chapter 10-10 Editing Sparklines

Chapter 11

Chapter 11-1 Quick Formatting
Chapter 11-2 Quick Charting
Chapter 11-3 Quick Totals
Chapter 11-4 Quick Sparklines
Chapter 11-5 Quick Tables

Chapter 12

Chapter 12-1 Creating A Table From Scratch
Chapter 12-2 Working With Table Styles
Chapter 12-3 Inserting And Deleting Table Columns
Chapter 12-4 Converting A Table To A Range
Chapter 12-5 Creating A Table From Data
Chapter 12-6 Inserting Or Deleting Table Records
Chapter 12-7 Removing Duplicates
Chapter 12-8 Sorting Tables
Chapter 12-9 Filtering Tables
Chapter 12-10 Renaming A Table
Chapter 12-11 Splitting A Table
Chapter 12-12 Deleting A Table

Chapter 13

Chapter 13-1 Adding A Chart Title
Chapter 13-2 Adding Axes Titles
Chapter 13-3 Repositioning The Legend
Chapter 13-4 Showing Data Labels
Chapter 13-5 Showing Gridlines
Chapter 13-6 Formatting The Chart Area
Chapter 13-7 Adding A Trendline
Chapter 13-8 Adding Error Bars
Chapter 13-9 Adding A Data Table
Chapter 13-9 Adding A Data Table

Chapter 14

Chapter 14-1 Selecting Chart Objects
Chapter 14-2 Using Shape Styles
Chapter 14-4 Changing The Colour Of A Series
Chapter 14-5 Changing Line Chart Colours
Chapter 14-6 Using Shape Effects
Chapter 14-7 Colouring The Chart Background
Chapter 14-8 Using The Format Pane
Chapter 14-9 Exploding Pie Slices
Chapter 14-11 Formatting Text
Chapter 14-12 Formatting With WordArt
Chapter 14-13 Changing WordArt Fill
Chapter 14-14 Changing WordArt Effects

View Full Course Outline

Online Learning
Study at your own pace
134 Part course
6 CPD hours per course
12 Months unlimited access
Instant access, start NOW!

Intermediate Online Learning

134-part course

Instant Access to Online Learning -
Sign Up & Start Now

$99

Enrol & Start Now

Intermediate Classroom (Perth)

1-day intensive workshop

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

Duration: 9am-4pm

$339

View Dates & Enrol

Complete Online Course Bundle

55% Saving off RRP of $1090
Over 50 hours on-demand tutorials
Detailed training manuals e-book
Access anytime
Certificates of completion

All our Microsoft Online Learning - Excel, Word, PowerPoint, Project, Access & Outlook

Harness the power of Excel

Once you've mastered the day-to-day functions in Excel, unlock the more advanced features of the program with our Microsoft Excel Advanced training course.

Protect worksheet data and perform advanced data operations.

Learning Outcomes Chapters 1 to 10 - 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

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

Learning Outcomes Chapters 11 to 18 - Click to View

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

View Full Course Outline

Online Learning
Study at your own pace
250 Part course
6 CPD hours per course
12 Months unlimited access
Instant access, start NOW!

Advanced Online Learning

250-part course

Instant Access to Online Learning -
Sign Up & Start Now

$99

Enrol & Start Now

Advanced Classroom (Perth)

1-day intensive workshop

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

Duration: 9am-4pm

$339

View Dates & Enrol

Complete Online Course Bundle

55% Saving off RRP of $1090
Over 50 hours on-demand tutorials
Detailed training manuals e-book
Access anytime
Certificates of completion

All our Microsoft Online Learning - Excel, Word, PowerPoint, Project, Access & Outlook

Customised Group Training

Customised Group Training is available for Microsoft Excel 2010, 2013 or 2016.

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 comprehensive details and a proposal on how we can make your next corporate training event a success.

Get the Course Guide

Microsoft Excel Courses

Understanding Excel - Classroom or Online Learning

Study Options

Online Learning

Start any time and study at your own pace

$99 per course

Instructor-demonstrated video tutorials

Classroom Workshop (Perth)

Hands-on classroom training in the Perth CBD

$339 per course

Training manual and comprehensive resources included with Microsoft Excel course

Which level should I choose?

Introductory

Intermediate

Advanced

EXCEL INTRODUCTORY

Understanding Excel from the basics

Online Learning

Study at your own pace

49 Part course

6 CPD hours per course

12 Months unlimited access

Instant access, start NOW!

Introductory Online Learning

49-part course

Instant Access to Online Learning - Sign Up & Start Now

$99

Introductory Classroom (Perth)

1-day intensive workshop

$339

Complete Online Course Bundle

EXCEL INTERMEDIATE

Enhance your day-to-day use of Excel

Online Learning

Study at your own pace

134 Part course

6 CPD hours per course

12 Months unlimited access

Instant access, start NOW!

Intermediate Online Learning

134-part course

Instant Access to Online Learning - Sign Up & Start Now

$99

Intermediate Classroom (Perth)

1-day intensive workshop

$339

Complete Online Course Bundle

EXCEL ADVANCED

Harness the power of Excel

Online Learning

Study at your own pace

250 Part course

6 CPD hours per course

12 Months unlimited access

Instant access, start NOW!

Advanced Online Learning

250-part course

Instant Access to Online Learning - Sign Up & Start Now

$99

Advanced Classroom (Perth)

1-day intensive workshop

$339

Complete Online Course Bundle

Customised Group Training

Home

Courses

Students

Contact

$99
per course

$339
per course

Instant Access to Online Learning -
Sign Up & Start Now

Instant Access to Online Learning -
Sign Up & Start Now

Instant Access to Online Learning -
Sign Up & Start Now