Upskill Today!

Pay Upfront and Save 22%
Use coupon code: OCTDEAL22

Ends 31 October 2021

Day

Hour

Minute

Second

Microsoft Excel Courses

Understanding Excel - Classroom or Online Learning

Introductory

Intermediate

Advanced

Get 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. 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

Instructor-demonstrated video tutorials

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

Excel Introductory Online Learning

49-part course

Access course any time and study at your own pace
Downloadable manual and resources, 12 months unlimited access
Follow along with the sample exercises provided
6 CPD hours
Certificate of Completion

$99

Instant Access - Enrol Now

Complete Excel 3 Course Bundle

Excel Introductory, Intermediate and Advanced

Three Course Bundle
Log in at any time to access the course materials
Downloadable manual and resources, 12 months unlimited access
18 CPD hours
Certificates of Completion

$195

Instant Access - Enrol Now

Complete Microsoft 10 Course Bundle

The Ultimate Microsoft Office 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 Microsoft Online Courses - Excel, Word, PowerPoint, Project, Access & Outlook

$495

Instant Access - Read more

EXCEL INTERMEDIATE

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

Access course any time and study at your own pace
Downloadable manual and resources, 12 months unlimited access
Follow along with the sample exercises provided
6 CPD hours
Certificate of Completion

$99

Instant Access - Enrol Now

Complete Excel 3 Course Bundle

Excel Introductory, Intermediate and Advanced

Three Course Bundle
Log in at any time to access the course materials
Downloadable manual and resources, 12 months unlimited access
18 CPD hours
Certificates of Completion

$195

Instant Access - Enrol Now

Complete Microsoft 10 Course Bundle

The Ultimate Microsoft Office Course Bundle

$495

Instant Access - Read more

EXCEL ADVANCED

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

Access course any time and study at your own pace
Downloadable manual and resources, 12 months unlimited access
Follow along with the sample exercises provided
6 CPD hours
Certificate of Completion

$99

Enrol & Start Now

Complete Excel 3 Course Bundle

Excel Introductory, Intermediate and Advanced

Three Course Bundle
Log in at any time to access the course materials
Downloadable manual and resources, 12 months unlimited access
18 CPD hours
Certificates of Completion

$195

Instant Access - Enrol Now

Complete Microsoft 10 Course Bundle

The Ultimate Microsoft Office Course Bundle

$495

Instant Access - Read more

Microsoft Excel Online Course Information

Digital Certificate

Digital Certificate of Completion
Printable PDF Digital Certificate
The Certificate is Available as PDF Digital And Has a QR Code to Verify Authenticity.
6 Hours CPD
Short Online Assessment to Test Your Knowledge are Included on the Student Learning Platform with a Certificate of Completion Available After the Final Online Quiz.
Certificate shown are for illustration purpose only.

Course Duration

Most students complete the Online Course in around 6 hours and the classroom course is a full day. You will have 12 months access to the tutorials. Study online at a pace that suits your personal situation.

Materials

Online Access to Learning Tutorials
Course Presentation Slides
Electronic PDF Course Guide
Resources and Publications Where Applicable

The course content is accessed via our online student portal, with additional resources, extra learning materials also available. Please note due to copyright the electronic manuals cannot be printed. Hard copies can be ordered when enroling in your course.

Get the Course Guide

Upskill Today!

Pay Upfront and Save 22%Use coupon code: OCTDEAL22

Microsoft Excel Courses

Understanding Excel - Classroom or Online Learning

Get Course Guide

Which level should I choose?

Introductory

Intermediate

Advanced

EXCEL INTRODUCTORY

Understanding Excel from the basics

Instructor-demonstrated video tutorials

Online Learning

Study at your own pace

49 Part course

6 CPD hours per course

Certificate of completion

12 Months unlimited access

Instant access, start NOW!

Excel Introductory Online Learning

49-part course

$99

Complete Excel 3 Course Bundle

Excel Introductory, Intermediate and Advanced

$195

Complete Microsoft 10 Course Bundle

The Ultimate Microsoft Office Course Bundle

$495

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

$99

Complete Excel 3 Course Bundle

Excel Introductory, Intermediate and Advanced

$195

Complete Microsoft 10 Course Bundle

The Ultimate Microsoft Office Course Bundle

$495

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

$99

Complete Excel 3 Course Bundle

Excel Introductory, Intermediate and Advanced

$195

Complete Microsoft 10 Course Bundle

The Ultimate Microsoft Office Course Bundle

$495

Microsoft Excel Online Course Information

Digital Certificate

Course Duration

Materials

Home

Courses

Students

Contact

Pay Upfront and Save 22%
Use coupon code: OCTDEAL22

Get Course
Guide