Learn excel vba &
excel macros


Wave Goodbye To Tedious Manual Work and Automate Your Day With Excel VBA

Let’s face it – much of what we do in Excel is a slog. 🥱

Yes, it’s fun to discover new Excel features.

Yes, it’s exciting to do trend analysis and spot an opportunity everyone else missed.

Yes, it’s rewarding to see your colleagues react to your beautiful new dashboard.

But that’s the sexy side of Excel. And unfortunately, most of your time isn’t spent on these tasks.

No, much of your work in Excel is slow, tedious, and boring.

Worst of all, it’s manual. You’re like a caveman, stacking rock upon rock using nothing but your blistered hands and gritted teeth.

Well, just like how the pulley automated the lifting of heavy objects, there’s an Excel tool to automate your manual work.

It’s called Excel VBA. You can start learning it today with this Excel VBA Macros Mastery Course!

If you are interested in learning about macros without much knowledge of programming and some knowledge of Excel, this course is your way to go.


Automate The Boring Stuff So You Can Spend More Time On What Excites You

Why not automate those borings Excel tasks so you can spend more time on what you enjoy?

Things like discovering new Excel features, analyzing data, and creating dashboards.

Imagine if you could free up three, five or even ten hour each week by automating manual tasks? How much more time would you have for these other, more exciting Excel tasks?

Not only does Excel VBA make your workday more enjoyable. Learning it also puts you in a position for better work and more pay.

The course also has exactly what I need to tackle important problems at work. I’m extremely impressed with the organization and professionalism of this course.

Make Your Resume Stand Out

99% of people have “Proficient in Excel” written on their resume.

But how many have “Proficient in Excel VBA”? 🤔

Very few.

After taking our Excel VBA Macros Mastery course, you’ll have it on your resume. And best of all, you’ll be able to prove it.

Excel VBA is used by the largest and most successful companies across the globe. Here is a list of just a handful of companies that use it:

  • Amazon
  • Cigna
  • Deloitte
  • Intel
  • JP Morgan Chase
  • Microsoft (of course)
  • Morgan Stanley
  • PayPal
  • Tesla
  • US Bank

Want to work for one of these companies one day? You’ll boost your chances if you know Excel VBA.

Excel VBA is used across numerous industries, too. Banking, finance, agriculture, healthcare, construction, hospitality – I could go on and on. It’s everywhere.

If you’re looking to stand out and not be just another Excel user, Excel VBA is how you get your resume to the top of the stack.

The quality of the course is sublime and progressive, both the instructions in the videos as well as the course material!

It made it possible for me to reach a very good level in vba programming in a few months. It would be impossible to achieve this level in the same amount of time, by learning things on your own. Thank you for all the work you put in this course.

Bavo P.

My Own History with VBA

Hi, I’m Leila Gharani. I’m a Microsoft MVP and have taught Excel to over 400,000 students through my courses.

My introduction to VBA started while working as an in-house consultant at a prominent paper & packaging company. Tasked with optimizing processes at major paper factories, my team and I focused on every area, including sales, procurement, and production.

I soon realized one of the main bottlenecks was the lack of automation. So much time was spent manually digging through numbers and creating reports. That was when I discovered VBA. There was this aspect of Excel that I hadn’t yet uncovered which could save my clients chunk loads of time.

I started teaching myself VBA by going through books, forums, and hundreds of blog posts. I soon started implementing VBA solutions for my clients, so they didn’t have to repeat the same tasks over and over again. They could just click a few buttons in Excel, go for a coffee and once they got back to their desk their report was ready.

The VBA-enhanced files we created were user-friendly, designed for easy use by anyone. VBA allows for customizing Excel to meet specific needs.

In this Excel VBA Macros Mastery course, I’ll guide you through utilizing VBA effectively, transforming your Excel skills and efficiency. Join me to upgrade your Excel capabilities.

Get Started Now!

Automate Anything You Need Done In Excel.

I Wanted this Course to Be Different

No, my course isn’t the only VBA course out there.

I know you have other options to learn this topic.

You could learn from another Excel expert, you could buy a course on Udemy, and you could even watch YouTube videos, piecing things together.

