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!
This class starts out teaching you how to set up a workbook, to start out with VBA macros and show 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
Format: 3-6 minute videos, quizzes, and a final exam
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.