Upgrade to ExcelExercises Premium to access all of our content. Upon completion of all lessons, you earn an ExcelExercises LinkedIn certficiation. You can repeat lessons as many times as you'd like.
Premium includes the following lessons, and we regularly add more:
- • Number Formatting Shortcuts
- • Cell Selection Shortcuts
- • COUNT Function
- • True & False
- • IF Function
- • SUM Function
- • Arrow Keys
- • Wildcard Characters
- • SUMIF Function
- • SUMIFS Function
- • SUM Functions Skill Summary
- • SUMIF Practice
- • SUMIFS Practice
- • COUNTIF Function
- • COUNTIFS Function
- • COUNT Practice
- • COUNT Skill Summary
- • AND, OR, XOR Functions
- • IS Functions
- • IFS Function
- • SWITCH Function
- • Larger Cell Selections
- • Row and Column Selections
- • Cell Selection Shortcuts 2
- • Larger Cell Selections 2
- • Cell Selection Skill Summary
- • VLOOKUP Function
- • VLOOKUP Function 2
- • VLOOKUP Practice
- • HLOOKUP Function
- • HLOOKUP Function 2
- • XLOOKUP Function
- • XLOOKUP Function 2
- • MATCH Function
- • INDEX Function
- • INDEX MATCH Lookup
- • INDEX MATCH Practice
- • Index Match Skill Summary
- • LEN, LEFT, and RIGHT Functions
- • MID Function
- • LEN, LEFT, RIGHT, MID Practice
- • FIND Function
- • SEARCH Function
- • Intro to Shortcuts
- • Text Formatting Shortcuts
- • Cut, Copy, Paste
- • Data Shortcuts
- • AVERAGE Function
- • MIN, MAX, LARGE, SMALL Functions
- • MIN, MAX, LARGE, SMALL Practice
- • FLOOR & CEILING Functions
- • DATE Function
- • TODAY Function
- • DATEDIF Function
- • DAYS Function
- • DATE Functions Skill Summary
- • CONCAT Function
- • TEXTJOIN Function
- • UPPER, LOWER, and PROPER Functions
- • SUBSTITUTE Function
- • Pivot Tables 1
- • Pivot Tables 2
- • Table Filters
- • Tables Skill Summary
- • ODD and EVEN Functions
- • Worksheets
- • Conditional Formatting
- • MEDIAN Function
- • MODE Function