So, I asked myself, “How can I offer something different and better than all the other options?”

That’s when it hit me. 💡

Through my research, I found all the other VBA training and courses have one thing in common: They only give you one piece at a time. They don’t give you the entire puzzle. They also don’t give you ready-made code books for quick fixes. Or real-world projects to learn from.

At that moment, I knew how to structure our VBA course.

We recently added three more real-world projects for you to learn from and be inspired by – including a web scraping project, consolidating Bill of Materials and working with protected work sheets.

Learn VBA By Building Projects and See How Each Piece Contributes To The Puzzle

A VBA project is like a completed puzzle.

Problem is, other trainings only give you a handful of pieces – and from all different puzzles!

They give you three pieces from the hot air balloon puzzle. Then, they toss you two pieces for the basket of fruit. And finally, a corner piece for the mountain lake.

How the heck are you ever supposed to build a finished project this way!?

It’s a confusing way to teach VBA, in my opinion.

Instead, in our Excel VBA Macros Mastery course, you’ll build three separate projects. Each project was specifically chosen to teach you different, important features of Excel VBA.

Finally – and this is the magic – you only complete projects using techniques you’ve already learned.

In other words, we teach you the pieces of the puzzle, and then put them together into a finished project.

It’s a layered, step-by-step approach that will teach you Excel VBA faster than anything else.

Leila has the amazing ability to not only teach this highly difficult subject in a comprehensible way, but also to combine it with interesting and useful examples plus fancy layouts. I’m very pleased with this course and can’t wait to code my own little tools… Thank you so much!

Alexander Brück, Senior Business Intelligence Analyst

Watch The Video For A Quick Overview Of The Course

🆕 Certified Achievement Badge

Earn Your Digital Badge Powered by Credly

After completing the course, you’ll receive a digital badge. It shows potential employers that you have mastered Excel VBA and Macros, crucial for automating tasks and enhancing efficiency in Excel.

This credential showcases you as a valuable asset in roles that demand expertise in Excel automation, data manipulation, and process optimization.

Our Digital Badges can easily be shared. You can add them to your LinkedIn profile, include them in your resume, or spread the word across your social networks – all it takes is a simple click.

Stand out to employers by clearly displaying your skills with a digital badge from XelPlus.

Your First Project: Automated Table Of Contents

As I mentioned, there are three main projects you’ll complete.

In this first project, you’ll create a tool to automate a table of contents inside Excel. You’ll complete the project using skills you’ll learn in that section’s lessons, such as:

  • Getting familiar with the Visual Basic Editor
  • Creating macros and 7 different ways to run them
  • Understanding the difference between macros and VBA
  • The most useful built-in VBA functions
  • Debugging so you can quickly find & fix errors

After learning these techniques, plus more, you’ll tackle the table of contents project. Not only will you have a finished, working file. You’ll have all the skills you learned along the way.

Your Second Project: Create A Sales Reporting Tool

Using what you’ve already learned, your next mission will be to create a regional sales reporting tool.

But your existing skills won’t be enough for this (slightly) more difficult project. That’s why, before entering the project area, you’ll enter the classroom.

You’ll first learn these necessary techniques:

  • Loops! These little guys will become your best friends because they’ll automate so much for you
  • Arrays, which allow you to quickly run procedures
  • How to create Excel tables using VBA
  • Telling Excel to open folders and files, using VBA
  • How PivotTables work with VBA

Plus more.

Project 2 completed in Excel VBA Macros Mastery Course
Excel Interface For Sales Reporting Tool

Once you’ve completed these lessons, you’ll download the project workbook and create your sales reporting tool. You’ll be surprised at how easy it is after watching the previous lessons.

Finally, you’ll move on to tackle the third project.

Armed with these foundational skills, you’ll be ready for your second project.

Your Third Project: Create An Invoicing Tool

Here’s why I love this one…

You know how I’m all about applying Excel to solving real-world problems, right? Application matters more than theory.

Well, this project is based off an actual project I created during the time I was a freelancer. It’s a pretty sweet tool, I’ve got to say. Our clients loved how easy we made it for them to send invoices.

Project 3 completed in Excel VBA Macros Mastery Course
Excel Interface For Invoicing Tool

