Microsoft Excel Training Courses
(4.83 out of 5) 27997 Student Reviews
Microsoft Excel Courses - Instructor-Led Classroom or Online Live Training
Learn the Microsoft Excel skills you need with our instructor-led classroom or online live training. Our Excel workshops are designed to teach you how to master spreadsheets with confidence. You will learn how to use a variety of Excel tools, such as formulas and functions, create charts, sort and filter data, create reports, and more. You can also extend your Excel skills to an advanced level with pivot tables, data linking and consolidation, lookup functions, macros, Power BI and Visual Basic programming. All courses are delivered by Microsoft master trainers.
See Excel course dates in Sydney, Melbourne, Brisbane, Adelaide, Perth, Canberra and Online Live across Australia. For in-house corporate group training Australia-wide, please contact us directly.
We also offer Excel courses in an instructor-led Online Live format.
Book a Microsoft course package and Save
Enrol for two one-day Microsoft Excel courses and reveice a third one-day Microsoft course worth $396 for free.
Excel Courses
The Excel Beginner course will teach you the foundational skills to use the Excel application confidently. Upon course completion, participants should be able to produce formatted spreadsheets containing basic formulas and functions, proper formatting of cells, rows, and columns, and learn to use Excel efficiently using keyboard shortcuts. View Full Course Details
Take your Microsoft Excel spreadsheet skills to the next level with advanced techniques, including working with multiple workbooks, logical functions, date and time functions, Filtering data, conditional formatting, charting, and much more. View Full Course Details
Skilled Microsoft Excel users will learn advanced workbook automation and productivity techniques, including complex formulas and data analysis, Look Up functions, Pivot Tables, Pivot Charts, Data consolidation, macro creation, and more. View Full Course Details
Skilled Microsoft Excel users will learn to use Power Query and Power Pivot to implement Business Intelligence components into their workbooks and visualisation tools. View Full Course Details
Experienced Excel users will learn how to create macros, and user-defined functions, understand the VBA environment, and use a range of programming techniques to develop automated solutions in Excel. View Full Course Details
Excel Training Packages
Microsoft Training Package
Book any two 1-day Microsoft Office courses and receive a third 1-day Microsoft office course for FREE!
Course Inclusions
Free course repeats/re-sits for up to 8 months. This is a great way to build your Excel skills over time.
Free email support for up to 12 months the course; to maximise your Excel learning potential.
Small Class sizes; personalised learning experience for every student.
Instructor Led
Hands-on Instructor-Led Classroom or Online Live Training delivered by certified Microsoft Excel Trainers.
Course Manual
Printed course manual with step-by-step instructions; an excellent reference guide for well after the Excel class.
Computer Provided
Classes conducted in fully set-up computer labs. No need to bring your own Laptop.
Course Certificate
Certificate of Course Completion; to recognise your Excel skills.
Student Reviews
I really enjoyed this course. The skills were taught in a logical way and were very beneficial. Each topic introduced built on the previous ones. It was a very information rich two days so it will take me some time and practice to digest the information but I feel I have been given the tools to do so. I would recommend this course to others
Amazing session! It's my first time using Power Query - definitely useful for the analysing large data. Thanks, Adam
Thank you Adam for this course. Very dynamic, good examples and explanations. Clear and easy to follow. I learned a lot today on Power Query & Power Pivot!
Very clear - I do feel like it could have been slighlty faster paced with more emphasis on writing formulas
Adam made the content relevant to a wide range of data types, not just the examples provided. His upbeat and engaging teaching style kept the session light while still delivering practical insights. I learned several useful shortcuts and time-saving processes that I can apply immediately.
Valuable information i will take with me, a long day of learning but Tom made it fun and enjoyable :)
I did this course a week after Beginner's Excel. I got so much out of it; easy things I had no idea how to do that are simple things I can now do every day to save time as well as complicated formulas I'd never used before. Our instructor Sean was great and had me giggling through the whole day.
I did this as a refresher course after becoming more experienced with excels and found this very helpful and detail. The changes from the first session I did in August have been greatly improved my understanding of how excel works.
The course is made so it's very easy to follow. The formulas are made easy to understand as you build formulas in layers. The Table option is a good alternative to Pivot tables which is my main fall back
Adam was great, he kept everyone engaged and interactive. The morning session was VERY useful as there were a lot of new excel techniques I learnt about. Although I was familiar with most of the afternoon session information, I still learnt some helpful tips and quick key functions.
Frequently Asked Questions (FAQs)
Q: What are the prerequisites for each Excel course level?
A: The Beginner course requires no prior experience. The Intermediate course assumes basic Excel knowledge, and the Advanced course is for users with solid experience.
Q: How long do the courses last?
A: Most of our Excel courses are typically one day long. The Excel VBA course is two days long.
Q: Are there any Excel certificate provided?
A: You’ll receive a certificate of completion after finishing the course.
Q: How do I redeem the ‘buy two, get the third free’ offer?
A: Book two Excel courses as part of our Microsoft Training Package, and the third course will be free!
Q: What setup do I need for live Excel online training?
A: To get the best learning experience from Online Live training, you will need:
- A Windows PC or laptop (with a second screen/monitor)
- Broadband internet connection
- Zoom app installed
- A headphone/earbuds with a microphone. The ones that you use with your smartphone are sufficient.
- Microsoft Office Professional installed
- PLEASE NOTE: Two business days before the course date, participants will also receive the course invite email with Zoom joining links and links to download the training files and course book.
Q: How can I book my free repeat Excel class?
A: Dynamic Web Training offers FREE and UNLIMITED repeat classes for up to 8 months from the original course dates. These repeat classes are a great way to consolidate skills over an extended period!
Repeat Excel classes can be booked by telephoning us two business days prior to your preferred course date, and we will book you in if the course is confirmed to run with available seats. Our phone number is 1300 888 724. Quote your invoice number as a reference.
Why Learn Microsoft Excel?
Microsoft Excel is the industry-leading spreadsheet application designed to help you create polished, professional-looking spreadsheets and reporting. With Excel, you can process large amounts of complex data quickly and efficiently and present it in a way that’s easy to understand.
Excel is used across industries and job roles to manage data, create reports, analyse trends, manage projects and more. The tool helps improve productivity, organisation, and decision-making in the workplace, at home, and school.
Learning Excel can help you:
- ✓Increase productivity through automated functions, formulas, and shortcuts.
- ✓Improve data analysis with pivot tables, charts, and graphs.
- ✓Aid decision-making with accurate data modelling and analysis.
Course Levels: Beginner to Advanced
Dynamic Web Training’s one-day Excel courses cater to all levels — from beginners to advanced users
Beginner Microsoft Excel Course
Designed for beginners, this course covers:
- ✓Navigating the Excel interface
- ✓Basic formulas like SUM and AVERAGE
- ✓Formatting cells, rows, and columns
- ✓Formatting techniques for numbers
Intermediate Microsoft Excel Course
For those with basic knowledge, the intermediate course covers:
- ✓How to search and retrieve data from a spreadsheet
- ✓Techniques associated with creating better and more productive workbooks
- ✓Several Excel functions, including logical & date, and time functions
- ✓Data setup and management techniques
- ✓Conditional formatting
- ✓Advanced charting features
- ✓More streamlined methods to enhance efficient spreadsheet creation.
Advanced Microsoft Excel Course
For experienced users, the advanced course covers:
- ✓Using workbook automation and productivity features
- ✓Worksheet and workbook consolidation
- ✓Advanced pivot tables and data analysis
- ✓Lookup and Reference Functions
- ✓Linking Data
- ✓Financial Functions
- ✓Recorded Macros
Training Formats: In-Class & Online
We offer Excel courses in two flexible formats:
In-Class Excel Training
In-class training allows you to interact directly with the instructor and fellow learners. Our in-person Excel training is available in:
- ✓Sydney
- ✓Melbourne
- ✓Brisbane
Excel Training Online
Alternatively, complete your Excel training online with live, instructor-led sessions. Participate from anywhere in Australia for greater convenience and flexibility!
What You’ll Learn in Our Excel Courses
Learn new skills with our Microsoft Excel training courses, including:
- ▪Basic Excel Skills: Essential formulas, formatting, and simple charts.
- ▪Data Analysis: Pivot tables, charts, and conditional formatting.
- ▪Advanced Excel Features: Macros, VBA, Power Query, and Power Pivot.
- ▪Productivity Tips: Excel shortcuts and automation techniques.
Who Should Do Excel Training?
Our Microsoft Excel courses are ideal for:
- ▪Professionals who want to improve their data analysis and reporting skills.
- ▪Students aiming to boost academic performance and job prospects.
- ▪Businesses want to upskill teams with essential Excel knowledge around accounting, finance, marketing, and more.
Save $396
Book any two 1-day Microsoft Office courses and receive a third 1-day Microsoft Office course for
FREE!
For more info please
Call 1300 888 724
