About This Course

If you are regularly producing the same reports, doing the same data analysis and other repetitive work week after week in Excel, then 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 Excel Visual Basic Application or VBA and Macros course on the market purpose-built to teach Excel VBA and Macros skills to corporate professionals including Analysts, Accountants, Controllers, PMO’s, Project Managers, and Management Consultants. 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 Excel VBA and Macros course is changing lives!

Our approach to teaching is firmly rooted in the human psychology of quick wins so we have you programming in the first few minutes. Just like each and every one of our students, you will gain massive confidence in your VBA skills right from the start.

This course will cover:

  • VBA and Macros Introduction
  • Fundamentals of Automation with loops and logic
  • Automating Charts, Filters, and Formulas to speed up your workflow
  • In depth break down of how to use loops by understanding the 5 levels of looping, which will make you very confident about automating your skills

What are the requirements?

  • You will need access to any version of Excel (2007,2010,2013, 2016, 2019, 365)

Who is this course suitable for?

  • Any Analytical professional who spends at least 20% of their time in Excel will greatly benefit from this course. 

Our Promise to You

By the end of this course, you will have learned about Excel VBA.

 30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

 Get started today and learn more about Excel VBA.

Course Curriculum

Section 1 - VBA Fast-track Part Two
Introduction 00:00:00
Macro File Formats 00:00:00
Developer Tab And Macro Security 00:00:00
Modules, Macros And Relative References 00:00:00
A First Look At Buttons 00:00:00
Charting Driven By Macros 00:00:00
Why Macros Can Go Wrong And What To Do About It 00:00:00
Handling Errors And Sheet Issues 00:00:00
Dynamic Charting: Part One 00:00:00
Dynamic Charting: Part Two 00:00:00
Dynamic Charting: Part Three 00:00:00
End With 00:00:00
Controlling Autofilters 00:00:00
Controlling Formulas 00:00:00
Section 2- Automation Part One
Five Levels Of Looping Part One 00:00:00
Five Levels Of Looping Part Two 00:00:00
Five Levels Of Looping Part Three 00:00:00
Five Levels Of Looping Part Four 00:00:00
Five Levels Of Looping Part Five 00:00:00
Section 3 - Automation Part Two
Introduction To Information Gathering 00:00:00
Creating An Input Sheet Template 00:00:00
Mass Producing Input Sheets One: Set The Scene 00:00:00
Mass Producing Input Sheets Two: Worksheet Variables 00:00:00
Mass Producing Input Sheets Three: Autofilter Revisited and Pastespecial 00:00:00
Mass Producing Input Sheets Four: Manipulating Filter Criteria 00:00:00
Mass Producing Input Sheets FourB: Simplifying And Bringing Together 00:00:00
Mass Producing Input Sheets FourC: Creating A Worksheet 00:00:00
Mass Producing Input Sheets Five Creating A Unique List To Prepare For Looping 00:00:00
Mass Producing Input Sheets Six Instantly Creating 25 unique input Excel files 00:00:00
Section 4 - Automation Part Three
Collating Data From Input Sheets One Starting The New Process 00:00:00
Collating Data from Input Sheets Two Open Up One File And Copy Data 00:00:00
Introduction To The DO WHILE LOOP 00:00:00
Collating Data from Input Sheets Three Looping Through All Files In a Folder And Copying Data 00:00:00
Collating Data from Input Sheets Four Setting Up New Data Before We Bring Into Our Long Boring List 00:00:00
Collating Data from Input Sheets Five Looking Up Latest Data MANUALLY Into Our Long Boring List 00:00:00
Collating Data from Input Sheets Six Looking Up Latest Data AUTOMATICALLY Into Our Long Boring List 00:00:00
Collating Data from Input Sheets Seven Putting it all together 00:00:00
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel