Excel Intermediate Course
Instructor-Led Excel Intermediate Course
Expand your skills using Excel with our one-day course.
Our Excel Intermediate course will take your skills to the next level and show you how to use key data analysis features such as named ranges, functions such as vlookup and xlookup, custom number formats, conditional formatting and more.
Use data analysis features like a pro.
Gain practical skills from our experienced trainers who provide you with real world examples and show you “why” not just “how”.
Experience one on one training or have colleagues join you in a private training session.
Excel Intermediate Course
Who is this course for?
This course is aimed at those who have used Excel and the basic features but wish to expand their knowledge and utilise new features such as formulas including vlookup and xlookup, conditional formatting techniques, custom lists, tables and charting options.
Course Description
Microsoft Excel Intermediate course is part of a 3-level study program. This course aims to expand participant’s knowledge and demonstrate how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation.
Learning Outcomes
At the completion of Microsoft Excel Intermediate you should be able to:
- customise the Excel interface to improve workflow
- apply custom number formatting to columns or rows
- create custom fill lists
- understand and use absolute and relative cell references
- create and use named ranges in a workbook
- create more complex formulas and functions such as IF, VLOOKUP, XLOOKUP and DATE
- customise the page layout using page breaks and custom headers & footers
- apply conditional formatting to ranges in a worksheet
- create and use Sparklines to monitor data trends
- create and work with tables and their features
- understand and use Excel's Quick Analysis tools
- use a range of elements and features to enhance charts
Prerequisites
The Excel Intermediate course assumes the participant has the knowledge required to enter data, create basic calculations, format data, print workbooks and chart simple data.
Course Duration
The Microsoft Excel Intermediate course is run over one-day but can be customised to suit your needs.
Course Overview
Customise Excel
- View Recent Files and Folders
- Customise the Quick Access Toolbar
- Customise the Status Bar
Number Formatting Techniques
- Create Custom Date Formats
- Create Colour Based Currency Formats
- Format Phone Numbers
- Create Descriptive Custom Formats
Fill Techniques
- Creating a custom fill list
- Modify and delete a custom fill list
Cell References
- Use Absolute Cell References
- Use Relative Cell References
Named Ranges
- Understand Named Ranges
- Create a Named Range
- Apply Names to Existing Formulas
- Create Names using the Name Box
- Use the Name Manager
Essential Functions
- Use an IF function with Text and Numbers
- Create a SUMIF Function
- Use the VLOOKUP & HLOOKUP Function
- Insert the IFERROR Function
- Use the XLOOKUP Function
- Use Counting Functions
- Use Date Functions including TODAY, NOW, and DATE
Page Setup
- Insert Page Breaks
- Use Page Break Preview
- Set a Print Area
- Create a Custom Header
- Create a Custom Footer
Conditional Formatting
- Format cells containing specific values
- Format cells containing Top Ten Items
- Explore more Top and Bottom Formatting
- Format using Data Bars
- Format using Colour Scales
- Format using Icon Sets
- Customise Rules
- Create a Rule using a Formula
- Clear Conditional Formatting
Sparklines
- Create a Sparkline
- Resize a Sparkline
- Edit Data
- Show or Hide Points
- Change Sparkline Styles
- Group or Ungroup Sparklines
- Clear a Sparkline
Tables
- Create a Table from scratch
- Work with Table Styles
- Insert and remove table columns
- Convert a table to a range
- Create a Table from Data
- Insert and delete Table Records
- Remove Duplicates
- Sort and Filter Tables
- Rename, split and delete a table
- Insert a Slicer
Chart Object Formatting
- Identify Chart Elements
- Format Chart Area
- Apply 3D rotation
- Use Shape Effects
- Explode Pie Slices
- Format Text and WordArt
Course Pricing
Our bespoke training courses allow you to pick and choose the content you need in your training session. We provide a cost-effective way of training small teams or large groups.
Pricing as of 1st January 2026. All prices are including GST.
| Number of participants |
In-Person* Cost per day |
Online Cost per day |
|---|---|---|
| 1 participant | $670.00 inc GST | $610.00 inc GST |
| 2 participants | $850.00 inc GST | $790.00 inc GST |
| 3 participants | $1,030.00 inc GST | $970.00 inc GST |
| 4 participants | $1,210.00 inc GST | $1,150.00 inc GST |
| 5 participants | $1,390.00 inc GST | $1,330.00 inc GST |
| 6 participants | $1,570.00 inc GST | $1,510.00 inc GST |
Contact us for pricing with 6+ participants.
* Includes travel within 50km driving distance of NSW 2567.
Travel beyond this distance is available, additional costs may apply.
Course inclusions
Skills Assessment
Take advantage of our free skills assessment prior to your training.
Course Manual
Course manual included in PDF format.
We come to you
We bring the training to you to avoid staff travel.
Ongoing Support
Access unlimited email support following your training course.
