Microsoft Excel Unlock the full power of Excel – no jargon, just real skills you can use immediately.

Discover step-by-step courses tailored from beginners to advanced users, complete with hands-on exercises and live expert guidance to help you master Excel functions, formulas, and data analysis tools.

Watch the video to learn more

Trusted by:

What is included?

Full day instructor led training from 9am to 4:30pm
Comprehensive training manual
Certificate of attendance
Fully Interactive – You can ask questions.
Unlimited free post training phone / email help desk support

Join an Upcoming Training Session

Upcoming Excel training sessions ranging from Fundamentals to Advanced.

No sessions found.

Testimonials

What you will learn

Excel Fundamentals

Unlock the full potential of Microsoft Excel with our Excel Fundamentals training course! Designed for beginners and those seeking to enhance their skills, this
course covers the essential features and tools of Excel to help you work smarter, not harder.

From mastering formulas and functions to organizing data efficiently, you’ll gain practical knowledge that can be applied to both personal and professional
tasks. Whether you’re looking to boost productivity, improve data analysis, or stay competitive in today’s data-driven world, this training equips you with the
confidence and expertise to excel—pun intended!

Excel Environment
- Using the Ribbon and Quick Access toolbar
- Excel Views
- Navigation between sheets and workbooks
Entering Data
- Constructing Spreadsheets
- Entering numbers, text and dates
- Keyboard commands
- Copy and Paste text, values and formulas
Formulas and Functions
- Cell addresses and references
- Constructing Basic Formulas & Functions
- Formula Bar
- Copy and Paste data and formulas
Workbooks
- Naming & colour-coding worksheets
- Grouping worksheets
- Formulas across worksheets and workbooks
- Moving and copying worksheets
Apply formatting
- Formatting Numbers
- Cell Alignment
- Borders
- Fonts and Colours
Charts
- Creating Basic Charts
- Chart Types
- Chart Data
- Format Chart Components
Page Setup & Printing
- Freeze Panes
- Page Setup
- Margins
- Headers and Footers
- Sheet printing options
- Print Area
- Page Break Preview

Book Now

Excel Intermediate

Dive deeper into the inner workings of Microsoft Excel with our Intermediate Excel course! This training is designed to help you understand Excel’s thought
process when handling numbers, text, formulas, and functions.

You’ll uncover the logic behind how Excel interprets data and performs calculations, enabling you to harness its power with greater precision.

From mastering advanced formulas to effectively managing text and numerical data, this course equips you with the skills to think like Excel does. Perfect for
professionals and enthusiasts alike, you’ll gain insights to streamline workflows, boost efficiency, and unlock Excel’s full potential in your projects and tasks.

AutoComplete features
- Fill Handle
- Filling values, text and dates
- Custom Fill Lists
Keyboard Shortcuts
- Selecting cells
- Building Formulas and Functions
- Insert Cells, Columns and Rows
- Data Entry
- Insert Dates
Formulas
- Formula structure
- Formula Calculation order
- Absolute and Relative cell references
- Formula Auditing
- Trace Dependance and Precedence
- Find and correct Formula Errors
- Watch Cells
- Evaluate Formulas
- Text in Formulas
Functions
- Function Structure
- Using Formula Bar and Paste Function features
- Introduction into various function types:
  - Summary Functions
  - Logical Functions
  - Date Functions
  - Text Functions
- Using AutoCalculate
Formatting
- Creating Custom Number formats
Grouping and Outlining
- Grouping Rows and Columns
- Auto Outline
- Outline Levels
Charting
- Creating Charts
- Formatting Chart components
- Creating and applying user-defined Charts
- Combining Chart types and adding a Secondary Axis
- Adding Trendlines and Error Bars
Data Validation
- Set Validation criteria
- Specify a data Input Message
- Customise Error Messages

Book Now

Excel Advanced

Take your Excel skills to the next level with our Excel Advanced training course! This course is perfect for those looking to dive deeper into the power and
versatility of Excel.

You’ll explore advanced referencing techniques, including named ranges and structured tables, that streamline your workflow and make your data more dynamic.

We’ll guide you through the process of analyzing data with sophisticated functions and powerful PivotTables, helping you uncover meaningful insights with ease.

Whether you’re managing complex datasets or optimizing reports, this course equips you with the tools and expertise to excel at a truly advanced level.