As a lead-up to creating this invoicing tool, you’ll learn these critical VBA skills:

  • How to make applications talk to each other, like making Excel talk to Word or PowerPoint
  • How to save specific sheets as PDF files
  • Running events like opening a workbook, printing, or changing the color of a range of data
  • How to add external links and comments
  • How to create submission forms and add buttons, fields, and other ways to “dress up” your forms

With these skills, you’ll be fully prepared to create the invoicing tool. I dare say it’ll be fun, too.

Each project includes-step-by step directions so you’re never lost. Simply follow me and you can’t go wrong.

Also, each project comes with a code-free version of the file for download, so you can play around with the final product and see how it works.

You Can Finally Tweak Files You Find Online

These projects will teach you most of what you’ll ever need to know about Excel VBA.

Complete them, and you’ll be in the 1% of Excel users.

Still, there will no doubt be times where you’ll want to find an existing model instead of creating one from scratch. You’ll head to Google and search for what you need. And because Google has everything, you’ll find it.

But no model perfectly suits your needs out of the box.

That’s okay, because after you’ve taken this course, you’ll have the skills to tweak those models you find on Google.

Whether you create models from scratch or tweak models you get from others, after this course, you’ll be able to free up hours of your time using VBA.

This course is pure gold. I had written several macro’s already before I started, but somehow I felt I lacked a decent foundation. This course has provided this and much more.

After going through all the videos and content I feel much more confident.

Leila teaches like no other, explaining concepts in a way a five year old can understand, while still taking her audience seriously. The hands-on projects are really valuable and give great insights in how to use the content from previous lessons in real-world applications and solutions.

It is ridiculous you even get a 270 page book with the course, including all the code and explanations. I printed it and have used it as a reference guide while writing VBA. The video’s are excellent and professional. Great sound and image quality, combined with some technical features, such as adjusting the speed of the video’s so you can go faster or slower. And, which is quite important, you can ask your questions which will always be answered.

Concluding, I can’t recommend this course enough. Just buy it. No, buy ten and give them to your friends birthdays.

Benjamin

Here’s Your Learning Journey

You can view the detailed curriculum below. Click on “See a full outline” button below to expand the lecture list.

See anything that jumps out? Which lesson do you think you’d begin with?

Excel VBA and macros course cover

Unlock Excel VBA & Excel Macros

Automate ANYTHING you need done in Excel with VBA and Excel macros. Go from Beginner to VBA Expert and design automations with confidence.

This course includes:

Over 22 hours of video content

Downloadable Workbooks and Templates

3 Complete VBA Projects for real-life application

Exercises & Quizzes to test your skills

LIFETIME Access so you never feel rushed

Comment sections to ask questions and get answers from our friendly teaching assistants

CPD Accredited Certificate of Completion

English Closed Captions

Bonus VBA Code Book (over 270 pages) covering more than 50 real projects

Bonus Even More Real-world Projects recently added

Section 1: Introduction & Scope

Course Structure & Content
Important Compatibility & Setup Information
Course Resources: Download Course Project Files
Course Expectations
Course Outline for Quick Reference
Quick Check-in

Section 2: Your First Excel Macro

Overview: Macros & Visual Basic Editor (VBE)
Steps to Your First Macro Recording
Visual Basic Editor: What You Need to Know
Project: Dynamic Selection (Special Cells) – Perfect for Flexible Macros
Project: Copy (Consolidate) Data – Absolute versus Relative Macro Recording
7 Ways to Run Macros / VBA code (incl. creative & modern buttons)
OFFICE 365 Update: Change from Comments to Notes
Activity: Record a Macro that Deletes all Notes/Comments
What’s the Difference Between Macros and VBA?
Quiz: Test Your Knowledge on Macros

Section 3: The Object Model

Overview: VBA Object Model (What you need to become an expert in VBA)
VBA’s Code Reference Object Library
VB Color Guidelines & Keyboard Shortcuts
Excel VBA Object Model
Object Properties
Object Methods
How to Find the Object, Property & Method
Conclusion: Key Takeaways & Message from Me
Test Your Knowledge about the Object Model

