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
Today's High Scores 📈
| - | - |
| - | - |
| - | - |
| My Points Today: | 0 |
Today's High Streaks 🔥
| - | - |
| - | - |
| - | - |
| My Streak Today: | 0 |
Daily challenge (last 7 days)
Your accuracy for each day you completed the daily challenge.
PROJECTS
TROUT PROJECT 🐟
Interactive Trout Data Modeling Dashboard Project
PREMIUM
EXCEL INTERVIEW ASSESSMENT 💼
Real-world job interview Excel Assessment
PREMIUM
Wine Dashboard 🍷
Interactive Wine Dashboard Project
PREMIUM
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
