Microsoft Excel Training Courses

Our one-day Excel courses (Beginner, Intermediate, Advanced and Excel for Data Analysis) are $385 incl GST each. The two-day Excel 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. 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.

PivotTables and PivotCharts, XLOOKUP and VLOOKUP, SUMIFS, dynamic arrays and Excel Tables are taught in Excel Intermediate. Advanced PivotTable calculations, INDEX and MATCH, data validation, Solver and recorded macros are taught in Excel Advanced. Power Query and Power Pivot are taught in Excel for Data Analysis, and writing VBA code is taught in Excel Visual Basic.

Both formats deliver the same high-quality content and instructor-led experience. Our classroom Excel training provides a dedicated learning environment in Sydney and Melbourne, while online live Excel training offers the flexibility to learn from your home or office across Australia.

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. The Excel Visual Basic for Application 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. We provide highly interactive Online Live Excel courses delivered in real time by our Microsoft Certified Trainers. You get the same hands-on experience and direct instructor support as in our classrooms, from anywhere in Australia.

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 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.

Our one-day Excel courses (Beginner, Intermediate, Advanced and Excel for Data Analysis) are $385 incl GST each. The two-day Excel 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. 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.

Both formats deliver the same high-quality content and instructor-led experience. Our classroom Excel training provides a dedicated learning environment in Sydney and Melbourne, while online live Excel training offers the flexibility to learn from your home or office across Australia.

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. The Excel Visual Basic for Application 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. We provide highly interactive Online Live Excel courses delivered in real time by our Microsoft Certified Trainers. You get the same hands-on experience and direct instructor support as in our classrooms, from anywhere in Australia.

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 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.