Microsoft Excel Training – Level 2: Intermediate

Course overview

This intermediate course expands on the foundational knowledge from Microsoft Excel Level 1. Participants will learn advanced skills for creating efficient, accurate, and visually appealing workbooks. Topics include managing list data, using complex formulas and functions, creating PivotTables, performing advanced formatting, and generating detailed charts.

Why take this course?

• Practical, workplace-focused content rather than theory
• Taught live by an experienced industry instructor
• Small class sizes with time for your questions
• Downloadable exercise files and reference guides

Who should attend?

• Individuals seeking to improve their efficiency and accuracy in Excel
• Professionals who analyse and report on list data
• Users ready for intermediate features and data analysis techniques
• A working knowledge of Microsoft Excel Level 1 (Beginner) is recommended

Learning outcomes

• Use advanced worksheet techniques and data protection features effectively
• Apply complex formulas and essential functions to improve data accuracy
• Create and analyse data using PivotTables and structured worksheet tables
• Utilise conditional formatting and number formatting for enhanced data presentation
• Perform data analysis using tools such as Goal Seek and Quick Analysis
• Design professional charts with customised elements and formatting for clear reporting

Course modules

Hands-on practical activities

• Guided hands-on lab with provided sample files

• Scenario-based exercise drawn from a real workplace task

• End-of-course mini project reviewed by the instructor

Software & tools used

What's included

• PowerPoint slides
• Hands-on exercises and practice files
• 30 days of post-course instructor email support

Career benefits

• Add a genuinely practical skill to your CV
• Save hours every week on repetitive work
• Contribute to digital projects with confidence
• Progress toward specialist or lead responsibilities

Next online sessions

Fixed weekday dates, one session each week. All times shown in AEST.

Schedule & pricing

Frequently asked questions