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