Become the Excel Master of Your Office

Total Lessons Completed
0/0
Low Accuracy Needs Practice (≥14 days) Good (<14 days)
Get a certificate of completion upon completion of all lessons
Next Recommended Lesson:

Today's High Scores 📈
- -
- -
- -
My Points Today: 0
You won't appear on the leaderboard until you log in or create an account
Today's High Streaks 🔥
- -
- -
- -
My Streak Today: 0
Complete a lesson today to start your streak!

PROJECTS

TROUT PROJECT 🐟
Interactive Trout Data Modeling Dashboard Project

Wine Dashboard 🍷
Interactive Wine Dashboard Project

UFO DASHBOARD 👽
Interactive UFO Dashboard Project


LESSONS

Sum Functions
SUM, SUMIF, SUMIFS

Count Functions
COUNT, COUNTIF, COUNTIFS

Logical Functions
True/False, AND/OR, IF, IS, IFS, SWITCH

Lookup Functions
VLOOKUP, HLOOKUP, XLOOKUP

Text Search Functions
LEN, LEFT, RIGHT, MID, FIND, WILDCARDS, SEARCH

Intro to Shortcuts
Introductory Keyboard Shortcuts

Cell Selection Shortcuts
Cell Selection Keyboard Shortcuts

Text Manipulation Functions
CONCAT, TEXTJOIN, UPPER, LOWER, PROPER, SUBSTITUTE

Date Functions
DATE, TODAY, DATEDIF, DAYS

Index Match Lookup
INDEX, MATCH, INDEX+MATCH

Statistical Functions
AVERAGE, MIN, MAX, LARGE, SMALL, FLOOR, CEILING, MEDIAN, MODE

Tables
Filters, Pivot Tables

Other Excel Skills
Conditional Formatting, Worksheets