Categories Microsoft Excel

Excel VBA Course

Course Curriculum

INTRODUCTION TO VBA & MACROS
You will learn VBA and Macros with my unique experienced based approach focusing on a handful of key themes. You will be effortless programming in a shockingly quick time frame. Our approach is so efficient that we don’t even allow you to learn unnecessary & confusing jargon which all other courses teach you first, so you get to experience some quick wins and find out exactly how amazing VBA/Macros can be!

  • 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
This module continues the accelerated learning with a focus on introducing you to Macros and the best way to take advantage of Macros in your work.

GOING DEEPER INTO LOOPING
We take a more in depth look at the five levels of looping, This will make you very confident about your automation skills. At the end we look at the alternative of VBA data gathering with Power Query which can save a lot of time over VBA but still has its limitations.

AUTO-CREATE EXCEL FILES & TEMPLATES
Your VBA skills will dramatically improve here as I start to make you an automation expert and all while you learn one of the most important topics of gathering information from people. A skill that will make you invaluable to your bosses and teams if you get it right. Not only do you get technical skills, but I share best practices from a professional perspective when it comes to getting information, insight from my years of working, making mistakes and learning the hard way. It will make all the difference

AUTOMATE DATA COLLATION & ANALYSIS
Your Automation skills will deepen as we look at some powerful techniques to speed up our work dramatically and we delve even more in to one of the foundations of VBA automation: Loops. By the end of this lesson you will be an expert at automation, and you will be able to confidently speed up your work and since this is one of the most coveted analytical skills, you will be in a position to command a much higher salary.

CONTROLLING POWERPOINT FROM EXCEL
We will learn to programmatically control PowerPoint from Excel. This is a course that is not available anywhere else. It is truly a high value corporate professionals’ domain (Analysts, PMO’s, Project Managers and Management Consultants).

CONTROLLING WORD FROM EXCEL
We cover the best practices for structuring a word document to prepare it for automation. Then we will learn how to mass produce Invoices, how to automate a ‘Change Control’ process (for Project and Programmes) and finally we will be guided by former student Celia Alves on how to create a Purchase Order system entirely within Word and Excel!

THE VBA TOOLS & TEMPLATES VAULT
In this section I share with you some of the best Excel VBA solutions I have built in my career and walk you through them in detail. Carefully chosen, these are templates, reports and solutions that have played a huge role in me earning over 6 figures, so I am giving them to you to learn, steal and call your own.

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
Categories Microsoft Excel

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
Full Excel Course Certification $7 $147Enroll Now