Microsoft Excel Training Courses
(4.83 out of 5) 27959 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
This was really great, honestly was exactly what I was looking for and will significantly help in my day to day job. Ben is a great teacher, and well worth while for individuals or for groups
This course was informative, and interesting. Even when I thought I had a good handle on some of the areas covered I still learnt new information. Some of the more basic content was a "surprise".
Course provided content that was new & relevant to me. Course length and speed were appropriate for the duration of the course & content. Enjoyed the day.
The course was comprehensive for the intermediate level. The instructor made sure that everyone was on the same page and adjusted the course pace accordingly. he also kept students engaged by making some jokes and keeping the atmosphere qutie casual.
Great course, Dani was a great facilitator and went through the day at a nice pace with good amount of breaks!
I really enjoyed learning the shortcuts to make using excel way easier. Dani's teaching was very good and loved how interactive she was!!
Alex was a great instructor, he guided the group at the perfect pace and made everyone feel comfortable to raise questions, ask for personal work related examples and spoke to all relevant points in the manual.
excellent pace and clear explanation. Just fantastic instructor. Got excellent learning and outcome.
Very valuable. Lots of learning. Was also looking for insights on the use of IF statements. Really liked the speed that Duane worked at and his engagement with the group.
Excellent course. I had received so much valuable information which they would be a great help for my work. The instructor was very knowledgeable and all my questions were answered and clarified.
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