Introduction to VBA Programming

What you Learn

  1. Record macros to automate small tasks.
  2. Edit macros you have recorded to make them more powerful.
  3. Program your own code to do things macros can't (including repeating actions with loops and making decisions with if/then statements).
  4. Learn the basics needed to write robust code.

What you Get

  1. One hour video (streamed via YouTube).
  2. Sample files used in the video.
  3. A PDF cheatsheet of topics covered in the tutorial.

Course Details

Are you tired of constantly performing the same tasks week in and week out? Do you find yourself repeating the same steps every month to do your job? If so, then you might be interested in learning VBA. VBA is the programming language built into the Microsoft Office Suite that allows you to automate everyday tasks. If you have ever recorded a macro, then you have utilized part of the power inherent in VBA. In this course, we teach you how to expand on that power by showing you how macros work behind the scenes and offering you tools to enhance your macros in ways you may have never even thought possible. You will learn how to make decisions in macros (so that you can perform one set of tasks under certain scenarios while doing something else under different scenarios). We also show you how to repeat actions so that you can perform the same set of tasks over and over without having to lift a finger after you write the code.

Who Should View this Course

This course is fast paced and is intended for Excel power users. Some familiarity with macros is helpful, but not required. Additionally, you should feel comfortable navigating Excel without the mouse. If you need help in this regard, you can check out our free Shortcuts short clip video tutorial and Excel add-in. Lastly, due to the amount of material covered in the tutorial and the pace at which it is introduced, you may need to watch the video more than once.