Section 4: Referencing Ranges, Worksheets & Workbooks with VBA

Overview: Referencing Ranges, Worksheets & Workbooks
Referring to Ranges & Writing to Cells in VBA
Most Useful Range Properties & Methods
4 Methods to Find the Last Row of your Range
Copying & resizing a variably sized range
Properly Referencing Worksheets
Properly Referencing Workbooks
Activity: Save a Hardcoded copy of Workbook
Project: Save Hard-coded Copy & Macro-free version of Workbook
Conclusion: Key Takeaways for Referencing Ranges

Section 5: Working with Variables

Overview: Role of Assignment & Variables
Data Types for Better Performance
Declaring Variables, Arrays & Constants (Role of Option Explicit)
Using Object Variables (Set statement)
Scoping Variables
Activity: Revisit Hard-coded Workbook Project & Use Variable Assignment
Test Your Knowledge on Variables and data types
Key Takeaways for Working with Variables

Section 6: Looping through Collections & Making Decisions

Overview: Why Collections are a VBA Essential
With & End With for Easier Code Writing
For Each to Loop Through Collections (sheets, ranges etc.) in one go
IF Then (Else, ElseIF) for Conditional Outcomes
Select Case as Alternative for Many IF Statements
Goto Statement to Change Program Flow
Activity: Get the Number of Formulas on the worksheet
Project: Get the Number of Formulas on the Worksheet
Bonus: Unhide All Sheets in One Go
Key Takeaways for Collections & Decision Making in VBA

Section 7: Useful Built-in Functions

Overview: VBA versus Worksheet Functions
Most Useful VBA Functions
Message Box (also with Yes, No buttons)
Input Box (VBA InputBox Function)
Input Box that can Select Ranges (Excel InputBox Method)
Activity: Show Top 3 Values in a Message Box Based on Range Selected
Project: Show Top 3 Values in a Message box based on Range Selected
Key Takeaways Built-in Functions

Section 8: Debugging, Error Handling & Procedure Scope

Overview: Debugging, Handling Errors & Procedure Scope
Debugging Options: Watch, Locals, Immediate Windows & More
Error Handling: Different Methods
Faster Code by Suppressing Pop-ups & Flickering Screen
Procedure Scope & Running one Sub from Another
Passing Arguments to Sub Procedures (By Ref, By Val)
Activity: Get the Total Number of Formulas (or Comments) Used in a Workbook
Project: Get the Total Number of Formulas (or Comments) Used in a Workbook
Key Takeaways Debugging, Error Handling & Course Map Status

Section 9: Main Project #1: Create a Tool to Automate Table of Contents

Project overview: Table of Contents (TOC) with one click
TOC Project: The Basics
TOC Project: Adding Hyperlinks
TOC Project: Testing the VBA Code
TOC Project: Adding Error Handling & More Checks
TOC Project: Adding to Personal Macro Workbook (Make it Available to all Files)
First Milestone Completed!

Section 10: Looping in VBA (controlling the flow of code)

Section Overview: Looping in VBA
For Next Counter Loops (Simple Example)
For Next Nested Loop (Loop through Text & Cells)
For Next Reverse Loop (Delete Filtered/Hidden Rows)
Do Until & Do While Loop
Practical Example of Do Loop (with Inputbox)
Find Method for Quicker Lookup Results
Find Method with Do Loop – Multiple Matches
Add a Timer to Test & Speech to Inform
Activity: Document all Comments in Workbook in a Sheet
Project: Document all Comments in Workbook in a Sheet
Useful VBA Statements & Key takeaways for Looping in VBA

Section 11: Working with Arrays

Overview: Working with Arrays in VBA
One Dimensional Arrays (and transferring back to sheet)
Dynamic Arrays (size adjusts depending on a condition)
Preserving Dynamic Arrays (adding more elements to the existing array)
Two Dimensional Arrays
Variant Arrays: Quick Method to Write to Cells
Activity: Create a New Worksheet per Company with Specific Information
Project: Create a New Worksheet per Company with Specific Information
Key Takeaways Arrays

Section 12: Working with Files, Folders & Text Files

