Microsoft Excel Formulas Online Bootcamp

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

This workshop is live and instructor led
Price $149
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
$149.00
Out of stock