Microsoft Excel Formulas Online Bootcamp

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

All courses are online and 1:1 instructor led, leading to a more dedicated learning experience for you!
Total hours: 10 hours @ $49/hr (Installment plans available)
What will we learn in the course?
In this course, 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). 

 


Course Information
Classroom Style: Virtual - live classroom setting 
Type: 1:1 training
Time (EST): One hour time slots available between M - Th 10a - 7p EST 

 

 

Course 1: Text + Dates

 

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

Course 2: Vlookups

 

  • Review one of the most popular formulas in Excel!

Course 3: If Statements

 

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

Course 4: Iferror

 

  • Correct erroneous if/logical statements 

Course 5: Aggregate If Statements

 

  • SUMIFS vs. AVERAGEIFS vs. COUNTIFS

Course 6: Overview

 

 

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
Ready to register? Submit an inquiry form here 
$149.00
Out of stock