Microsoft Excel intermediate Training
We offer an effective online Microsoft Excel Intermediate training course in Australia, perfect for working professionals with some experience who want to enhance their existing knowledge. This online training program is designed for individuals who want to advance from beginner to intermediate in MS Excel by learning Excel formulas and functions, data analytics, and reporting through our intermediate Excel classes, interactive workshops, and short courses. We offer practical training courses that are applied in the industry. We have the best Excel training courses in Melbourne, Sydney, Brisbane, Adelaide, Canberra, Hobart, and Perth. Get in touch with us today for further details about improving your Excel skills.
Length
1 Day
Price
$799
Cities
Melbourne, Sydney, Brisbane, Adelaide, Canberra, Perth
Learn More
Why Choose MS Excel Intermediate Course
Microsoft Excel intermediate is a practical, instructor-led training course for professionals who want to work smarter with formulas, functions, tables, charts, data validation, and introductory PivotTables. You’ll learn to create efficient workbooks with defined names, consistent formatting, and linked sheets, then apply conditional formatting and What-If Analysis to interrogate day-to-day business data.
The content covered here corresponds to the topics tested in the Excel Associate Certification, such as worksheets and workbooks management, cells and ranges, tables, formulas and functions, and charts – so that you have a solid base in case you want to pursue the certification.
Excel remains an indispensable application in budgeting, accounting reports, sales, and team performance dashboards. Developing advanced skills enables you to structure your data properly, save time on repetitive tasks, and create easy-to-understand visualisations. The course concentrates on the desktop version of Excel, which applies to the Excel 2016, 2019, 2021, and Office 365 versions – providing uniform courses for office applications.
Here are some of the exercises: formula cell references, creating named ranges, creating charts, using data validation, and basic Pivot Tables.
Prerequisites
- Candidates must have completed Excel Basic course
Exam
- There is no exam associated with this training course
Books
- Course material for Excel Intermediate provided
Delivery
- Instructor-led Classroom Training at our premises
- Live Virtual Online Training attend in real-time from anywhere
- In-House Training at your premises (4+ participants)
Skills Gained
- Use the available fill operations to fill the data series
- use different methods to work with worksheets
- Protect data in worksheets and workbooks
- Use the normal functions of worksheets
- Understand and create simple PivotTables
- Create more complex formulas and functions
- Apply a range of number formatting techniques to worksheet cells
- Apply conditional formatting to worksheet ranges
- Use Goal Search to determine the values needed to achieve the desired result
- Understand and use Excel’s quick analysis tools
- Create and work with tables
- Use different elements and functions to enhance charts
Audience
- For anyone who uses Microsoft Excel at work and wants to improve their skills and knowledge
Price
| Days | Friday | Mon & Tue | Saturdays only |
| Time | 9:30 am to 5:00 pm | 6:00 pm to 9:00 pm | 10:00 am to 5:00 pm |
| Duration | 1 day | 1 week | 1 week |
| Price | $799 | $799 | $799 |
Outline
- Advanced Data Filling – Use Flash Fill, create and manage custom fill lists, and extract complex patterns.
- Worksheet Management – Hide/unhide sheets, group worksheets, freeze panes, split windows, and apply tab colours.
- Data Protection – Protect worksheets and workbooks, set passwords, and manage restricted access to cells.
- Essential Functions – Work with IF, LOOKUP, COUNT, ROUND, MOD, DATE, TODAY, NOW, VLOOKUP, and HLOOKUP.
- PivotTables – Create, format, filter, and customise PivotTables for dynamic data analysis.
- Complex Formulas – Build nested and multi-step formulas, manage recalculation, and document formulas.
- Advanced Number Formatting – Apply custom formats for currencies, dates, fractions, large numbers, and negative values.
- Conditional Formatting – Use colour scales, data bars, icon sets, and advanced rules for dynamic cell formatting.
- Data Analysis Tools – Perform Goal Seek, use Quick Analysis tools, and create worksheet tables for structured data.
- Charts and Visualisation – Add chart elements, apply advanced formatting, use sparklines, and customise chart objects.
Terms & Conditions
The supply of this course/package/program is governed by our terms and conditions. Please read them carefully before enrolling, as enrolment is conditional on acceptance of these terms and conditions. Proposed course dates are given, course runs subject to availability and minimum registrations.
Frequently Asked Questions (FAQ's)
Is this course suitable if I already know Excel basics?
Yes. It’s designed for users who can build simple spreadsheets and want to step up to named ranges, conditional formatting, data validation, tables and introductory PivotTables.
Which Excel versions are covered?
Training uses the desktop app and is suitable for Excel 2016, 2019, 2021 and Microsoft 365 editions; the course does not focus on the web version.
Will I learn PivotTables in this course?
Yes. You will create simple PivotTables and apply key formatting and filtering options to explore data quickly.
Our Partnership
Reliable certification testing is vital for validating professional skills in today’s tech-driven world. As a Pearson VUE Authorised Centre, we provide a secure environment for globally recognised IT exams. This partnership ensures convenient access to certifications with the highest standards of integrity and accuracy.
$74,000
Average annual salary for administrative and data-entry professionals in Australia who use Excel regularly (varies by role and experience).
81%
Employers prefer candidates with strong Excel skills for roles involving data management and reporting.
12%
Year-on-year growth in job opportunities requiring Excel proficiency across Australian industries.
$2.5B
Estimated size of the Australian business analytics and productivity software market, driven by Excel usage.
5,000+
Australian companies actively seeking professionals with Excel skills for roles in administration, finance, and data analysis.
96%
Student satisfaction rate reported by leading Australian Excel and productivity training programs.
Our Accreditations
