Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Master Microsoft Excel Macros and VBA with 6 Simple Projects

Kyle Pew, Microsoft Certified Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
40 Videos (2h 38m)
    • 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