Overview: Working with Folders & Files
DIR Function: Check if Files or Folders Exist
GetOpenFileName Method: User Selects a File
FileDialog Property: Loop Inside a Folder
Create CSV File from Data in Excel
Printing & Writing to Text Files for More Control
Activity: Export Data to Text file (fix Delimiter to Semicolon)
Project: Export Data to Text file (fix Delimiter to Semicolon)
Key Takeaways Files & Folders

Section 13: Excel Tables, Formulas & Pivot Tables

Overview: (Pivot) Tables & Formulas
Using Excel Formulas in VBA
Excel Tables: Use the Right Syntax
Pivot Tables & VBA: What you Need to Know
Activity: Update Existing Formulas with VBA by Adding IFERROR
Project: Update Existing Formulas with VBA by Adding IFERROR
Key Takeaways (Pivot) Tables & Formula

Section 14: Main Project #2: Regional Reporting Tool

What You’ll Learn (& Should be Aware of..)
Project Overview: Regional Sales Reporting Tool
Importing Data from Multiple Files using MultiSelect
Setting up a Template as the Basis for Different Reports
Exporting Reports as Excel files (Pivot Table & Hard Coded Reports)
Fine-tuning Report Export Procedure (Double-check if user wants to overwrite)
Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon)
Track the List of Tasks Completed with VBA
Final Touches & Creating Interface to Hide Specific Tabs with a Password
Key Takeaways & Tips for VBA based Excel Tools
Second Milestone Completed!

Section 15: Interacting with Other Applications (Word, PowerPoint etc.)

Overview & Important Concepts when Interacting with Other Applications
Project PDF: Save Specific Sheets as a PDF File
Project Email: Automatically Create Personalized Emails with Attachments
Project Microsoft Word: Create Personalized Letters in Word from Excel
Project Microsoft PowerPoint: Export Excel Sheets to PowerPoint Presentation
Key Takeaways when Working with other Applications

Section 16: Worksheet and Workbook Events

Overview & What are Event Procedures?
Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close)
Worksheet Selection Change: Dynamic Font Color of Selected Range
Refresh PivotTables Automatically & Concept of Range Intersection
Resetting a Dependent Drop-down when the first Drop-down is Changed
Activity: Link Page Header to Cell Value (BeforePrint Event)
Project: Link Page Header to Cell Value (BeforePrint Event)
2 Useful Tips when Working with Events & Key Takeaways

Section 17: Working with Userforms & ActiveX Controls

Overview: UserForms & ActiveX Controls
ActiveX Controls: What you Need to Know
ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings
ActiveX to Show and Hide Help
ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks)
ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting)
UserForm Basics: What You Need to Get Started
UserForm for Data Entry (Input & Check Boxes)
Practical UserForm to Document External Links & Comments (Combo Box & Option button)
Bonus: ListBox to Print Multiple Pages in ONE Go
UserForm Checklist & Course Map Status

Section 18: Main Project #3: Invoice Generation Tool

Tool Overview: What You Will Learn
Setting up an Input UserForm to Collect Master Data
Working with Multi-Column ListBoxes
Edit Master Data with UserForm
Searchable ListBox (with Selection Change event)
Enhanced Searchable ListBox: Write Selection back to Excel Table
MultiPage UserForm to Create Invoices & Email (Setup)
Export PDF & Excel Workbook for Each Invoice based on ListBox Selection
Create Email in Outlook & Attach PDF Invoice
Final Updates & Debugging
Last Milestone Completed!

Section 19: Creating Customized Functions / Formulas

Section Overview: Function Procedures
Setting up a Simple Function (including Optional Arguments)
Function to Calculate Age (Result in Years & Months)
Functions that Split Text and Numbers from Cell Value
Using Functions in Sub Procedures
Activity: Function That Sums based on Cell Color
Project: Function That Sums based on Cell Color
Key Takeaways Function Procedures in VBA & Course Map Status

Section 20: Working with Charts

The Chart Object Library & Section Overview
Create and Modify a Chart with VBA
Animated Charts: Different Methods
Show Charts inside UserForms
Key Takeaways: Charts

Section 21: BONUS! CODE BOOK

DOWNLOAD VBA Code Book

Section 22: Summary & Final Words

