Microsoft Excel Training Courses
(4.83 out of 5) 28183 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
Such a great course learnt so much and will be able to use in my day-to-day work and can see what I have learnt will save time. Thank you/
this course was so helpful, I have learnt so much today Cath was easy to understand, patient and had a lot of knowledge to share.
Great job on the Excel today! It was useful, and I even learned some new features I didn't know existed. Definitely a productive session!"
Really enjoy Wayne Penn's style of presenting. Wayne made sure to check in with everyone and did not rush past. Looking forward to putting some of the learnings into practice.
Thanks Wayne for delivering such an engaging and insightful course! Your clear explanations made the learning experience highly valuable.
Absolutely love Jill! There was no fluffing around, she was efficient and an amazing teacher. I found no troubles and very easy to follow along.
Loved it!Jill was amazing and I have gained new and valuable skills. Looking forward to the next one.
- It was an insightful and knowledge filled day! Our instructor was easy to understand and very clear was very happy with the course!
Fantastic experience from Duane and a fantastic teacher. Would highly recommend to others who are seeking a similar experience. Hope to see him again in the advance training course. Thank you Duane. -Aaron
Instructor Duane was clear, concise, helpful & friendly. Wonderful experience. Duane made learning fun.
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