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!

Course Content

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.

Excel VBA Course

About Course

What Will You Learn?

Course Content

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.

Macro File Formats

Developer Tab And Macro Security

Modules, Macros And Relative References

A First Look At Buttons

Charting Driven By Macros

Why Macros Can Go Wrong And What To Do About It

Handling Errors And Sheet Issues

Dynamic Charting: Part 1

Dynamic Charting: Part 2

Dynamic Charting: Part 3

End With

Controlling Autofilters

Controlling Formulas

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.

5 Levels Of Looping Part 1

5 Levels Of Looping Part 2

5 Levels Of Looping Part 3

5 Levels Of Looping Part 4

5 Levels Of Looping Part 5

VBA Alternative: Gathering Data With Power Query

Introduction

Creating An Input Sheet Template

Mass Producing Input Sheets 1: Set The Scene

Mass Producing Input Sheets 2: Worksheet Variables

Mass Producing Input Sheets 3: Autofilter Revisited And Paste special

Mass Producing Input Sheets 4: Manipulating Filter Criteria

Mass Producing Input Sheets 5 Creating A Unique List To Prepare For Looping

Mass Producing Input Sheets 6 Instantly Creating 25 Unique Input Excel Files

Starting The New Process

Open Up One File And Copy Data

Introduction To The Do While Loop

Looping Through All Files In A Folder And Copying Data

Setting Up New Data Before We Bring Into Our Long Boring List

Looking Up Latest Data Manually Into Our Long Boring List

Looking Up Latest Data Automatically Into Our Long Boring List

Putting It All Together

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).

Why PowerPoint?

Introduction to the Object Model

Programming in PowerPoint 1: Basics

Programming in PowerPoint 1: Shapes

Programming in PowerPoint 1: Tables

Opening PowerPoint from Excel

Pasting an Excel range as an Image in PowerPoint

Translating Excel data into a table in PowerPoint 1

Translating Excel data into a table in PowerPoint 2: Multiple Slides

Drawing Shapes in Excel

Translating Excel data into Shapes in PowerPoint

Introduction and Creating an MS Word Invoice from Excel

Gathering Data from MS Word docs in to Excel (Change Control Form)

Purchase order system: part 1 – Excel to word

Purchase order system: part 2 – The word template

Purchase order system: part 3 – Save & print button

Purchase order system: part 4 – Excel to word

Resource Analysis: Good practice for managing data

Dynamic Charts

Charting Actual vs Forecast

Segmenting for deeper MI

Meaningful Resource Analysis

Interesting MI Aesthetics, automating folders and PDF files

Automate the creation of a PowerPoint slide deck

Combining PowerPoint with Information Gathering

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.

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).