Your Next Steps & more Learning

You’ll Also Get These Bonuses

In addition to the curriculum and downloadable files, templates and projects, you’ll also get these bonuses to help you tackle any VBA challenge you’ll come across:

Bonus 1: VBA Code Book

Inside you’ll find the code for all the projects we cover in one place.

That’s VBA code for over 50 real-case projects and 50 more examples on how to write proper code.

For example, let’s say you need to find the last row or next blank row. “What was the code for doing that?”, you ask yourself.

Jump to Section 4.3 and you’ll have your answer. Simply copy and paste the line to your VBA editor.

VBA Code book for this Comprehensive Excel VBA and Macro Training
Excel VBA Code Book

This bonus will be available 30 days after enrolling.

Bonus 2: Even More Downloadable Projects To Inspire You

You’ll get EVEN MORE real-world projects.

We recently added three more completed projects for you to learn from and be inspired by:

  • Restrict editing & working with protected sheets
  • Populate and consolidate Bill of Materials
  • Web scraping project

These projects will be available 30 days after enrolling.

⏫ Beam Me Up, Scotty!
Jump into the Topic You Need – Fast

I told you I was a Star Trek fan…

Watching the show, I was always in awe of the transporter technology. It blew my mind how they could spot a nearby planet, then instantly transport their team to that exact location.

I want your experience inside our Excel VBA Macros Mastery course to be just as instantaneous.

Thanks to a new tool we created here in our XelPlus “laboratory.” Now, when you want to find a topic, you can do so instantly. We’ve gone through every second of every lesson and pulled out the key words & topics.

Then, we created an interactive agenda which allows you to quickly locate exactly what you’re looking for. Once you find your topic, it’s simply a matter of saying “Beam me up!” (not actually required to say this).

Click the link and you’ll instantly be transported to the correct lesson and timestamp.

Search tool for this Excel VBA Macros Mastery Course
Easily find a specific topic in the course

No more wasting hours searching. Find what you need, then get back to work.

🆕 Earn CPD Credits

I’m excited to announce this course is CPD certified. The Continuing Professional Development is a top global accreditation, trusted by companies and industries worldwide.

When you complete this course, you’ll get a special certificate with the official CPD stamp. You will earn 22.5 CPD hours with the course.

If CPD credits can help in your career, this is not a course to skip.

XelPlus CPD accreditation
XelPlus CPD Provider No 22369

📃 Get a Certificate of Completion

When you finish this Excel VBA Macros Mastery course, you’ll get a certificate of completion. You can send it to your boss, upload to LinkedIn, or just add it to your own person library of learning achievements.

CPD Accredited Course Certificate from XelPlus

Your Next Steps

Click the button below to get started.

Excel VBA is an extremely valuable skill to put on your resume.

The investment for this course is only $179 (excl. taxes). What would it be worth to you to have this specialized Excel skill in your skillset?

You’ll get:

  • Access to our entire 20-module course (22.5 hours of videos)
  • Lifetime access, so you’re never in a rush to complete a lesson
  • The “Beam Me Up Scotty” topic transporter to quickly find what you need
  • Useful Excel VBA codes you can directly use for your work
  • Tons of VBA files based on solutions my clients needed. They are likely to be useful to you too.
  • A comment section to get your questions answered by our staff (how awesome is that?)
  • Credits for CPD (Continuing Professional Development)
  • English Captions so you can easily follow along each video
  • Quizzes to track how well you understand the concepts
  • Challenges to test your knowledge and give you inspiration
  • Your very own VBA Code-Book for reference and quick fixes
  • More Bonus completed real-world projects to learn from

Click the button below to begin your checkout.

Get Started Now!

Automate Anything You Need Done In Excel.

You Don’t Need A Programming Background To Learn VBA

No, you do not need to have experience with computer programming to take this course. 🤓

In fact, if you’ve been interested in getting into programming, this is a good place to start.

Don’t let the programming nature of this course scare you. If you can use Excel, you already have the type of brain that can learn VBA.

