VBA for Beginners

Overview

VBA, or Visual Basic for Applications, is like Excel on steroids. As an advanced feature, it can seem intimidating at first. But with just a little VBA knowledge you'll be able to automate tasks in Excel and turbocharge your data handling capabilities. We'll take you from beginner to advanced user in just a few hours on this online video training course.

Most office staff can use Excel to a basic level for data entry, to format cells, even to use a basic PivotTable. But few make it to the next level, to be able to build models, conduct scenario analyses, apply checks to flag errors, create a dashboard or format to a client-ready standard.

Inspired by our best-selling, award-winning, accredited course - Microsoft Excel - we've produced this short course designed for individuals and professionals who are new to VBA and seek practical ways to automate their most frequent tasks in Microsoft Excel.

Pre-requisites

  • PC or Mac with a full version of Microsoft Excel (any version from 2003 to 2013 or Microsoft 365).
  • Not a requirement but a benefit to have some work-related projects to which you can readily apply what you learn.

Relevant audiences

  • Individuals and professionals who are new to VBA and are seeking practical ways to automate their most frequent Microsoft Excel tasks.
  • Accountants, bookkeeppers, teachers, salespeople, managers, graduates. The list just doesn't end with Excel.

Learning Outcomes

  • Automate your most frequent tasks and operations.
  • Define and manage variables, set up subroutines, and create functions.
  • Learn practical methods for using macro errors to improve your VBA code.
  • Learn about the PivotTable object and basic approaches to utilizing it.

Syllabus

Section 1: Introduction

  • Unit 1.1 - The VBA Course and the Environment

Section 2: VBA and Macros

  • Unit 2.1 - VBA as a Language
  • Unit 2.2 - Introducing Macros

Section 3: Functions

  • Unit 3.1 - Introducing Functions

Section 4: Common Keys to VBA

  • Unit 4.1 - Working with Objects

Section 5: Closure

  • Unit 5.1 - Conclusion