Master Microsoft Excel Macros and VBA with 6 Simple Projects
Kyle Pew, Microsoft Certified Trainer
-
-
Welcome to the Course
4:06 -
Understanding the Why and How Behind Excel Macros
3:17 -
Introduction to Project #1: Inserting and Formatting Text
1:38 -
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 -
Project #1: Practical Uses of Excel Macros
2:16 -
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:14 -
Working with Excel VBA Loops to Repeat Blocks of Code
4:09 -
Building Logic with an IF Statement
2:38 -
Project #2: Intro to 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: Alerting the User of Errors
7:03 -
Project #2: Other Practical Uses of Messages Boxes and Input Boxes
3:17 -
Project #3: Intro to Cleaning and Formatting Data
2:58 -
Project #3: Using the Macro Recorder to Lay the Foundation
1:53 -
Project #3: Preparing to Use to the Macro Recorder
2:27 -
Project #3: Inserting Headers
2:39 -
Project #3: Formatting Headers
5:05 -
Project #3: Putting it All Together with a Little VBA Magic
9:52 -
Project #4: Automate Microsoft Excel Formulas
2:22 -
Project #4: Automate the SUM Function through Code
9:28 -
Project #4: Loop the SUM Function Over Multiple Worksheets
5:54 -
Project #5: Creating the Final Report
2:55 -
Project #5: Putting it all Togehter to Create the Final Report
9:55 -
Project #6: Working with Excel VBA Forms
3:13 -
Project #6: Creating an Excel VBA Form
2:47 -
Project #6: Adding Controls to the Form
2:41 -
Project #6: Changing Control and Form Properties
4:54 -
Project #6: Adding VBA Code to the Intialize Event
7:24 -
Project #6: Adding VBA Code to the ComboBox Change Event
4:18 -
Project #6: Adding VBA Code to the Add Worksheet Button
6:13 -
Project #6: Adding VBA Code to the Create Report Button
2:02 -
Project #6: Showing the Form
3:26 -
Congratulations
1:02
-