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