Microsoft Excel VBA Macros
This Microsoft Excel VBA macros course will teach you everything you need to start creating powerful Excel macros immediately. You’ll learn to save hours of tedious work by automating tasks in Excel.
Course objectives
We start by learning how to set up our workbook to accept VBA macros and getting you familiar with the coding structure. From there, you’ll learn coding best practices and how coding in VBA works.
With this knowledge, you’ll learn the key coding procedures to automate tasks and perform complicated procedures. You’ll also learn how to create routines, loops, logical tests, and more. You’ll learn everything you need to know to tackle most any VBA project.
At completion, you’ll know how to write code to automate almost any process in Excel.
Some key things you’ll learn:
- Learn the structure of VBA code and best practices
- Create sub routines to segment your code
- Declare and call variables
- Create For /Next loops
- Create If/Then and If/Then/Else logical tests
We recommend taking our Microsoft Excel Bootcamp which is a great complement to this course and will turn you into an Excel powerhouse.
Additional Info
Format: 3-6 minute videos, quizzes, and a final exam
CPEs: 6.0
Field of study: Computer Software & App
Prerequisites: You should have a intermediate knowledge of Excel (e.g. IF statements, VLOOKUP, COUNTIFS, etc.). If you are not comfortable with Excel, we recommend taking our Microsoft Excel Bootcamp.