Summer Sale on Now
Ends 31 January 2021
Pay Upfront and Save 20%
Off Microsoft Short Courses
Use coupon: Summer20
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.
EXCEL INTRODUCTORY
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.
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
$79 $99
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
$156 $195
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
$396 $495
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.
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
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
-
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
$79 $99
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
$156 $195
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
$396 $495
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.
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
-
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
$79 $99
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
$156 $195
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