Microsoft Excel intermediate training course
Length
1 Day
Price
$799
Cities
Melbourne, Sydney, Brisbane, Adelaide, Canberra, Perth
Learn More
Why Choose This 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 curriculum aligns with the skills measured in Microsoft’s Excel Associate certification, covering worksheet and workbook management, cells and ranges, tables, formulas and functions, and charts—giving you a strong foundation if you later choose to prepare for certification.
Excel continues to be the essential tool for budgeting, financial statements, sales reporting, and team performance dashboards. Building intermediate skills helps you organise data accurately, reduce manual effort, and present clear visual insights. This course focuses on the desktop application across Excel 2016, 2019, 2021, and Microsoft 365 editions, consistent with Lumify Work’s delivery for office apps training.
Training is delivered across Melbourne, Sydney, Brisbane, Adelaide, Canberra, and Perth. You will practise hands-on techniques such as formula cell referencing, named ranges, charts, data validation and simple PivotTables, all mapped to common workplace scenarios. A certificate of course attendance is included.
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?
Which Excel versions are covered?
Will I learn PivotTables in this course?
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
