Excel Macros & VBA Course

Excel Macros & VBA Course

Stop Doing Manually What Excel Can Do Automatically

Master Excel VBA and Reclaim Hours Every Week

You already know Excel. But if you're still copying and pasting, reformatting the same reports, or waiting on IT for tools you could build yourself - there's a better way.

This course teaches you Excel VBA from the ground up, with hands-on projects drawn from real business scenarios. No programming background needed. By the end, you'll be writing macros that save you hours, building custom tools your team will actually use, and solving problems Excel's built-in features simply can't touch.

Practical skills. Real results. No fluff.

Who This Course Is For

This course was built for:

  • Excel users tired of doing the same manual steps over and over - copying, pasting, reformatting.
  • Analysts and finance professionals who want to produce reports in minutes, not hours.
  • Anyone who's tried to learn VBA before and found it confusing or overwhelming
  • Professionals who want to stand out in their current role or open doors to more technical positions.
  • Business owners and managers who want custom Excel solutions without depending on developers or IT.

Real Results, Not Just Theory

We don't teach VBA syntax for its own sake - we teach how to use it to solve real problems in your work.

By the end of this course, you'll be able to:

  • Automate repetitive tasks that currently take hours - run them in seconds
  • Build custom tools tailored to your exact workflow - no IT required
  • Read, understand, and modify any VBA code you encounter at work
  • Impress colleagues and managers with solutions they didn't think were possible in Excel
  • Add a genuinely marketable, in-demand skill to your resume
  • Build complete, working Excel applications using a proven four-step framework

What You'll Learn

10 modules. 10+ hours of video instruction. Downloadable practice files and code included throughout.

VBA Fundamentals

Build on Solid Foundations

Get the lay of the land. Learn variables, data types, and operators - the building blocks every macro depends on. Victor demystifies the jargon from the start.

Control Structures

Make Your Code Think

If/Then, Select Case, For loops, Do While - these are the tools that let your macros make decisions and handle any amount of data automatically.

Excel Object Model

Understand How Excel Thinks

Workbooks, Worksheets, Ranges - learn the hierarchy that underpins all VBA. Once this clicks, everything else becomes logical.

Writing Reusable Macros

Write Code Once, Use It Everywhere

Sub procedures, functions, and scope. Build macros that you can drop into any workbook and run immediately - no rewriting required.

Working with Ranges & Cells

Control Every Cell in Your Workbook

Read, write, format, and loop through data at scale. This is where automation becomes genuinely useful in day-to-day work.

Excel Tables in VBA

Dynamic Data, Effortless Filtering

Use VBA to work with structured Excel Tables - sorting, filtering, and referencing data that grows and shrinks automatically.

Named Ranges

Write Code That's Easy to Maintain

Named ranges make your VBA readable, flexible, and far less brittle. Learn how to use them so your macros survive changes to your spreadsheet layout.

Arrays

Handle Large Data Sets with Speed

Arrays are the power tool for processing big data in VBA. Use them to slash run times and tackle problems that would otherwise bring Excel to a crawl.

UserForms

Build Professional Data Entry Tools

Create polished forms for data entry, user input, and report generation - turning your spreadsheet into a proper application other people can use confidently.

Building Custom Applications

Put It All Together

Apply everything in a complete, end-to-end project using Victor's four-step VBA framework. You'll finish with a working custom application you built yourself.

Course Curriculum

15 chapters · 150 lessons · 10+ hours of video

1. Welcome 7 lessons
  • 1.01 Welcome to the course
  • 1.02 How to get the most out of this course
  • 1.03 PRO TIP: Adjust video speed
  • 1.04 Roadmap & FAQ's
  • Quiz - Module 1
  • 1.05 Start with why?
  • 1.06 Motivation vs Habit
Bonuses 5 lessons
  • Code Vault: Top 40 Code Samples (Web version)
  • Code Vault: Top 40 Code Samples (Excel version)
  • VBA Development Cheat Sheet
  • Speed Learning Top 10 Tips
  • Speed Learning eBook
2. Macros and VBA 11 lessons
  • 2.00 Roadmap for Level 1 (Modules 1 - 4)
  • 2.01 Introduction to macros and VBA
  • 2.02 Recording and playing back macros
  • 2.03 Saving macros and macro security
  • 2.04 More ways to play back macros
  • Quiz - Module 2
  • 2.05 Projects introduction
  • 2.06 Project 1: Formula auditing macros
  • 2.07 Project 2: Workbook navigation macros (shapes)
  • 2.08 Project 3: Workbook navigation macros (buttons)
  • 2.09 Project 4: Personal macro workbook
