Excel VBA Course

About Course

Can you answer, what is VBA in Excel? If yes, you will find our Excel VBA course a perfect starter for the journey towards your destination.

Suppose you regularly produce the same reports, do the same data analysis, and do another repetitive work week after week in Excel. In that case, we will show you how to get off the hamster wheel of repetitive work, so you can focus on adding real value to your company.

This is the only Macros and Excel VBA course on the market purpose-built to teach Excel VBA and Macros skills to corporate professionals, including Analysts, Accountants, Controllers, PMO’s, Project Managers, Management Consultants, And Other Corporate Professionals.

If that includes you, then keep reading and see how this course has changed the lives of our students (Yes, you read that correctly; this Macros and Excel VBA course is changing lives!

What Will I Learn?

  • VBA and Macros Introduction
  • Fundamentals of Automation with loops and logic
  • Automating Charts, Filters, and Formulas to speed up your workflow
  • Automating an entire weekly/monthly reporting process
  • The power of automating PowerPoint and Word

Curriculum

74 Lessons15h

INTRODUCTION TO VBA & MACROS

Cells and Ranges
Copy And Paste
Controlling Fonts And Colouring Cells
Multiple Lines, Clearing And Column Widths
Building Logic With If
Building Logic With Select Case
The Importance Of Loops
Introduction To Automation
Loops And Selecting Ranges
Maneuvering And Macros
Constants And Variables
The Most Important Line In VBA You Need To Know!
Putting Together Everything So Far To Demonstrate Automation

AUTOMATING THE WORKSHEET

GOING DEEPER INTO LOOPING

AUTO-CREATE EXCEL FILES & TEMPLATES

AUTOMATE DATA COLLATION & ANALYSIS

CONTROLLING POWERPOINT FROM EXCEL

CONTROLLING WORD FROM EXCEL

THE VBA TOOLS & TEMPLATES VAULT

Student Success!

Some Of The Companies Our Students Work At

Frequently Asked Questions (FAQs)

Once you have signed up, we will send you an email with a link to access our VBA excel training dashboard; you can access all of our courses from this dashboard. All VBA Excel online courses consist of video lessons that can be viewed on your device of choice, and also, to truly enhance your learning, you will access lots of exercise files relevant to the lessons.
It depends on your level of commitment. Our students have seen incredible results from as little as 30 minutes a day. But remember, the magic is in applying the skills as much as learning them. Our Excel VBA courses are designed with this in mind. On the very practical end, we have students who squeeze in a few minutes here and there on their commute, and some do dedicate 2-3 hour weekend sessions. One of our most successful students, Jayne managed to get up at 4 am to learn! This paid off massively as it landed her a six-figure analyst job in a bank!
Yes, this is quite common since we focus on helping actual corporate employees. Note that for teams, we offer bulk discounts. However, this needs to be done with a corporate credit/debit card. We don’t accept transfers/remittances. Get in touch if you have any specific questions.
Yes, we do; we will dust it off if you need it because it rarely happens! You have 30 days to let us know that the training isn’t right for you and we will happily refund you.
You can either purchase access to one course or all of our courses, which are listed above. We have done in a post-COVID-19 world to keep our prices low to accommodate as many ambitious people from all over the world who are looking to up skill through our high-level Excel VBA courses without the burden of high expense.
We recognize that people prefer to pay in their own currencies, and especially when our main product is a recurring membership to all our courses, you can rest assured knowing that fluctuations in currency won’t affect your financial commitment.
Great question; well, frankly, we make the best Excel VBA courses because all of our trainers have spent 10+ years using these skills in the real world! True knowledge is passed on from people who have been in the trenches, putting in long hours, solving real problems creatively. Our mission is to empower you with the very best of what works and, more importantly, leave out what is unnecessary and thus a waste of your precious time.
Level
Expert
Duration
15h
Subject

Pricing

Lifetime Online Access
$
249
Lifetime
  • Access this course online
  • Including exercise files & supporting material
  • Certificate of completion
  • Email Support for 12 months
  • Download the course