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