- Fill Handle
- Filling values, text and dates
- Custom Fill Lists
Overview
Dive deeper into the inner workings of Microsoft Excel with our Excel Intermediate training 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.
Microsoft Excel Intermediate training course in Melbourne and across Australia. We can come to you for Face-to-face Excel Intermediate training or you can join us online for Live online Excel training courses.
Course Materials
Excel Intermediate Course Outline
541 KB
Excel Intermediate Exercise Files
270 KB
2 items
Detailed Course Outline
- Selecting cells
- Insert Cells, Columns and Rows
- Insert Dates
- Adding Data
- Formula structure
- Formula Calculation order
- Absolute and Relative cell references
- Formula Auditing
- Trace formula Dependence and Precedence.
- Find and correct Formula Errors
- Watch and Evaluate formulas
- Function Structure
- Using Formula Bar and Paste Function features
- Introduction into various function types:
- Math & Trig functions
- Date functions
- Text functions
- Using AutoCalculate
- Creating Custom Number formats
- Conditional Formatting
- Grouping Rows and Columns
- Modify Groups
- Show / hide Outlines
- Clearing Outlines
- Creating charts
- Formatting chart components
- Creating and applying user-defined charts
- Combining chart types and adding a secondary axis
- Adding Trendlines and Error Bars
- Set Validation criteria
- Specify a data Input Message
- Customise Error Messages
Course prerequisites
You need to be familiar with the basics of Excel.
Inclusions
Instructor - led Training
Menual & Files
Unlimited Free Support
There’s a point where basic spreadsheets just don’t cut it anymore. You need formulas that flex, functions that work smarter, and the ability to troubleshoot when things go wrong. That’s where intermediate Excel skills come in and where this course changes the game.
At Blank Page (Aust) Pty Ltd, we deliver the Excel intermediate training course professionals rely on to boost confidence, speed, and accuracy. Whether you’re managing data in finance, operations, admin, or marketing, our Microsoft Excel intermediate training is built around practical, real-world use.
Professionals across finance, logistics, administration, marketing, or operations benefit from knowing how to structure data, use conditional logic, format outputs clearly, and validate information in a consistent and controlled way.
If you choose in-person or live online delivery, this hands-on program supports every learner in applying mid-level functions effectively.
This is not about memorising Excel features. You’ll work through real scenarios that involve formulas, charting, validation, and formatting. The structure is deliberate: each task is designed to show the logic behind the tool.
Key activities include:
- Using AutoComplete and smart keyboard shortcuts
- Creating dynamic formulas and functions
- Understanding how Excel handles data types differently (numbers vs text)
- Developing formatted, professional-looking tables
- Structuring graphs using combination charts and secondary axes
- Applying data validation rules that reduce input errors
- Grouping and outlining large datasets for clarity
- Customising visual output with user-defined charts
All files are downloadable, and you get full access to exercise materials.
Excel is one of the most widely used business tools, yet many users remain stuck at the beginner level. The online intermediate Excel classes are designed for people who want to stop relying on others and instead build real capability in spreadsheet handling.
This is where the intermediate Excel skills course steps in; it empowers learners to find smarter ways to interpret and manage data.
Participants gain insight into automation, formula structuring, and layout optimisation. These skills save hours each week, especially when working with repeated reporting, client documents, or operations data.
The Microsoft Excel intermediate training doesn’t rely on generic templates. You’ll work from scratch and learn what each decision in Excel means, making you a better problem-solver in the process.
Training is available both online and face-to-face. You can choose the online Excel intermediate course for convenience or attend sessions in Melbourne and other Australian locations.
Every option includes:
- Trainer-led guidance
- Full manuals and files
- Interactive tasks during the session
- Post-session access to exercises
There’s also the option to book private group training for workplaces.
Even those who use Excel regularly often miss key steps. The Excel intermediate level course offers clarity, structure, and techniques you can apply immediately.
It’s also a great starting point if you’re planning to move into more advanced Excel functions later.
We’ve been helping professionals across Australia sharpen their skills with tools they use every day. Our structured, outcomes-focused approach makes us a trusted choice for businesses and individuals looking for clear, applied learning.
Here’s how we deliver better value in every session:
- Local Trainers, National Delivery: Based in Australia, we deliver both face-to-face and online Excel intermediate course sessions tailored to local needs.
- Recognised by Australian Organisations: Our online Excel intermediate courses are trusted by professionals in business, government, and non-profits alike.
- Seamless Learning Experience: Clear materials, guided exercises, and intuitive pacing make the Excel intermediate level course easy to follow and impactful.
- 28+ Years of Training Expertise: We bring decades of experience to every Excel intermediate training course, ensuring you’re in skilled hands.
Thousands of professionals across Australia choose us for quality, reliability, and results. Whether you’re after online intermediate Excel classes or on-site sessions, our team ensures the training fits your workflow and not the other way around.
Backed by clear materials, expert instruction, and flexible delivery, our online Excel intermediate course is built for learners who want practical outcomes, not just theory. To know more about group training options, speak to us now.
Will I get to work on Excel files during the course, or is it mostly lecture-based?
You’ll work through exercises in real time. Each key concept includes a hands-on task using provided Excel files, so you’re applying what you learn immediately.
Microsoft Excel Intermediate Training
Will this help if I’m preparing for an internal Excel test or role change?
Yes. The course strengthens core competencies and introduces intermediate techniques often evaluated during promotions or internal skill assessments.
Microsoft Excel Intermediate Training
What happens if Excel looks slightly different on my version?
We cover both Office 365 and older versions where needed. Trainers are familiar with interface variations and guide you accordingly during the session.
Microsoft Excel Intermediate Training
Will this course help reduce errors in large or shared spreadsheets?
Yes. A major focus is teaching data validation, and error-checking tools that help avoid manual mistakes, especially useful in shared workbooks.
Microsoft Excel Intermediate Training
Microsoft Excel Intermediate Training
Related Courses
-
Advanced -
Fundamentals$375 -
Advanced Level 2$395 -
Advanced$395
Course Details
Duration
1 day
Level
Intermediate
Private Sessions
Book a private session for 1 to 12 of your employees. Courses can be customised to suit your learning needs.
Public Sessions
Join a public course session conducted LIVE ONLINE via Microsoft Teams.
$375
Detailed Course Outline
- Fill Handle
- Filling values, text and dates
- Custom Fill Lists
- Selecting cells
- Insert Cells, Columns and Rows
- Insert Dates
- Adding Data
- Formula structure
- Formula Calculation order
- Absolute and Relative cell references
- Formula Auditing
- Trace formula Dependence and Precedence.
- Find and correct Formula Errors
- Watch and Evaluate formulas
- Function Structure
- Using Formula Bar and Paste Function features
- Introduction into various function types:
- Math & Trig functions
- Date functions
- Text functions
- Using AutoCalculate
- Creating Custom Number formats
- Conditional Formatting
- Grouping Rows and Columns
- Modify Groups
- Show / hide Outlines
- Clearing Outlines
- Creating charts
- Formatting chart components
- Creating and applying user-defined charts
- Combining chart types and adding a secondary axis
- Adding Trendlines and Error Bars
- Set Validation criteria
- Specify a data Input Message
- Customise Error Messages
Course prerequisites
You need to be familiar with the basics of Excel.
Inclusions
Instructor - led Training
Menual & Files
Unlimited Free Support
There’s a point where basic spreadsheets just don’t cut it anymore. You need formulas that flex, functions that work smarter, and the ability to troubleshoot when things go wrong. That’s where intermediate Excel skills come in and where this course changes the game.
At Blank Page (Aust) Pty Ltd, we deliver the Excel intermediate training course professionals rely on to boost confidence, speed, and accuracy. Whether you’re managing data in finance, operations, admin, or marketing, our Microsoft Excel intermediate training is built around practical, real-world use.
Professionals across finance, logistics, administration, marketing, or operations benefit from knowing how to structure data, use conditional logic, format outputs clearly, and validate information in a consistent and controlled way.
If you choose in-person or live online delivery, this hands-on program supports every learner in applying mid-level functions effectively.
This is not about memorising Excel features. You’ll work through real scenarios that involve formulas, charting, validation, and formatting. The structure is deliberate: each task is designed to show the logic behind the tool.
Key activities include:
- Using AutoComplete and smart keyboard shortcuts
- Creating dynamic formulas and functions
- Understanding how Excel handles data types differently (numbers vs text)
- Developing formatted, professional-looking tables
- Structuring graphs using combination charts and secondary axes
- Applying data validation rules that reduce input errors
- Grouping and outlining large datasets for clarity
- Customising visual output with user-defined charts
All files are downloadable, and you get full access to exercise materials.
Excel is one of the most widely used business tools, yet many users remain stuck at the beginner level. The online intermediate Excel classes are designed for people who want to stop relying on others and instead build real capability in spreadsheet handling.
This is where the intermediate Excel skills course steps in; it empowers learners to find smarter ways to interpret and manage data.
Participants gain insight into automation, formula structuring, and layout optimisation. These skills save hours each week, especially when working with repeated reporting, client documents, or operations data.
The Microsoft Excel intermediate training doesn’t rely on generic templates. You’ll work from scratch and learn what each decision in Excel means, making you a better problem-solver in the process.
Training is available both online and face-to-face. You can choose the online Excel intermediate course for convenience or attend sessions in Melbourne and other Australian locations.
Every option includes:
- Trainer-led guidance
- Full manuals and files
- Interactive tasks during the session
- Post-session access to exercises
There’s also the option to book private group training for workplaces.
Even those who use Excel regularly often miss key steps. The Excel intermediate level course offers clarity, structure, and techniques you can apply immediately.
It’s also a great starting point if you’re planning to move into more advanced Excel functions later.
We’ve been helping professionals across Australia sharpen their skills with tools they use every day. Our structured, outcomes-focused approach makes us a trusted choice for businesses and individuals looking for clear, applied learning.
Here’s how we deliver better value in every session:
- Local Trainers, National Delivery: Based in Australia, we deliver both face-to-face and online Excel intermediate course sessions tailored to local needs.
- Recognised by Australian Organisations: Our online Excel intermediate courses are trusted by professionals in business, government, and non-profits alike.
- Seamless Learning Experience: Clear materials, guided exercises, and intuitive pacing make the Excel intermediate level course easy to follow and impactful.
- 28+ Years of Training Expertise: We bring decades of experience to every Excel intermediate training course, ensuring you’re in skilled hands.
Thousands of professionals across Australia choose us for quality, reliability, and results. Whether you’re after online intermediate Excel classes or on-site sessions, our team ensures the training fits your workflow and not the other way around.
Backed by clear materials, expert instruction, and flexible delivery, our online Excel intermediate course is built for learners who want practical outcomes, not just theory. To know more about group training options, speak to us now.
Will I get to work on Excel files during the course, or is it mostly lecture-based?
You’ll work through exercises in real time. Each key concept includes a hands-on task using provided Excel files, so you’re applying what you learn immediately.
Microsoft Excel Intermediate Training
Will this help if I’m preparing for an internal Excel test or role change?
Yes. The course strengthens core competencies and introduces intermediate techniques often evaluated during promotions or internal skill assessments.
Microsoft Excel Intermediate Training
What happens if Excel looks slightly different on my version?
We cover both Office 365 and older versions where needed. Trainers are familiar with interface variations and guide you accordingly during the session.
Microsoft Excel Intermediate Training
Will this course help reduce errors in large or shared spreadsheets?
Yes. A major focus is teaching data validation, and error-checking tools that help avoid manual mistakes, especially useful in shared workbooks.
Microsoft Excel Intermediate Training
Microsoft Excel Intermediate Training
Related Courses
-
Advanced
-
Fundamentals$375
-
Advanced$395
-
Advanced Level 2$395