Release Date: January 31st, 2021
What is VBA + Macros?
Don't you wish you could automate some of the same monotonous tasks in Excel? This could save you hours of your time at work. Well, let us introduce macros to you! Macros are Excel's version of quick shortcuts you can create to automate repetitive tasks, while VBA is the code behind the macro shortcuts. Sounds intimidating? Don't worry, we got you!
Prerequisite: Microsoft Excel Beginner + Intermediate Bootcamp
Course 1: Intro to Macros
- Record macros
- Combine macros
- Range objects
Course 2: Debugging and Navigation
- Learn how to debug previously written macros
- Navigate through worksheets using macros
Course 3: Intro to VBA
- Navigate through worksheets using VBA
Course 4: Input box and loops
- Create input boxes
Course 5: More Loops!
- Perform more looping of our worksheets
Microsoft Excel 2013 or newer required for PC and Mac Laptops
We will create a portfolio of your completed projects and assignments of all coursework from class as well as provide an instruction guide on how to add the portfolio to your LinkedIn account. Portfolios come in great handy when interviewing for roles that require the technical skills in which you will learn in class.
Certificate of Completion
You will receive a certificate of completion upon submission of all homework assignments and portfolio by the specified deadline.
Refund Policy: No Refunds