Microsoft Excel VBA + Macros Self Paced Bootcamp

excel icon

 

 

 

 

Release Date: January 31st, 2021

File:Icon-round-Question mark.svg   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
  • Variables

Course 4: Input box and loops

  • Create input boxes
  • Loops

Course 5: More Loops!

  • Perform more looping of our worksheets

 

 

Microsoft Excel 2013 or newer required for PC and Mac Laptops 

 

What's Included:

Image result for briefcase clipart black and white

Portfolio

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

 

$49.00