Microsoft Excel VBA Macros

If you are serious about Excel and automating your work, our Microsoft Excel VBA macros course will have you saving time with powerful Excel macros right away!


Course Objectives

This class starts out teaching you how to set up a workbook, gets you familiar with VBA macros, and shows you the basics of VBA coding structure.  Once we get through that, you will start to learn how to really put VBA to work with coding best practices.

With these new skills you will be able to start to automate processes and execute complex procedures.  We will also cover creating loops, routines, logic tests, and more.  This course will give you everything you need to get you on your way to automating any process in Microsoft Excel!

Some key things you’ll learn:

  • How VBA code is structured
  • Some best practices in VBA code
  • How to create sub routines and for/next loops
  • Declare and call variables
  • How to create If/Then and If/Then/Else logical tests​

If you aren’t familiar with Microsoft Excel, you should start with our Microsoft Excel Bootcamp

Additional Info

Format: 3-6 minute videos, quizzes, and a final exam

Estimated time to complete: 4-5 hours

Category: Financial Tools & Software

Prerequisites: Before this class, you should have a good working knowledge of Excel (e.g. SUMIF, COUNTIF, VLookup, IF statements, etc.). If you are not comfortable with Excel, we recommend taking our Microsoft Excel Bootcamp.

Enroll in Microsoft Excel VBA Macros now

Course Content

Expand All