3. Excel VBA Editor 15 lessons
  • 3.01 Unlock the power of macros with the VBA editor
  • 3.02 Finding your way around the VBA editor
  • 3.03 Writing our first macros in the code window
  • 3.04 How to modify existing macros
  • 3.05 The importance of comments for code readability
  • Quiz - Module 3
  • 3.06 Projects introduction
  • 3.07 Project 1: Activating the VBA editor
  • 3.08 Project 2: Using the VBA editor
  • 3.09 Project 3: Your first written macros
  • 3.10 Project 4: Editing your recorded macros
  • 3.11 Project 5: Make your macros easier to read
  • BONUS: Top hacks for the VBA editor (Part 1)
  • BONUS: Top hacks for the VBA editor (Part 2)
  • BONUS VBA Code: List all macros and shortcuts
4. Excel Object Model 13 lessons
  • 4.01 Overview of the Excel Object Model
  • 4.02 Excel object references and simplifying references
  • 4.03 Excel object properties with the macro recorder, plus two ways to simplify references
  • 4.04 Excel object methods
  • 4.05 Excel object events
  • 4.06 Learning more about the Excel Object Model
  • Quiz - Module 4
  • 4.07 Projects introduction
  • 4.08 Project 1: Excel object references using the dot operator
  • 4.09 Project 2: Playing with object properties
  • 4.10 Project 3: Playing with object methods
  • 4.11 Project 4: Playing with object events
  • 4.12 Project 5: Using the Excel object browser
5(A). Variables and Constants 9 lessons
  • 5.00 Roadmap for Level 2 (Modules 5 - 7)
  • 5.01 Variables, Constants and Data Types
  • 5.02 Option Explicit
  • 5.03 Declaring Variables
  • 5.04 Type Mismatch and Variants
  • 5.05 Scope
  • 5.06 Declaring Constants
  • Quiz - Module 5A
  • Module 5 Handout - Vital Building Blocks
5(B). Controlling Program Flow 7 lessons
  • 5.07 If Then
  • 5.08 Select Case (1)
  • 5.09 Select Case (2)
  • 5.10 For Next
  • 5.11 For Each Next (1)
  • 5.12 For Each Next (2)
  • Quiz - Module 5B
5(C). Building Blocks (Projects) 9 lessons
  • Projects Introduction
  • Project 1: Declaring Variables
  • Project 2: Declaring Constants
  • Project 3: Option Explicit
  • Project 4: Scope
  • Project 5: If Then
  • Project 6: Select Case
  • Project 7: For Next
  • Project 8: For Each Next
6(A). Workbooks and Worksheets 9 lessons
  • 6.01 Introduction to the Big Three
  • 6.02 Workbooks (No User Input)
  • 6.03 Workbooks (User Input)
  • 6.04 Workbooks (Information / Properties)
  • 6.05 Worksheets (Names)
  • 6.06 Worksheets (Add)
  • 6.07 Worksheets (Delete)
  • 6.08 Worksheets (Move, Copy, Hide, Protect)
  • Quiz - Module 6A
6(B). Ranges 14 lessons
  • 6.09 Ranges - Select
  • 6.10 Ranges - Write and Read
  • 6.11 Ranges - Copy Values and Clear Contents
  • 6.12 Ranges - Borders
  • 6.13 Ranges - Comments
  • 6.14 Ranges - Cut, Copy, Paste
  • 6.15 Ranges - Paste Special
  • 6.16 Ranges - Insert, Delete, Hide, Unhide
  • 6.17 Ranges - Rows and Columns
  • 6.18 Ranges - Resize
  • 6.19 Ranges - Offset, Intersect, Union
  • 6.20 Ranges - Variable Size
  • Quiz - Module 6B
  • Module 6 Handout - The Big Three
6(C). The Big Three Projects 8 lessons
  • Projects Introduction
  • Project 1: Save and Close Workbooks
  • Project 2: Create New Workbook for Each Worksheet
  • Project 3: Protect All Worksheets
  • Project 4: Synchronize Worksheets to the Active Sheet View
  • Project 5: Sort Sheets Alphabetically
  • Project 6: Learning About Ranges
  • Project 7: Tic Tac Toe
7. User Interaction (Input Boxes, Message Boxes, User Forms) 13 lessons
  • 7.01 Introduction to User Interaction
  • 7.02 InputBox Function (Simple)
  • 7.03 InputBox Function (Improved)
  • 7.04 InputBox Method (Ranges)
  • 7.05 Message Boxes
  • 7.06 Introduction to User Forms
  • 7.07 Progress Bar Design
  • 7.08 Progress Bar Coding
  • Quiz - Module 7
  • Projects Introduction
  • Project 1: Input Boxes
  • Project 2: Message Boxes
  • Project 3: Progress Bar User Form
8. The Power of Named Ranges 10 lessons
  • 8.00 Roadmap for Level 3 (Modules 8 - 10)
  • 8.01 Introduction to Named Ranges
  • 8.02 Adding and Resizing Named Ranges
  • 8.03 Selecting and Looping Named Ranges
  • 8.04 Deleting Named Ranges
  • Quiz - Module 8
  • Projects Introduction
  • Project 1: Adding Named Ranges
  • Project 2: Resizing Named Ranges
  • Project 3: Deleting Named Ranges
