Cellwise Try it free

Excel course for beginners, from first formula to FILTER

12 units and 36 five-minute lessons. Read the key ideas here, then practice each one in a real spreadsheet. Units 1–6 are free in full, the first lesson of every other unit is free, and Cellwise Plus unlocks the rest.

  1. Unit 1: Cells and formulasFreeRead the grid, write your first formulas. Meet the grid · Basic arithmetic · Ranges and percents
  2. Unit 2: SUM and friendsFreeAdd, average, and count whole columns. SUM · AVERAGE, MIN, MAX · Counting
  3. Unit 3: Cell referencesFreeFill down without breaking anything. Relative references · Absolute references · Mixed references
  4. Unit 4: Logic with IFFreeMake your sheet decide things. IF basics · AND and OR · Nested decisions
  5. Unit 5: Conditional mathFreeCount and sum only what matches. COUNTIF · SUMIF and AVERAGEIF · Multiple conditions
  6. Unit 6: Working with textFreeClean, join, and slice words. Cleaning text · Joining text · Slicing text
  7. Unit 7: LookupsLesson 1 free · PlusFind answers in another table. VLOOKUP · XLOOKUP · INDEX and MATCH
  8. Unit 8: Clean resultsLesson 1 free · PlusHandle errors and round like a pro. Reading errors · Rounding · Final challenge
  9. Unit 9: Dates and timeLesson 1 free · PlusDeadlines, durations, and calendars. Date basics · Date math · Calendars and labels
  10. Unit 10: Data cleanupLesson 1 free · PlusFix messy exports before they bite. Find and replace · Check your data · Duplicates and uniques
  11. Unit 11: Business mathLesson 1 free · PlusGrowth, margins, loans, and savings. Percentages · Loans and savings · Totals that matter
  12. Unit 12: Dynamic arraysLesson 1 free · PlusOne formula, whole tables of answers. Spill basics · FILTER · Array math