Become the Excel Master of Your Office

Total Lessons Completed
0
Get a LinkedIn certification upon completion of all lessons
Next Recommended Lesson:

SUM Function

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

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

Index Match Lookup
INDEX, MATCH, INDEX+MATCH

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

Tables
Filters, Pivot Tables

Other Excel Skills
Conditional Formatting, Worksheets

Wine Dashboard
Interactive Wine Dashboard Project

UFO DASHBOARD
Interactive UFO Dashboard Project


Today's High Scores
My Points Today: 0
You won't appear on the leaderboard until you log in or create an account



How Do You Like Excel Exercises?

Would you mind giving us some feedback to improve the site?

Give Feedback