Become the Excel Master of Your Office

Total Lessons Completed
0
Get a LinkedIn certification 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!
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

Wine Dashboard
Interactive Wine Dashboard Project

UFO DASHBOARD
Interactive UFO Dashboard Project