9. Excel Tables 9 lessons
  • 9.01 Introduction to Excel Tables
  • 9.02 Table Anatomy (Creating Tables, Selecting Table Parts)
  • 9.03 Sorting, Filtering and Total Row Calculations
  • 9.04 Table Modifications - Insert, Remove, Clear
  • Quiz - Module 9
  • Projects Introduction
  • Project 1: Adding Excel Tables
  • Project 2: Sorting and Filtering Excel Tables
  • Project 3: Keeping the Top 20% of Test Scores
10. Arrays and VBA Program Development 11 lessons
  • 10.01 The Benefits of Using VBA Arrays
  • 10.02 Static Arrays
  • 10.03 Dynamic Arrays
  • 10.04 Overview of Student Grading Spreadsheet (Part 1 of 3)
  • 10.05 VBA Deep Dive into Student Grading Spreadsheet (Part 2 of 3)
  • 10.06 Filter and Sort Using Worksheet Events (Part 3 of 3)
  • 10.07 Program Development Cycle (PCTA)
  • Quiz - Module 10
  • Projects Introduction
  • Project 1: Static 1D Arrays
  • Project 2: Dynamic Arrays

What Students Are Saying

Meet Your Instructor

Victor Chan

Your instructor, Victor Chan, is the founder of Launch Excel and has spent his career using Excel to solve real business problems - not just teach theory.

Before building Launch Excel, Victor worked as an auditor at Deloitte, a management accountant at CSR plc (later acquired by Qualcomm for $2.4 billion), and a Business Assurance Manager at ARM plc (later acquired by SoftBank for $31.4 billion). He knows what it means to work under pressure with data, and he builds his courses around the skills that actually matter at work.

His YouTube channel has accumulated over 4.6 million views - not because he's flashy, but because he explains things clearly, builds from first principles, and doesn't waste your time.

Also Included with Your Enrolment

Alongside the core course, you'll also receive:

  • VBA Support System - ongoing support in the Member's Only Support Area
  • VBA Code Vault - 40 hand-picked, copy-and-paste-ready code snippets for common tasks
  • VBA Dev Cheat Sheet - a single-page quick reference covering Victor's four must-have development steps
  • Peak Learning Ebook - evidence-based techniques to learn faster and retain more
  • Projects - helps you apply what you have just learned by using it in real world scenarios
  • Quizzes - reinforce what you learn by taking the quiz after each module

Enrol Now

One payment. 30-day money-back guarantee*.

Choose Currency
  • Instant access to all 10 modules and 10+ hours of video
  • Downloadable practice files and fully working VBA code examples
  • Unlimited 24/7 access - pause, rewind, and replay at your own pace
  • Certificate of completion - shareable on LinkedIn and your resume
  • Risk-Free Guarantee - Try it free for 30 Days*
  • Online Access : 12 months online access to the course(s)
  • Online + Download : 12 months online access to the course(s) + download the course videos to keep
  • GST : Prices are shown exclusive of GST for Australian customers.

Online Access

USD $299Add to cart

USD $299Add to cart

One-time payment

  • Stream all course videos via the website
  • Downloadable workbooks and VBA code
  • All 6 bonuses included
  • Certificate of completion
  • 30-day money-back guarantee

USD $299Add to cart

Online + Download

USD $598Add to cart

USD $598Add to cart

One-time payment  ·  Keep the videos forever

  • Everything in Online Access
  • Download and keep all course videos
  • Yours to keep permanently
  •  
  •  

USD $598Add to cart

Guarantee

Guarantee

This course is delivered entirely online, simplifying every step of your learning journey. There’s nothing physical to return if you find the course isn’t for you. And no wasted time; if you already know a topic, you can skip ahead and keep momentum.

Here’s our commitment:

Enroll now and immerse yourself - truly engage with up to 30% of the course content. Download the course documents, watch the videos, interact with me directly to ask your questions. Dive deep to extract as much value as possible.

Then, pause and reflect: was your investment in this course worthwhile?

If you're not wholeheartedly convinced with a “YES,” simply inform me within 30 days. I’ll process your full refund promptly. This means you’re risking absolutely nothing by giving this opportunity a shot.

Please Note

Video Download. Videos become downloadable after the 30-day Money Back Guarantee period, allowing you online access until then.
Membership. Access to the training materials are exclusive to the individual enrollee. Sharing logins with others is not permitted.
Downloaded Content. Downloaded videos are for the personal use of the registered member only and must not be transferred or shared with others.
30-Day Money-Back Guarantee. Refund requests are honored provided that no more than 30% of the course content has been consumed. Access to all videos is logged.
0