Microsoft VBA for Excel

All courses can be delivered as is, or we can customise a training program so your team completes the exact topics they need in the number of days that suits your organisation.

You are currently viewing the VBA for Excel course page, but you can easily explore the other Excel courses using the links below.

Core Excel Courses

• Microsoft Excel Introduction – Learn the fundamentals of creating, editing, formatting, and managing spreadsheets, with a strong focus on accuracy, good design, and practical everyday use.
• Microsoft Excel Intermediate – Build more productive workbooks using formulas, functions, advanced formatting, charts, tables, and analysis tools such as Goal Seek and Quick Analysis.
• Microsoft Excel Advanced – Work with complex data, including PivotTables, data consolidation, advanced filtering, validation, protection, macros, and collaboration features.

Specialist Excel Courses

• Microsoft Excel Functions – Work confidently with logical, lookup, financial, statistical, text, and date functions.
• Microsoft Excel Data Analysis Add‑Ins – Analyse and visualise data using Power View, Power Pivot, Get & Transform, and Power Map.
• VBA for Excel (on this page!) – Automate Excel processes and build custom solutions using VBA.

The VBA for Excel course is designed for experienced Excel users who want to automate repetitive tasks, streamline processes, and create custom solutions within Excel. This course introduces programming concepts in a practical, step‑by‑step way, focusing on real‑world automation rather than theoretical coding.

Participants learn how to work within the VBA environment, understand the Excel object model, write and run procedures, create user‑defined functions, and build working VBA applications that interact directly with Excel workbooks, worksheets, and data.

In this course, you will learn how to:

• Understand VBA concepts and the Excel object model
• Work confidently with the VBA Editor
• Create and run procedures and macros
• Use variables and programming constructs
• Write code to manipulate Excel objects
• Create user‑defined functions
• Build custom user forms and controls
• Automate tasks and handle errors effectively

When you partner with CTO for onsite or customised Microsoft Excel training, you receive a learning experience designed specifically for your team. We focus on the Excel skills that matter to your work, your data, and your level of experience — no generic content and no time wasted.

Here’s what our clients value most:

• Training tailored to your needs – whether you follow a structured Excel learning pathway or select specific topics relevant to your business.
• Experienced, engaging facilitators who specialise in Microsoft Excel and bring real‑world examples to every session.
• Hands‑on, practical learning that builds confidence and equips your team to apply their skills immediately.
• A supportive and enjoyable experience — our trainers are known for making complex Excel concepts clear, logical, and approachable.

We bring training directly to your team, ensuring the content aligns with your systems, processes, and real-world Excel usage.

About Corporate Training Options

For over 30 years, Corporate Training Options has helped organisations across Australia build capability, improve productivity, and get more value from their software tools. Our customised approach ensures your team gains the right skills, in the right way, for long‑term success.

Whether you want a single Microsoft Excel course or a tailored multi‑level training program, we’re here to help.

Call us on 1300 667 660 to design the perfect training solution for your team.