Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Master Microsoft Excel Macros and VBA with 6 Simple Projects
Course Introduction and Overview
Welcome to the Course (4:06)
Something to THINK About and SHARE (2:00)
Understanding the Why and How Behind Excel Macros (3:17)
Download Exercise Files
Download this ZIP file
Project #1: Using Excel's Macro Recorder Tool
Introduction to Project #1 - Inserting and Formatting Text (1:39)
Project #1 - Start Recording! (7:12)
Project #1 - Running a Macro with a Button (2:11)
Project #1 - Opps! I Need to Edit My Macro (4:02)
Practical Uses of Excel Macros (2:16)
Project #1 - Quiz - Test Your Knowledge on Using the Macro Recorder
Project #1 - Exercise - Try it Yourself and Practice
Excel VBA Concepts
Excel VBA Concepts (0:30)
The Visual Basic Editor (2:06)
Excel VBA Modules (1:14)
Creating Excel VBA Procedures (2:04)
Understanding Excel VBA Variables (5:15)
Working Excel VBA Loops to repeat blocks of code (4:10)
Building Logic with an IF Statement (2:38)
VBA Concepts - Quiz - Test Your Knowledge on VBA Programming Concepts
Project #2: Moving Beyond the Basics and Into VBA
Introduction to Project #2 - Interacting with the User (2:41)
Project #2 - Breaking Down the VBA Code (3:04)
Project #2 - Prompting the User for Information (5:33)
Project #2: Building Logic in Your Macros (4:55)
Project #2 - Alerting the User of Errors (7:03)
Other Practical Uses of Message Boxes and Input Boxes (3:17)
Project #2 - Quiz - Test Your Knowledge on Editing Your Macros
Project #2 - Exercise - Try it Yourself and Practice
Project #3: Preparing and cleaning up Data with a little VBA
Introduction to Project #3 - Cleaning Up and Formatting Multiple Worksheets (2:58)
Project #3 - Using the Macro Recorder to Lay the Foundation (1:53)
Project #3: Preparing to use the Macro Recorder (2:27)
Project #3 - Inserting the Headers (2:39)
Project #3 - Formatting the Headers (5:06)
Project #3 - Putting it all Together with alittle VBA Magic (9:52)
Project #3 - Quiz - Test Your Knowledge on VBA
Project #3 - Exercise - Try it Yourself and Practice
Project #4: Using VBA to automate Excel Formulas
Introduction to Project #4 - Automate Microsoft Excel Formulas with VBA (2:22)
Project #4: Automate the SUM Function through Code (9:28)
Project #4: Loop the SUM Function over Multiple Worksheets (5:55)
Project #4 - Quiz - Test Your Knowledge Automating a Function with VBA
Project #4 - Exercise - Try it Yourself and Practice
Project #5: Bringing it all togther and create a weekly report
Introduction to Project #5 - Creating a Final Report (2:55)
Project 5: Putting it all together to create a Final Report (9:55)
Project #5 - Quiz - Test Your Knowledge of Creating the Final Report
Project #5 - Exercise - Try it Yourself and Practice
Bonus Project #6: Working with VBA Forms
Introduction to Bonus Project #6 - Working with Excel VBA Forms (3:14)
Bonus Project #6: Creating an Excel VBA Form (2:47)
Bonus Project #6: Adding Controls to the Form (2:41)
Bonus Project #6: Changing Control and Form Properties (4:54)
Bonus Project #6: Adding VBA Code to the Initialize Event of the Form (7:24)
Project 6: Adding VBA Code to the ComboBox Change Event (4:18)
Project #6: Adding VBA Code to the Add Worksheet Button Click Event (6:13)
Project #6: Adding VBA Code to the Create Report Button Click Event (2:02)
Bonus Project #6: Showing the Form (3:26)
Bonus Project #6 - Quiz - Test Your Knowledge on Creating Excel VBA Forms
Bonus Project #6 - Exercise - Try it Yourself and Practice
Course Wrap Up
Congratulations! You're an Excel Macro/VBA Master (1:02)
BONUS! - Special Offer! Any of my courses for only $10
Project 5: Putting it all together to create a Final Report
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock