Microsoft Excel Formulas Online Bootcamp

Kick up your Excel knowledge with lookups and if statements with this live instructed 4 course bootcamp

This workshop is live and instructor led
Price $49
What will we learn in the workshop?
In this workshop, you will learn the most popular intermediate and advanced formulas in the most widely used tool in corporate America. Prerequisite: Microsoft 2016 or newer and beginner knowledge of Excel (Worksheet navigation, formatting, basic formulas (SUM, AVERAGE, etc.), cell referencing). 

Taught by: Kendell Miller, MBA


Course Schedule
Course Date: January 15th - January 30th
Day of the week: Saturday + Sunday
Time (EST): 1000a - 1130a EST 

 

 

Course 1: Text + Dates

Saturday, January 15th | 1000a - 1130a

  • Text functions review
    • RIGHT, LEFT, CONCATENATE
  • Date functions
    • MONTH, DAY, YEAR

Course 2: Vlookups

Sunday, January 16th | 1000a - 1130a

  • Review one of the most popular formulas in Excel!

Course 3: If Statements

Saturday, January 22nd | 1000a - 1130a

  • Learn how to write basic if/then statements
    • Dates
    • Text
    • Numbers
    • Boolean

Course 4: Iferror

Sunday, January 23rd | 1000a - 1130a

  • Correct erroneous if/logical statements 

Course 5: Aggregate If Statements

Saturday, January 29th | 1000a - 1130a

  • SUMIFS vs. AVERAGEIFS vs. COUNTIFS

Course 6: Overview

Sunday, January 30th | 1000a - 1130a

 

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
$49.00