VBA: Task Automation

Course 1: Stop repeating recurring tasks. Learn the skills to turn your manual Excel tasks into the push of a button. Build a solid foundation in both coding basics and Excel specific objects. You won't regret learning how to program.

Buy $149.00

Course curriculum

1. Course interaction
2. Introduction
3. 01 - Before getting started
1. Pre-course survey
1. Supplemental slides
2. Supplemental files
1. Chapter preview
2. 02 - Developer tab
3. 03 - Style guide (Part 1)
4. 04 - Style guide (Part 2)
5. 05 - Built-in members (VBA library)
1. Chapter preview
2. 06 - Insert (menu) | Procedure (command)
3. 07 - Insert Sub
4. 08 - Value types and IntelliSense
5. 09 - Object ("reference") types and Object Browser
1. Chapter preview
2. 10 - Macros dialog box
3. 11 - Macro recorder
4. 12 - Macro recorder explained
5. 13 - Exercise 1
6. 14 - Immediate Window
1. Chapter preview
2. 15 - Qualify Range objects
3. 16 - A1 notation and Range
4. 17 - Index notation and Cells
5. 18 - Mix and match A1 and Index notation
6. 19 - Range properties
7. 20 - More range properties
8. 21 - Exercise 2
9. 22 - Inspect Range
10. 23 - Debugging code
1. Chapter preview
2. 24 - Create from scratch
3. 25 - Mirror macro introduction
4. 26 - For Next loop
5. 27 - Sheet reference
6. 28 - For Next loop on a Range
7. 29 - Exercise 3
8. 30 - Mirror macro (Part 1)
9. 31 - Mirror macro (Part 2)
10. 32 - Mirror macro (Part 3)
11. 33 - Screen updating and function scope
1. Chapter preview
2. 34 - If/then
3. 35 - Select case
4. 36 - Exercise 4
1. Post-course survey

About this course

48 lessons
3.5+ hours of high-quality video
Supplemental files and slides

VBA: Task Automation

Course curriculum

Introduction

Pre-course Survey

Materials

Visual Basic Editor (VBE)

Procedures and Variables

Macros

Range Object

Create a Macro from Scratch

Control Flow Statements

Post-course Survey

About this course