Master Microsoft Excel Macros and Excel VBA

Master Microsoft Excel Macros and Excel VBA

1 Review
248 Enrolled
3.5 Hours
You save 70%
Master Microsoft Excel Macros and Excel VBA

57 Lessons (3.5h)

  • Course Introduction and Overview
  • Project #1: Using Excel's Macro Recorder Tool
  • Excel VBA Concepts
  • Project #2: Moving Beyond the Basics and Into VBA
  • Project #3: Preparing and cleaning up Data with a little VBA
  • Project #4: Using VBA to automate Excel Formulas
  • Project #5: Bringing it all togther and create a weekly report
  • Bonus Project #6: Working with VBA Forms
  • Course Wrap Up
DescriptionInstructorImportant DetailsReviewsRelated Products

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.
1 Review
5/ 5
All reviews are from verified purchasers collected after purchase.

Trey Russell

Verified Buyer

Very good presentation and content . Helped me understand and work VBA into my Excel workbooks for repetitive actions.

Aug 29, 2020
Your Cart
Your cart is empty. Continue Shopping!
Processing order...