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 for your session. We provide a cost-effective way of training small teams or larger groups.
Pricing as of 1st April 2024. All prices are including GST.
| Number of participants |
In-Person* Cost per day |
Online Cost per day |
|---|---|---|
| 1 participant | $660.00 inc GST | $605.00 inc GST |
| 2 participants | $836.00 inc GST | $781.00 inc GST |
| 3 participants | $1,012.00 inc GST | $957.00 inc GST |
| 4 participants | $1,188.00 inc GST | $1,133.00 inc GST |
| 5 participants | $1,364.00 inc GST | $1,309.00 inc GST |
| 6 participants | $1,540.00 inc GST | $1,485.00 inc GST |
Contact us for pricing with 6+ participants.
* Within 50km driving distance from NSW 2567. Additional travel costs may apply outside this distance.
Course Inclusions
Skills Analysis
Take advantage of our free online skills analysis prior to your training to ensure have are undertaking the correct course.
Certificate
After completing the course you’ll receive a certificate to show off your new-found knowledge and skills.
We come to you
To save your business time, money and unnecessary travel, we come to you, delivering our training at your premises.
Hands-on training
We’re big believers in hands-on learning so you’ll be on a computer and building your skills in real-time.
Email Support
Access unlimited support following your training course to build on your learning and ask any burning questions.
Real-world examples
You'll work through real-world examples to reinforce learning and increase your confidence.
