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

 

$129.00