TeachExcel

Excel Dashboard & VBA Course - Beginner to Expert

Instant Access! - Lifetime Access!

  • NO VBA Experience Required!
  • 200+ Online Videos
  • 200+ Downloadable Excel Resource Files
  • Practical Project-Based Learning
  • 14 VBA Core Sections
  • 14 Practical Assignments
  • 40+ Excel VBA Feature Tutorials
  • 3 Real World Projects
  • Instructor with 10+ Years of Excel VBA Teaching
Excel VBA Macro Course

Original Price $495 >>> Now $99 (usd)

Holiday Sale ENDS SOON

(80% Discount)

Price: $99 (usd)

Introduction > Excel VBA Course Preview

A preview of what's in this course, who it's for, and how it can help you succeed in Excel and VBA


Introduction

First Steps

Working with Cells and Ranges

Assignment 1 - Ranges

Practical Tasks - Ranges

Get & Input Data into the Worksheet

Assignment 2 - Get & Input Data

Working with Worksheets

Assignment 3 - Worksheets

Add Logic and Control to Macros

Assignment 4 - Logic & Control

Variables Introduction

Assignment 5 - Variables Introduction

Popup Windows & User Input

Assignment 6 - Popup Windows & Input

Practical Tasks - Searching, Worksheet Functions & More

Working with Workbooks

Assignment 7 - Workbooks

Loops

Assignment 8 - Loops

Practical Tasks - Tables & Shapes (The Ultimate Guide)

Project: The Task Manager

Practical Tasks - User Input Applications & File Selections

Variables - Unlocking Their Power

Assignment 9 - Variables

Practical Tasks - Debugging Your Macros & VBA

Arrays in VBA - The Power Variable

Assignment 10 - Arrays

Error Handling

Assignment 11 - Error Handling

Automating Macros

Assignment 12 - Automation

Advanced Macro Control & Custom Functions

Assignment 13 - Advanced Macro Control

Practical Tasks - Pivot Tables, Filtering & Sorting

Security in VBA & Excel

Assignment 14 - Security

Practical Tasks - Import, Export & Email Ultimate Guide

Project: Bringing It All Together - Data Import, Visualization, and Export

(Bonus) UserForms - Build a Fully Featured Form for Easy Data Entry