Microsoft Excel Advanced Formulas Online Bootcamp

Master your Excel skills with various advanced Excel functions with this live instructed 4 course bootcamp

All Bootcamps are held online due to COVID-19

This Bootcamp is live and instructor led

Price $79

Course Schedule + Curriculum

Course Dates: February 27th - March 7th

Days of the week: Weekends (Saturday + Sunday)

Time (EST): Varies (see specific dates and times below)

Download course curriculum here

Course 1: Text + Date Functions

Saturday, February 27th | 9:00a - 10:00a

• Text functions review
  • RIGHT, LEFT, CONCATENATE
• Date functions
  • MONTH, WORKDAY, TODAY, etc.

Course 2: Reverse VLOOKUP (Index + Match)

Sunday, February 28th | 9:00a - 10:00a

• Learn how to perform the "reverse/backwards" VLOOKUP with INDEX + MATCH

Course 3: Nested If Statements 

Saturday, March 6th | 9:00a - 10:00a

• Learn how to wrap multiple if statements into one
• Perform nested if statements
  • Combining multiple formulas/functions in if statements

Course 4: Aggregate If Statements

Sunday, March 7th | 9:00a - 10:00a

• SUMIFS vs. AVERAGEIFS vs. COUNTIFS

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