Advanced Excel Course
This Advanced Excel course is designed for experienced Excel users who want to work more efficiently with complex data. Delivered live by an experienced instructor, the course is available in Sydney or online across Australia.
Advanced Excel Training – Live Online or In Person
Learn new advanced Excel skills with our one-day course.
Using Excel for awhile and want to expand your knowledge? Explore new advanced features of Excel to improve your data analysis skills with our one-day advanced Excel course.
Based in Sydney, this Advanced Excel course is delivered live by an experienced instructor, with in‑person and online options available across Australia.
Our live courses allow you to ask questions, work through real examples, and get immediate feedback, rather than following generic pre‑recorded content.
Explore advanced data analysis tools.
Learn to use the full range of features available in Excel including data protection, data linking, tables, scenario manager, PivotTables, advanced filters, data validation and more.
Let us teach you some advanced Excel skills.

What makes this an Advanced Excel Course?
This Advanced Excel course is designed for people who already use Excel regularly and want to improve their data analysis and reporting skills. You’ll learn how to work with large datasets, consolidate information from multiple sources, create advanced PivotTables, apply data validation, automate repetitive tasks using macros and take advantage of powerful tools such as Power Query.
By the end of the course, you’ll be able to build more efficient spreadsheets, reduce manual work and gain deeper insights from your business data.
Instructor-Led Advanced Excel Course
Who is this course for?
This course is aimed at those who are experienced Excel users and wish to expand their skills to utilise some of the advanced features of Excel.
Learning outcomes
At the completion of Microsoft Excel Advanced you should be able to:
- create a custom tab on the Ribbon
- protect data in worksheets and workbooks
- use data import and export functions
- use data linking to create more efficient workbooks
- use the data consolidation feature to combine data from several workbooks into one
- use group and outline options to collapse and expand data easily
- automatically add subtotals to a worksheet
- create and work with scenarios and the Scenario Manager
- use advanced filters to analyse data in a list
- construct and use PivotTables using some of the more advanced techniques
- create and edit a PivotChart
- insert and use text-based functions
- use a variety of data validation techniques
- create and record a macro in Excel
- create and use a range of controls in a worksheet
Prerequisites
Our Excel Advanced course assumes reasonable knowledge of the software as well as a general understanding of personal computers and the Windows operating system environment.
Course duration
Our Excel Advanced course is run over one-day but can be customised to suit your needs.
Course overview
Customise Excel
- Create a custom tab on the Ribbon
- Customise the Status Bar
Protecting Data
- Protect a worksheet
- Unprotect a worksheet
- Grant access to specific cells only
- Protect a Workbook
- Limit access to view a workbook
Import and Export
- View Data in a Delimited File
- Import Data using Power Query
- Access the Power Query Editor
- Insert a Web Query
- Embed Excel in a Word Document
- View Data Connections
Data Linking
- Link data between worksheets
- Link data between workbooks
- Update links between workbooks
Data Consolidation
- Consolidate Data with identical layouts
- Create a linked consolidation
- Consolidating data using the SUM function
Group and Outline
- Create an automatic outline
- Working with an outline
- Creating a manual group
- Grouping by columns
Subtotals
- Insert a Subtotals
- Remove a Subtotal
- Create a Nested Subtotal
- Copy Subtotal Data
Scenarios
- Create a Scenario
- Display each Scenario when needed
- Use Named Ranges in Scenarios
- Create a Scenario Summary Report
Advanced Filters
- Use an Advanced Filter
- Extracting data with advanced filters
- Use Formulas in criteria
- Use Wildcards in criteria
- Clear an Advanced Filter
PivotTable Features
- Insert a PivotTable
- Add Fields to a PivotTable
- Use SUM and COUNT in a PivotTable
- Format PivotTable Values
- Display the percentage of total
- Sort in a PivotTable
- Drill-down Data in a PivotTable
- Create Custom Field Names
- Customise Subtotals and Grand Totals
- Group Data in a PivotTable
- Create a Calculated Field
- Insert a PivotTable Slicer
- Refresh a PivotTable
PivotCharts
- Insert a PivotChart
- Define the PivotChart structure
- Change the PivotChart type
- Move a PivotChart
Data Validation
- Apply Data Validation to Text/Numbers
- Create a drop-down list
- Customise the Input message
- Customise the Error message
- Circling invalid data
Macros
- Set Macro Security
- Record a simple Macro
- Run a Macro
- Edit or Delete a Macro
Controls
- Insert a Combo Box Control
- Insert a Spin Button Control
- Insert a Group Box Control
- Protect a Worksheet with Controls
Frequently Asked Questions
This course is designed for experienced Excel users who already work with formulas, worksheets and data and want to learn more advanced analysis and automation techniques.
While completing an intermediate course is helpful, it is not mandatory. Participants should already be comfortable using formulas, managing worksheets and working with data.
Yes. Participants learn how to import data using Power Query and work with the Power Query Editor.
Yes. The course covers advanced PivotTable features including calculated fields, grouping, slicers and PivotCharts.
Yes. The course can be delivered live online or in person.
The Advanced Excel course is delivered by Belinda Anderson, an experienced Microsoft trainer who has been providing Excel training since 2001. Belinda has trained thousands of participants from government organisations, schools, universities, non-profits and businesses across Australia, helping people develop practical Excel skills they can apply immediately in the workplace.
Unlike self-paced videos, an instructor-led Excel course allows you to ask questions, receive immediate feedback and work through real-world examples. Training can also be tailored to suit the needs of your organisation or team, ensuring the content is relevant to the work you do every day.
Yes. The course can be tailored to suit your industry, skill levels and business requirements. A pre-course skills assessment can also be used to help ensure the training focuses on the areas that will provide the greatest benefit to participants.
Yes. Participants receive comprehensive course notes and can refer back to the training materials as they continue building their Excel skills after the course.
Testimonials
“Belinda’s training met all my expectations, it was very beneficial to my learning.”
“I started the courses with very little understanding of Excel. The format and the delivery of the training was very thorough, and I found it extremely helpful for my work. The course format was easy to follow and very suited to my needs for my occupation. The trainer made sure that any queries were answered and explained in a way that was easy to learn.”
“Belinda was incredibly knowledgeable, professional and a patient and informative instructor who was easy to understand. Belinda’s explanations were great to follow, and I never felt lost or left behind. The after service seems that it will also be comprehensive and readily available, with tools to use going forward.”
“Belinda is very organised and thorough, no small detail or question was a problem for Belinda.”
“By completing the pre-course skills assessment, the course was tailored to our needs, even though the team presented with varying levels of applied knowledge. Belinda was an outstanding presenter – clear, easy to follow and very well structured.”
“I really enjoyed this course and found it super beneficial, in particular the shortcuts to maximise time and efficiency.”
“The trainer covered some super useful tips that will be very handy. Great presentation skills and really understood her content.”
“All aspects of Excel that we wanted within our business was covered in an interactive and knowledgeable manner, Belinda was a fantastic teacher.”
“The instructor demonstrated exceptional knowledge, which greatly enhanced the delivery of the course.”
“The course material was tailored to the needs of the participants. The trainer came well prepared and organised and the delivery was engaging.”
“The course delivered by Belinda was great. She tailored the course to the different skill levels of our group and work with each of us to answer questions and work through things. The number of skills and tips picked up from the session exceeded my expectations. It was also delivered well and didn’t overcomplicate things.”
“The course was laid out and taught where I didnt fall behind and feel threatened with learning.”
“I was exceptionally pleased with Belinda’s training and teaching for my self and my colleagues, she was very accommodating with the fact that almost all of us in the class were struggling to use Excel in the work place. We were able to walk away with new knowledge and more confidence with Exel.”
“I learned a lot from this course, have been using Excel for a while.”
“Overall, the session was very helpful and practical. The explanations were clear, and the hands-on exercises made it easy to understand and apply the functions right away. “
“Fantastic course! Belinda was lovely and provided a surprisingly enjoyable experience in the world of excel!”
“I thought I knew Excel, but there’s also something new to know about it. Belinda was very knowledgeable about, very easy to learn from her.”
“Belinda was an amazing teacher and demonstrated the course objectives so well. Easy to absorb the information and extremely helpful.”
“Belinda was absolutely incredible. Her teaching style was engaging, clear, and incredibly effective, we learned so much from her. She made the course feel approachable and easy to digest, turning complex topics into something we could genuinely enjoy and understand.”
“I found the Excel training very valuable. I was a bit nervous that I would not be as advanced in my knowledge as some other people in the room but quickly relaxed when I met Belinda and could see the style of training. It was a very good pace, I found the examples Belinda had shared for practice were great, and I learned lots of tips and tricks along the way.”
“Belinda’s course was well-organised and structured in a way that was very easy to follow. I learnt a lot of new tips for Excel from the course.”
“Belinda explains things well and is very accommodating to different skill levels within the room.”
“The excel course was well designed and very easy to follow.”
“Belinda presented the topics in a clear and concise manner, ensuring that everyone remained engaged.”
“We had a worthwhile experience, learning about new aspects of Microsoft Excel and how to tie these to practical applications in our workday. Belinda was friendly and approachable, putting attendees at ease and making the day enjoyable. Her knowledge was also evident, including her ability to answer any and all questions we raised.”
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
Free Skills Assessment
Take advantage of our free online skills analysis prior to your training to ensure staff are undertaking the correct course.
We come to you
To save your business time, money and unnecessary travel, we come to you, delivering our training at your premises.
Email Support
Access unlimited support following your training course to build on your learning and ask any burning questions.
Course Manual
All courses include a downloadable course manual in PDF format covering all content for the course.
Certificate
After completing the course you’ll receive a certificate to show off your new-found knowledge and skills.
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.
Real-world examples
You'll work through real-world examples to reinforce learning and increase your confidence.
Customisable Courses
All courses can be customised to suit your team and include the topics you need and nothing you don't.
Related Courses
Not quite ready to undertake an advanced Excel course? Check out our other Excel course levels.

Excel Introduction
- 1 day course duration

Excel Intermediate
- 1 day course duration
Ready to find out more?
Complete the form below to request more information about our Advanced Excel training.
We’ll confirm suitability, delivery options, and pricing based on your needs.
You’ll receive a clear, practical response within 1–2 business days.
No generic sales follow‑ups – just experienced advice on the right training approach.
0418 820 572
available Monday to Friday
9:00am till 5:00pm
Email: info@beltan.com.au