Very professionell approach and very well spoken and detailed information outlined in a good way. I`m a big fan from what I have seen so far. If you are going to grasp the “thinking” and learn the logic behind excel, VBA and different concept from a course: Leilas courses is the one!

Niclas Johansson

Try It For 14 Days

Don’t commit to buying this course now. Instead, take it for a test drive.

You have 14 days to try out the lessons, do the exercises, and ask questions. If after 14 days you decide the course isn’t for you, click the link to get a refund. It’s fast and no questions are asked.

Who Is This Course For?

This is best for people in three groups.

Brand New to VBA

You’re starting from scratch. You don’t know a loop from a macro. You want to learn VBA, but you need baby steps.

Some Experience With VBA

You’ve dipped your toe into VBA. Nothing too crazy. You know there are better methods to what you’ve been doing.

VBA Power User

You use VBA every day. Given your foundation, why not get the most mileage out of your experience? You’ll pick up new tools and methods faster than beginners.

In all these scenarios, this course is for you.

If nothing else, take advantage of our 14-day guarantee. If you don’t pick up new tricks, ask for a refund.

Whether you’re beginner, intermediate, or advanced – you’ll find lessons tailored to your specific needs inside this course.

You Can Be Working On Your Excel VBA Challenge in Just 15 Minutes

As you read this page, Excel users across the world are logged into our course area, watching lessons, and completing challenges.

Join them! The doors are open, and you’re invited to come inside.

It’s a warm, friendly environment. And even though our students come from all different backgrounds, they have one thing in common: They’re determined to get better at Excel.

Click the button below, and we’ll see you inside.

Very clear. Not new to VBA and I thought I would be able to breeze through the first few videos, but had to stop and replay as there was so much I didn’t know.

William Wicks

Frequently Asked Questions

When does the course start and finish?

You’ll take this Excel VBA Macros Mastery course in your own time. It is a completely self-paced online course – so you decide when you start and when you finish.

How long do I have access to the course?

How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like – across any and all devices you own.

What if I am unhappy with the course?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us at info@xelplus.com in the first 14 days and we will give you a full refund.

What if I have questions about the lessons? Can I get those answered?

Yes! Most online courses leave you on your own, but not here at XelPlus.

We have a team of helpful teaching assistants (TA’s) ready to answer your questions about each lesson. Below each lesson, you’ll find a comment section where you can ask a question about the topic. Our TA’s will chime in and do their best to help you.

What are the course requirements?

You currently use Excel – know it well and want to improve your skills. If you consider yourself a basic Excel user, I suggest you enroll in our Excel Essentials course first, before learning VBA.

Which version of Excel do I need?

Excel on Windows. This Excel VBA Macros Mastery course was recorded on Excel 2016 but the techniques work with any version of Excel.

Does the course cover web-scraping?

No. We don’t cover web-scraping as I believe there are better tools intended for this (Power Automate, Sheets, Power Query), but we have included a web scraping project as a bonus.

Do you cover VBA in other Office applications?

The course covers different ways you can connect with VBA from Excel to Office applications such as Word, PowerPoint, and Outlook. We do a cool project where we automatically generate Outlook emails and attach PDF files directly from Excel!

Who can I contact if I have questions not addressed?

You can contact us at info@xelplus.com.


Save with a Bundle!

You’d like to improve in more than one aspect? Pick our Black Belt package.

This Excel VBA course is a part of our Black Belt Package. Learn anytime that suits your schedule.

Excel VBA and macros course cover

Unlock Excel VBA & Excel Macros

$179.00

Automate ANYTHING you need done in Excel with VBA and Excel macros. Go from Beginner to VBA Expert and design automations with confidence.

Excel Black Belt course cover

Black Belt Excel Package

$679
$1,131
Save $452 with a bundle!

Our Black Belt Package is your gateway to becoming an Excel Grand Master. With this package you get exclusive access to courses not available as stand-alone. Our step-by-step guidance makes learning easy, so you can say goodbye to confusion and frustration and hello to mastery.

Courses included

This means you get

  • Over 100 hours of video content (CPD Credits)
  • Certificate of Completion for individual courses
  • 600+ Workbooks and Templates
  • 200+ Challenges & Quizzes to test your skills
  • LIFETIME Access so you never feel rushed
  • Comment sections to ask questions and get answers from our friendly teaching assistants