About This Course

You will learn VBA and Macros with my unique experienced-based approach focusing on a handful of key themes. You will be effortlessly programming in a shockingly quick time frame. 

Our teaching is so efficient that we don’t even allow you to learn unnecessary and 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!

During this course we will cover the following topics:

  • Why VBA and Macros
  • Controlling Cells, Ranges, Copy and Paste
  • Controlling fonts and colouring cells
  • Building Logic with IF and Select Case
  • Introduction to Automation with Looping
  • Constants and Variables
  • The most important line in VBA you need to know
  • Putting together everything so far to demonstrate Automation

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. This course feeds into our more extensive ‘Excel VBA For Professionals’ Course.

Our Promise to You

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

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 VBA and Macros.

Course Curriculum

Section 1 - Introduction To VBA And Macros - Module 1 of VBA for Professionals
Module 1 Introduction 00:00:00
Cells And Ranges 00:00:00
Copy And Paste 00:00:00
Controlling Fonts And Colouring Cells 00:00:00
Multiple Lines, Clearing And Column Widths 00:00:00
Building Logic With If 00:00:00
Building Logic With Select Case 00:00:00
The Importance Of Loops 00:00:00
Introduction To Automation 00:00:00
Loops And Selecting Ranges 00:00:00
Manoeuvring And Macros 00:00:00
Constants And Variables 00:00:00
The Most Important Line In VBA You Need To Know 00:00:00
Putting Together Everything So Far To Demonstrate Automation 00:00:00

Course Reviews

5

5
1 ratings
  1. Well narrated, very enlightening

    5

    Found this truly informative. Nice speed, enough to get you going and as was stated in the last segment, ‘My head was spinning” with the possible uses.

    K. Wolf

Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel