Get started with VBA and macros in this beginner-friendly course that takes you from the basics all the way to writing and editing your own code. You'll build the core skills you need to automate Excel tasks, perform calculations, and work faster and smarter.
Overview
Syllabus
Lesson 1: Macros / VBA
- What are Macros?
- What is VBA?
- How to record macros
- How to run macros
Lesson 2: VBA Editor
- Modules
- Procedures
- Project Explorer
- Toolbars / Options
Lesson 3: Creating / Editing Code
- Create Procedures
- Subs
- Comments
Lesson 4: Invoking Macros
- Hot Keys
- Quick Access Toolbar
- Call Command
Lesson 5: Compiling Code
- Stepping through code
- Reset
- Run
Lesson 6: Variables
- Declarations
- Option Explicit
- Data Types
Lesson 7: Working with The Object Model
- Worksheets
- Ranges: Rows, Columns, Cells
