❗The content presented here is sourced directly from Youtube platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [July 18th, 2023]
This Excel 2021 VBA Full Course Tutorial (6+ Hours) is designed for Business Analysts, Data Scientists, and everyone in between looking to write their own rulebook on what’s possible in Excel. Visual Basic for Applications (VBA) is the programming language for Excel and other Microsoft Office programs. VBA is used to automate repetitive processes and frequent actions. Even more, it can be used to build tools that otherwise don’t exist in Excel.
This 4-part series starts with an overview of VBA and its advantages over recording macros in the Excel interface. Participants will record a macro, which produces VBA code in the background, and learn the Visual Basic editor environment before editing the code generated by the macro. Throughout this section, participants will learn some key terminology that will help them along the way. The first lesson will end with saving a macro-enabled workbook and modifying trust center settings pertaining to macro security.
The second lesson will cover the Excel Object Model, collections, and how to reference objects in VBA code. Participants will learn about different types of procedures, creating procedures, learning the scope of procedures, and working with methods. They will also learn how to get VBA context-specific help from within the editor.
The third lesson will focus on language elements. Participants will learn about variables, their scope, and how to declare them. They will also gain an understanding of VBA data types, intrinsic functions, and the With-End With structure and how it provides efficiency in their code. They will also learn to create message boxes and input boxes in this lesson, as well as gain an understanding of object variables.
The fourth lesson will teach participants how to control program flow through supported control-of-flow structures. This lesson begins with an overview of structures and Boolean expressions. Participants will then learn how to utilize conditional branching, with the lesson ending with looping constructs. They will also learn about creating forms, including properties, programming, controls, events, and methods. They will ultimately launch a form with code.
The fifth lesson will take participants through the steps necessary to create a Pivot Table programmatically in VBA. The course will end with debugging and how to write error-handling code. By the end of this training series, participants will be equipped to write their own VBA code, modify macros they’ve recorded, and create efficiency in their daily tasks with VBA.
Exercise Files, Manuals, and other resources are available at https://learnitanytime.com/p/exercise and https://bit.ly/30xZb59.
(C) 2023 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.
