Intermediate Excel Course
Length
1 Day
Price
$123
Days
Mon - Wed
Learn More
Why Choose This Course
If you already know the basics of Excel and want to take your skills to the next level, this course is the perfect choice. Excel is more than just a spreadsheet tool—it’s a powerful platform for data analysis, reporting, and decision-making. Employers across Australia value professionals who can go beyond simple formulas and formatting to create dynamic, efficient, and insightful spreadsheets. This course bridges the gap between beginner knowledge and advanced functionality, giving you the confidence to tackle complex tasks.
By enrolling in this course, you’ll learn how to use advanced formulas, logical functions, and data validation techniques to streamline workflows. You’ll explore tools like conditional formatting, pivot tables, and charts to analyse and present data effectively. These skills are essential for roles in finance, administration, project management, and any position that requires data-driven decisions. With practical exercises and real-world examples, you’ll gain hands-on experience that you can immediately apply in your job or business.
Flexibility is key, and this course is designed to fit your schedule. You can choose from live virtual classes, in-person sessions at our training centres in Melbourne, Sydney, Brisbane, Adelaide, Perth, and Canberra, or in-house training at your workplace. Our trainers focus on practical learning, ensuring you leave with skills that make a measurable impact on your productivity and career growth.
Investing in intermediate Excel skills is a smart move for professionals who want to stand out in today’s competitive job market. Whether you’re looking to improve efficiency, enhance reporting capabilities, or prepare for advanced analytics, this course will help you achieve your goals.
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
Objectives
- Build on foundational Excel skills to handle more complex tasks and data sets.
- Learn advanced formulas, nested functions, and logical operations for efficient calculations.
- Create and customise PivotTables for dynamic data analysis and reporting.
- Apply conditional formatting and custom number formats to enhance data presentation.
- Use data protection techniques, including worksheet and workbook security features.
- Explore advanced charting options and visualisation tools for professional reports.
- Utilise Goal Seek, Quick Analysis, and other tools for data-driven decision-making.
- Manage large datasets with tables, sorting, filtering, and duplicate removal.
- Automate repetitive tasks and improve workflow efficiency through advanced Excel features.
- Prepare learners to confidently apply intermediate Excel skills in real-world business scenarios.
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.
Price
| Days | Mon – Wed | 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 day | 1 day |
| Price | $123 | $123 | $123 |
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)
Who is this course designed for?
This course is ideal for individuals who already have basic Excel knowledge and want to advance their skills for professional or business use.
What topics are covered in the course?
You’ll learn advanced formulas, PivotTables, conditional formatting, data protection, complex charting, and tools like Goal Seek and Quick Analysis.
Do I need to complete the beginner course first?
While completing a beginner course is helpful, it’s not mandatory. Basic Excel knowledge, such as creating simple formulas and formatting cells, is recommended.
How is the course delivered?
The course is available through live virtual training, in-person sessions at our centres in Melbourne, Sydney, Brisbane, Adelaide, Perth, and Canberra, and in-house training at client premises.
Will I receive a certificate after completing the course?
Yes, participants will receive a certificate of completion, which can be used to demonstrate your intermediate Excel proficiency.
Our Partnership
In today’s data-driven world, where spreadsheets are essential for managing and analysing information across businesses and organisations, the importance of advanced Excel skills cannot be overstated. This course empowers you with practical knowledge to work with complex formulas, PivotTables, and data analysis tools, enabling you to organise, interpret, and present data with confidence.
$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
