Master Microsoft Excel Macros and Excel VBA

1 Review
248 Enrolled
3.5 Hours
You save 70% -

57 Lessons (3.5h)

  • Course Introduction and Overview
    Welcome to the Course4:08
    Something to THINK About and SHARE2:01
    Understanding the Why and How Behind Excel Macros3:18
  • Project #1: Using Excel's Macro Recorder Tool
    Introduction to Project #1 - Inserting and Formatting Text1:39
    Project #1 - Start Recording!7:14
    Project #1 - Running a Macro with a Button2:12
    Project #1 - Opps! I Need to Edit My Macro4:04
    Practical Uses of Excel Macros2:17
    Project #1 - Quiz - Test Your Knowledge on Using the Macro Recorder
    Project #1 - Exercise - Try it Yourself and Practice
  • Excel VBA Concepts
    Excel VBA Concepts0:30
    The Visual Basic Editor2:06
    Excel VBA Modules1:14
    Creating Excel VBA Procedures2:05
    Understanding Excel VBA Variables5:16
    Working Excel VBA Loops to repeat blocks of code4:11
    Building Logic with an IF Statement2:39
    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 User2:42
    Project #2 - Breaking Down the VBA Code3:05
    Project #2 - Prompting the User for Information5:35
    Project #2: Building Logic in Your Macros4:57
    Project #2 - Alerting the User of Errors7:05
    Other Practical Uses of Message Boxes and Input Boxes3:18
    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 Worksheets2:59
    Project #3 - Using the Macro Recorder to Lay the Foundation1:53
    Project #3: Preparing to use the Macro Recorder2:28
    Project #3 - Inserting the Headers2:40
    Project #3 - Formatting the Headers5:07
    Project #3 - Putting it all Together with alittle VBA Magic9:54
    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 VBA2:23
    Project #4: Automate the SUM Function through Code9:30
    Project #4: Loop the SUM Function over Multiple Worksheets5:57
    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 Report2:56
    Project 5: Putting it all together to create a Final Report9:57
    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 Forms3:14
    Bonus Project #6: Creating an Excel VBA Form2:48
    Bonus Project #6: Adding Controls to the Form2:42
    Bonus Project #6: Changing Control and Form Properties4:56
    Bonus Project #6: Adding VBA Code to the Initialize Event of the Form7:26
    Project 6: Adding VBA Code to the ComboBox Change Event4:20
    Project #6: Adding VBA Code to the Add Worksheet Button Click Event6:15
    Project #6: Adding VBA Code to the Create Report Button Click Event2:03
    Bonus Project #6: Showing the Form3:27
    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 Master1:02
    BONUS! - Special Offer! Any of my courses for only $10

Use 6 Simple Projects to Become a Master Working with Excel Macros & VBA

Kyle Pew


Kyle Pew is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including:

  • Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013
  • Excel, Word, PowerPoint, Outlook, Access and Visio
  • SharePoint End-User 2007, 2010, 2013
  • VBA (Excel and Access)
  • Adobe Suite
  • Photoshop, Illustrator, InDesign
  • Maya (Modeling and Animation)
  • Unity3d (Game Design)
  • HTML, CSS and JavaScript
  • Crystal Reports

  • Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.

    Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.


During this course, you will build a foundation of working with Excel Macros and VBA. You'll engage in several projects that will build upon one another as you progress through the basic building blocks of automating tasks within Excel. Soon you'll be ready to enter the world of Excel VBA, where you will experience a more dynamic, robust experience for yourself and your peers.

  • Access 57 lectures & 3.5 hours of content 24/7
  • Automate placing & formatting a title on a worksheet
  • Interact w/ the users of your Macros through input & message boxes
  • Clean up multiple Excel worksheets & prepare the data to be reported on
  • Create a report based on multiple sets of data found within multiple Excel worksheets
  • Automate the creation of Excel Formulas to SUM data up in your report


Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels


  • Internet required
  • Microsoft Excel 2010, 2013, or 2016


  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your cart is empty. Continue Shopping!
Processing order...