Course Outline
1 - GETTING STARTED
- Recording a Macro
- Saving a Macro-Enabled Workbook
- Running a Macro
- Understanding Macro Security
- Editing a Macro in the Visual Basic Editor
- Understanding Modules
- Understanding Procedures
2 - UNDERSTANDING OBJECTS
- Understanding Objects
- Understanding Excel Object Hierarchy
- Understanding Collections
- Working with Properties
- Using the With Statement
- Working with Methods
3 - WORKING WITH WORKSHEETS
- Working with Worksheets
- Worksheet’s methods
- Worksheet’s properties
4 - USING EXPRESSIONS, VARIABLES AND CONTROL STRUCTURES
- Understanding Expressions and Statements
- Declaring Variables
- Understanding Data Types
- Understanding Control-of-Flow Structures
- Using the If...End If Decision Structures
- Using the Select Case...End Select Structure
- Using the For...To...Next Structure
- Using the Do...Loop Structure
5 - WORKING WITH INTERACTIVE MACROS
- The MsgBox function
- The InputBox function
Target Audience
This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.