Skip to content
exercicesexcel

The course

Pick a lesson and dive in

Each lesson is a set of exercises in a spreadsheet simulator. Answer correctly to fill the progress bar, earn points and let Cellie cheer you on.

  • 0 / 85 lessons completed
  • 0 points

Today's High Scores 📈

--
--
--

Today's High Streaks 🔥

--
--
--
My Streak Today:0

Complete a lesson today to start your streak!

Chapter 1

Getting started

  1. Intro to Excel8 exercisesStart

Chapter 2

Intro to shortcuts

  1. Number Formatting Shortcuts10 exercises PremiumStart
  2. Fill Right & Fill Down10 exercises PremiumStart
  3. Intro to Shortcuts10 exercises PremiumStart
  4. Text Formatting Shortcuts10 exercises PremiumStart
  5. Cut, Copy, Paste10 exercises PremiumStart
  6. Data Shortcuts10 exercises PremiumStart

Chapter 3

Cell selection shortcuts

  1. Cell Selection Shortcuts10 exercisesStart
  2. Larger Cell Selections10 exercises PremiumStart
  3. Arrow Keys10 exercises PremiumStart
  4. Row and Column Selections10 exercises PremiumStart
  5. Cell Selection Shortcuts 210 exercises PremiumStart
  6. Larger Cell Selections 210 exercises PremiumStart
  7. Cell Selection Skill Summary10 exercises PremiumStart

Chapter 4

Adding things up

  1. SUM Function10 exercises Video PremiumStart
  2. AutoSum10 exercises Video PremiumStart
  3. Intro to SUMIF10 exercises Video PremiumStart
  4. SUMIF & Sum Range10 exercises PremiumStart
  5. SUMIFS Function10 exercises PremiumStart
  6. SUM Functions Skill Summary10 exercises PremiumStart
  7. SUMIF Practice10 exercisesReal workbook PremiumStart
  8. SUMIFS Practice10 exercisesReal workbook PremiumStart
  9. Debugging SUM Functions10 exercises PremiumStart

Chapter 5

Counting

  1. COUNT Function10 exercises PremiumStart
  2. COUNTIF Function10 exercises Video PremiumStart
  3. COUNTIFS Function10 exercises Video PremiumStart
  4. COUNT Practice10 exercises VideoReal workbook PremiumStart
  5. COUNT Skill Summary10 exercises PremiumStart
  6. Other Count Functions10 exercises PremiumStart

Chapter 6

Logical functions

  1. True & False10 exercises Video PremiumStart
  2. IF Function10 exercises Video PremiumStart
  3. AND, OR, XOR Functions10 exercises PremiumStart
  4. IS Functions10 exercises PremiumStart
  5. IFS Function10 exercises PremiumStart
  6. SWITCH Function10 exercises PremiumStart
  7. IF Combinations10 exercises PremiumStart

Chapter 7

Lookup functions

  1. VLOOKUP Function10 exercises PremiumStart
  2. VLOOKUP Function 210 exercises PremiumStart
  3. VLOOKUP Practice10 exercisesReal workbook PremiumStart
  4. HLOOKUP Function10 exercises PremiumStart
  5. HLOOKUP Function 210 exercises PremiumStart
  6. XLOOKUP Function10 exercises PremiumStart
  7. XLOOKUP Function 210 exercises PremiumStart
  8. More VLOOKUP Practice10 exercises PremiumStart
  9. VLOOKUP Approximate Match10 exercises PremiumStart
  10. XLOOKUP & Wildcards10 exercises PremiumStart

Chapter 8

Searching text

  1. Wildcard Characters10 exercises Video PremiumStart
  2. LEN, LEFT, and RIGHT Functions10 exercises PremiumStart
  3. MID Function10 exercises PremiumStart
  4. LEN, LEFT, RIGHT, MID Practice10 exercisesReal workbook PremiumStart
  5. FIND Function10 exercises PremiumStart
  6. SEARCH Function10 exercises PremiumStart
  7. TEXTBEFORE & TEXTAFTER10 exercises PremiumStart

Chapter 9

Changing text

  1. CONCAT Function10 exercises PremiumStart
  2. TEXTJOIN Function10 exercises PremiumStart
  3. UPPER, LOWER, and PROPER Functions10 exercises PremiumStart
  4. SUBSTITUTE Function10 exercises PremiumStart

Chapter 10

INDEX and MATCH

  1. MATCH Function10 exercises PremiumStart
  2. INDEX Function10 exercises PremiumStart
  3. INDEX MATCH Lookup10 exercises PremiumStart
  4. INDEX MATCH Practice10 exercisesReal workbook PremiumStart
  5. Index Match Skill Summary10 exercises PremiumStart
  6. MATCH Practice10 exercises PremiumStart

Chapter 11

Statistics

  1. AVERAGE Function10 exercises PremiumStart
  2. MIN, MAX, LARGE, SMALL Functions10 exercises PremiumStart
  3. MIN, MAX, LARGE, SMALL Practice10 exercisesReal workbook PremiumStart
  4. FLOOR & CEILING Functions10 exercises PremiumStart
  5. ODD and EVEN Functions10 exercises PremiumStart
  6. MEDIAN Function10 exercises PremiumStart
  7. MODE Function10 exercises PremiumStart

Chapter 12

Tables

  1. Pivot Tables 110 exercises PremiumStart
  2. Pivot Tables 210 exercises PremiumStart
  3. Table Filters10 exercises PremiumStart
  4. Tables Skill Summary10 exercises PremiumStart

Chapter 13

Dates

  1. DATE Function10 exercises PremiumStart
  2. TODAY Function10 exercises PremiumStart
  3. DATEDIF Function10 exercises PremiumStart
  4. DAYS Function10 exercises PremiumStart
  5. DATE Functions Skill Summary10 exercises PremiumStart

Chapter 14

Other Excel skills

  1. Worksheets10 exercises PremiumStart
  2. Conditional Formatting10 exercises PremiumStart

Chapter 15

Array formulas

  1. UNIQUE Function10 exercisesReal workbook PremiumStart
  2. FILTER Function10 exercisesReal workbook PremiumStart

Chapter 16

Putting it together

  1. Real Estate Analysis10 exercises PremiumStart
  2. Hospital Administration10 exercises PremiumStart