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