Microsoft Excel Training Courses
(4.83 out of 5) 28061 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
Great presenter and an easy to follow course with practical examples and detailed instructions. Increased my confidence with excel and enjoyed the day thoroughly. Thank you very much
Really good course. Was great do a refresh. Paul - DWT Trainer was really good at explaining everything and made sure everyone was up to speed and included everyone. He really took the time to ensure that everyone understood and explained how everything worked really well with slight hint of humor to keep everyone engaged. Thank you.
Jill was a great instructor. She was very knowledgeable about Excel and provided great insight. Good location and nice classroom - clean bathrooms and good facilities e.g. computer, drinks & snacks.
I found Andrew's Advanced Excel Course to be a valuable asset in expanding my Excel skills. The course covers a wide range of advanced topics, including financial modeling and VBA programming, with clear explanations and numerous examples. The instructor's support and the well-structured format made the learning process smooth and engaging. I highly recommend this course to anyone looking to master advanced Excel functionalities.
Andrew is a fantastic trainer and kept us all engaged and interested int he content and answered all our questions and made sure to cater for topics that were relative to our needs
I love the class and it provides a lot of useful information and knowledge I need. The trainer is helpful and nice.
Good summary of the topics, answered all questions well, was clear and easy to follow, provided constant check in to ensure we were following.
I loved this course, learnt so many functions that I didn't know existed. Pace is great and everything is very detailed!
This was very informative and learnt the short cuts and formulas which will make it simpler and more productive.
The training was exceptionally well-structured, comprehensive, and clearly explained. It has provided a strong foundation that will enhance my understanding as I progress to more advanced Excel concepts.
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
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
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
Professionals who want to improve their data analysis and reporting skills.
Individuals
Students aiming to boost academic performance and job prospects.
Businesses
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
