Excel Courses Melbourne

Our one-day Excel courses (Beginner, Intermediate, Advanced and Excel for Data Analysis) are $385 incl GST each. The two-day Excel Visual Basic (VBA) course is $990 incl GST. You can also book any two one-day courses and receive a third one-day Microsoft Office course free as part of our Microsoft Training Package, which is $770 incl GST and saves you $385. Every course includes a PDF course manual, a certificate of completion, free email support for 12 months and free class re-sits for 8 months.

We deliver classroom Excel training in Sydney (North Sydney) and Melbourne (Collins Street), and live online Excel training everywhere else in Australia, including Brisbane, Perth, Adelaide and Canberra. Our Online Live classes are taught in real time by a Microsoft Certified Trainer, so wherever you are in Australia, you get the same hands-on, instructor-led experience as our classroom students.

If you have little or no experience, start with Excel Beginner. If you can build a formatted spreadsheet with basic formulas and want to look up, summarise and analyse data, choose Intermediate. If you already use lookups, Excel Tables and PivotTables and want to model scenarios, control data entry and automate tasks, choose Advanced. For Power Query and Power Pivot, choose Excel for Data Analysis; for writing VBA code, choose Excel Visual Basic (VBA). Call our team on 1300 888 724 if you’d like help choosing.

Yes. The Excel Beginner course assumes no prior experience and starts with the fundamentals, including navigating spreadsheets, formatting cells, rows and columns, building basic formulas and functions, and working faster with shortcuts. Most students are confident using Excel for everyday tasks straight after the course.

Beginner covers the foundations: entering and editing data, formulas and functions such as SUM and AVERAGE, cell referencing, formatting, managing worksheets, sorting, filtering, charts and printing.

Intermediate moves into the tools used in day-to-day business reporting: SUMIFS and COUNTIFS, IF and other logical functions, date functions, XLOOKUP and VLOOKUP, dynamic arrays, Excel Tables, PivotTables and PivotCharts, conditional formatting and chart presentation.

Advanced covers modelling, control and automation: INDEX and MATCH, INDIRECT and OFFSET, advanced dynamic array formulas with LET, text and financial functions, data validation, Goal Seek, Scenario Manager and Solver, linking and consolidation, protection, advanced PivotTable calculations and recorded macros.

Each level assumes the skills taught in the level before it.

Yes, if you already have the skills it teaches. Intermediate assumes you can build formatted spreadsheets with formulas, functions, sorting, filtering and simple charts. If you’re unsure, check the Beginner outline or call us.

XLOOKUP and PivotTables are introduced in Excel Intermediate, alongside VLOOKUP, SUMIFS, dynamic arrays, Excel Tables and PivotCharts. Excel Advanced takes them further with two-way lookups, INDEX and MATCH, and PivotTable calculated fields, grouping and running totals, and adds data validation, Solver and recorded macros. Power Query and Power Pivot are taught in Excel for Data Analysis, and writing VBA code is taught in Excel Visual Basic (VBA).

Excel Beginner needs no prior experience, only general mouse, keyboard and Windows skills. Intermediate assumes you can create formatted spreadsheets containing formulas, functions, sorting, filtering and simple charts. Advanced assumes you are comfortable with cell referencing, Excel Tables, lookup functions, dynamic arrays and PivotTables. If you are unsure where you sit, our team can help you self-assess on 1300 888 724.

Each one-day course runs for a single day and carries 6 CPD hours. Excel Visual Basic (VBA) course runs over two days and carries 12 CPD hours. Many students build their skills over time by progressing from Beginner to Advanced across three one-day courses.

Yes. Both formats use the same content, the same Microsoft Certified Trainers and the same small class sizes of up to 10 students. Classroom training gives you a dedicated learning space in Sydney or Melbourne, while Online Live gives you the flexibility to learn from home or the office anywhere in Australia, with full opportunity to ask questions and share your screen for help.

No. You can book now and pay later; no payment is required at the time of booking.

Yes. You can repeat the same course free of charge, as many times as you like, within 8 months of your original course.

You receive a Certificate of Completion from Dynamic Web Training, which many students use as evidence of their CPD hours (6 for a one-day course, 12 for Excel Visual Basic (VBA). Please note this is a certificate of completion rather than a nationally accredited qualification or a Microsoft certification. If you need to sit a Microsoft certification exam, contact our team, and we can advise on the best preparation path.

Yes. We deliver in-house corporate Excel training for groups Australia-wide, either at your workplace, in our Sydney or Melbourne classrooms, or Online Live. Group training can be tailored to your team's data and skill level. Call us on 1300 888 724 or enquire online to discuss a corporate booking.

For the best Online Live experience, you will need a Windows PC or laptop (a second screen or monitor is recommended), a broadband internet connection, the Microsoft Teams app, a headset or earbuds with a microphone, and Microsoft Office installed. Two business days before your course, we email you the Teams joining link, along with the training files and course book.

Book two Excel courses as part of our Microsoft Training Package, and you will receive the third course for free! To book the course online, please choose 'Microsoft Training Package' from our Training Packages webpage. Alternatively, please call us on 1300 888 724 during business hours, and we can book it over the phone.

Classes run from 9.00am to 5.00pm with breaks, and are taught through business scenarios with hands-on exercises throughout. You work through the exercises yourself with the trainer’s guidance, and keep the course manual and exercise files for reference.