Advanced Functions
- Function Structure
- IF and IFS function
- AND / OR functions
- Nested functions
- VLOOKUP function
- XLOOKUP function
- IS functions
Data Management
- Data Structure
- Lookup Tables
- Advanced Sorting & Filtering
- SUBTOTAL function
- Subtotals Feature
Conditional Formatting
- Conditional Formatting Overview
- Symbols and Colours
- Using Formulas and Functions for Conditional Formatting
- Using Sparklines
- Symbols with Custom Number Formatting
PivotTables
- Constructing PivotTables
- Data fields
- Filtering
- Hiding and showing field details
- Creating data groups
- Displaying Source Data
- PivotTable Options
- Formatting PivotTables
- Comparative Calculations
- Calculated fields
- Data Consolidation with PivotTables
PivotCharts
- Creating a PivotChart
- Reorganising Chart Fields
- Filtering Chart Fields
Basic Macros
- Recording Macros
- Running Macros
- Assigning Macros to Worksheet Objects
- Customising the Ribbon

Book Now

Excel Advanced Level 2

The Excel Advanced Level 2 course is designed for experienced users looking to take their data analysis skills to the next level.

In this session, we’ll explore some of Excel’s most powerful tools, including Spilled Arrays for dynamic formula creation, Power Query for efficient data transformation, and Power Pivot for advanced data modelling and analysis.

Whether you’re working with large datasets or building robust dashboards, this course will equip you with the skills to streamline your workflow and uncover deeper insights from your data.

Lookups
- LOOKUP, VLOOKUP, HLOOKUP
- XLOOKUP (Office 365 – 2019 onwards)
- INDEX & MATCH
- COLUMN(S) & ROW(S)
- CHOOSE
Arrays (Office 365 – 2019 onwards)
- Array Formulas
- Array Functions
- UNIQUE
- FILTER
- SORT & SORTBY
- GROUPBY & PIVOTBY
- SEQUENCE
- TEXTBEFORE, TEXTAFTER & TEXTSPLIT
- IMAGE
- Combining Arrrays
- Implicit Intersections
- Dynamic Arrays and Spilled Ranges
Advanced Functions
- LET
- LAMBDA
- INDIRECT
- OFFSET
Forecasting
- Scenarios
- Goal Seek
- Data Tables
- Forecast Sheet
Power Query
- Import Data
- Clean Imported Data
- Split, Create and Delete Columns
- Query Applied Steps
- M Code
- Merge and Append Data
- Update or Modify linked files
Power Pivot
- Activate Power Pivot
- Understand Power Pivot
- Import data into Power Pivot
Data Model
- DAX Functions
- Calculated Columns
- Measures
- Create Relationships between Data
- Create a PivotTable from the Data Model

Book Now

FAQ

What level of Excel knowledge do I need to join the training?

Our training sessions cater to all skill levels—from beginners to advanced users.

If you are unsure of which course to attend, then you can fill out a Training Needs Analysis form.

Download the Training Needs Analysis here.
Save and fill out the form.
Send it to us at bp@blankpage.net.au
We will then email you back wit our recommendations.

Is help available after the training?

Yes, you can contact us at any time via phone or email if you have any questions.

How long is the course, and what’s the format?

Courses run for a full day.

Session Start: 9am (AEST)
Morning Break: 10:30am – 10:45am
Lunch Break: 12:00pm – 1:00pm
Afternoon Break: 2:30pm – 2:45pm
Finish: 4:30pm

Training is live, hands-on, practical, and includes exercises to reinforce learning.

What do I need to attend the training?

Stable internet connection
Your laptop with Excel installed.
Ideally have two screens so that you can watch the trainer and also follow along.
Headphones or Speakers

Will I receive a certificate of completion?

Yes, all participants receive a certificate upon successful completion of the course.

Can I ask questions during training?

Absolutely, the sessions are live and we encourage questions during the session for better understanding.

You can even share your screen with the trainer to help you along if you get stuck.

Do I get a manual with step-by-step instructions?

Yes, we will send you a manual in PDF form with information and clear, step-by-step instructions for each topic.

Can I share my screen to ask questions about my own work?

Yes, you can share your screen with the trainer for personalised assistance.

Can the training be customised for my team or organisation?

Absolutely! We specialise in tailoring training sessions to meet your team’s specific needs and industry challenges, using your own data examples where appropriate.

Is the training available online or in person?

We offer both live online sessions and on-site training, depending on your preference and location.

The sessions on this particular page are Online sessions and are delivered via Teams.

Give us a call on 0487 246 464 or email us at bp@blankpage.net.au if you have any questions or would like to enquire about team sessions.

What version of Excel is the training based on?

We use Microsoft 365 / Excel 2021 as the standard, but we can adapt content to suit earlier versions if required.

95% of the content in the training sessions are very similar across all of the Excel versions. Only features like XLOOKUP, Spilled Arrays and other minor features might not be available.