Microsoft Excel VBA Beginner + Intermediate Masterclass Online Bootcamp

Take your VBA skills to the next level

All Bootcamps are held online due to COVID-19
This Bootcamp is live and instructor led
Price $99
What the heck 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
The prerequisite for this bootcamp includes comfortable knowledge in the following topics: Vlookups, if statements, formatting, basic mathematical operations, and sumifs/countifs/averageifs, recording macros, macro shortcuts, and VBA variables.

Course Schedule
Course Dates: March 27th - April 10th
Days of the week: Weekends (Saturday + Sunday)
Time (EST): 900a - 1030a EST

 

 

Course 1: Intro to Macros
Saturday, March 13th | 9:00a - 10:00a
  • Record macros

Course 2: Macro Buttons
Sunday, March 14th | 9:00a - 10:00a
  • Create macro buttons

Course 3: Intro to VBA 
Saturday, March 20th | 9:00a - 10:00a
  • Objects vs. Properties
  • Review of existing macro scripts

Course 4: References
Sunday, March 21st | 9:00a - 10:00a
  • Navigate through worksheets using VBA

Course 5: Variables 
Saturday, March 27th | 9:00a - 10:00a
  • Declaring variables 

Course 6: For Next Loops
Saturday, April 3rd | 9:00a - 10:30a

Course 7: For Each Next Loops
Saturday, April 10th | 9:00a - 10:30a

Course 8: Do While Loops
Sunday, April 11th | 9:00a - 10:30a

Course 9: Do Until Loops
Saturday, April 17th | 9:00a - 10:30a

Course 10: Built In Functions (Part 1)
Sunday, April 18th | 9:00a - 10:30a

Course 11: Built In Functions (Part 2)
Saturday, April 24th | 9:00a - 10:30a

Course 12: Built In Functions (Part 3)
Sunday, April 25th | 9:00a - 10:30a
Microsoft Excel 2013 or newer required for PC and Mac Laptops 
Course materials, access codes, and reminders will be sent 7 days prior to the start of the first course of the Bootcamp

What's Included:

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

 

$99.00