This beginner-friendly course teaches you how to use macros to automate Excel and get more out of the spreadsheet skills you already have. No previous knowledge of macros or VBA is needed, just a willingness to work smarter and more efficiently.
By the end of the course, you'll have a solid foundation in Visual Basic for Applications and a practical understanding of how to apply it to real spreadsheet tasks. It's a straightforward, hands-on introduction to one of Excel's most powerful and time-saving features.
What You Will Learn
- Write and run basic macros to automate repetitive tasks
- Use macros to format worksheets quickly and consistently
- Build interactive worksheets using VBA elements
- Automate tasks across multiple worksheets at once
- Perform calculations using VBA to take your spreadsheet functionality further
Course Outline
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
Lesson 8: Creating & Naming Objects
-
Naming conventions
-
Housekeeping
Lesson 9: Navigation / Selection Techniques
-
Formula R1C1 Reference Style
-
Offsets
-
Range Names
Lesson 10: Logic Statements
Lesson 11: Looping Statements
Lesson 12: Interactive Code
-
Input boxes
-
Message boxes
Lesson 13: Error Handlers
-
Preventing fatal errors and crashes
