Play all

Start

Introduction

VBA Basics

Getting Started

Example of Object-Oriented Programming Using Excel

Why VBA?

VBA vs Macros

Adding the Developer Tab to the Ribbon

Filling in the Record Macro Dialog

Recording Macros

Testing Macros

Exploring VBE

Viewing VBE Options and Reviewing Macro Code

Editing Macro Code and Using Project Explorer and Properties

Adding Useful Commands to the Toolbar

Saving Macro-Enabled Workbooks

Testing Edited Macros

Reviewing and Changing Security Settings

VBA Basics Recap

Excel Object Model Hierarchy and Collections

Referencing Objects and Simplifying Object References

Introduction to Modules and Procedures

Understanding Modules

Understanding Procedures

Recording More Macros

Creating Sub-Procedures from the Menu in VBE

Reviewing New Code and Editing Existing Code

Creating Calling Procedures

Testing Calling Procedures

Creating Event Procedures

Creating Function Procedures

Reviewing and Testing Function Procedures

Getting Context Sensitive Help in VBE

Modules and Procedures Recap

Conclusion

Description:

Dive into a comprehensive beginner tutorial on Excel 2021 VBA, designed for Business Analysts, Data Scientists, and Excel users seeking to automate tasks and expand their capabilities. Learn the fundamentals of Visual Basic for Applications, starting with an overview of its advantages over traditional macro recording. Record and edit macros, explore the Visual Basic editor environment, and understand key terminology. Discover the Excel Object Model, collections, and object referencing techniques. Master different types of procedures, their scope, and working with methods. Delve into VBA language elements, including variables, data types, and intrinsic functions. Explore control-of-flow structures, create forms, and program controls. Learn to create Pivot Tables programmatically and handle code errors through debugging. By the end of this 1-hour 48-minute tutorial, gain the skills to write custom VBA code, modify recorded macros, and enhance your daily Excel tasks with increased efficiency. Read more

Excel 2021 VBA Beginner Tutorial

Learnit Training

Add to list

#Business #Business Software #Microsoft Office 365 #VBA #Programming #Data Science #Data Analysis #Spreadsheets #Macros

0:00 / 0:00