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