Excel Supreme
Search

Search

Find the exercise

Type what you are trying to do ("remove duplicates", "days between dates", "sum one region") and the exercise that teaches it comes up. No results means no exercise covers it yet, which is worth knowing too.

Arrow keys move through the results, Enter opens one, Escape clears the box.

Every exercise, in order

All 86 exercises, grouped by the skill they teach. Searching narrows this; it does not replace it.

  1. Getting started

    1. Select to the edge of a block paid

  2. Adding things up

    1. SUM: total a column
    2. SUMIFS: two conditions at once
    3. SUMIF: a sum range on another column paid
    4. Add only the positives paid
    5. Debug a total that skips a row paid
    6. SUM across several blocks paid
    7. Running total down a column paid
    8. Sum functions summary paid
    9. SUMIF: total one region

  3. Counting rows

    1. COUNTIF: count one condition
    2. COUNT: numbers only, and what it skips paid
    3. COUNTA: count the non-empty cells paid
    4. COUNTIFS: several conditions paid
    5. COUNTIF with wildcards paid
    6. Count functions summary paid

  4. Averages and ranks

    1. AVERAGE: mean of a score list
    2. MIN and MAX: fastest and slowest paid
    3. LARGE and SMALL: the nth highest paid
    4. MEDIAN: the middle value paid
    5. MODE: the most common value paid
    6. Rank a list without sorting it paid
    7. Average functions summary paid

  5. Decisions with IF

    1. IF: one test, two answers
    2. TRUE and FALSE: what a comparison returns paid
    3. AND, OR and NOT: combining tests paid
    4. IFS: more than two outcomes paid
    5. SWITCH: match a list of values paid
    6. ISBLANK, ISNUMBER, ISTEXT: reading a cell's type paid
    7. Logical functions: putting the pieces together paid

  6. Rounding money

    1. ROUND: money to two decimals
    2. ROUNDUP and ROUNDDOWN: one direction only paid
    3. MROUND and FLOOR: round to a multiple paid

  7. Looking values up

    1. VLOOKUP: exact match
    2. VLOOKUP: approximate match needs a sorted column paid
    3. HLOOKUP: look across a row paid
    4. VLOOKUP with a wildcard paid
    5. Two-way lookup with VLOOKUP and MATCH paid
    6. XLOOKUP: exact match, no column counting paid
    7. XLOOKUP: search from the bottom paid
    8. XLOOKUP with a fallback when nothing matches paid
    9. VLOOKUP and XLOOKUP on the same table paid
    10. Lookup functions summary paid

  8. INDEX and MATCH

    1. INDEX + MATCH: lookup either way paid
    2. MATCH: find a value's position paid
    3. INDEX: a value at a row and column paid
    4. INDEX MATCH: look left of the key paid
    5. Two-way INDEX MATCH paid
    6. INDEX and MATCH summary paid

  9. Finding text

    1. LEFT + FIND: pull out a prefix paid
    2. LEN, LEFT and RIGHT: count and cut
    3. MID: characters from the middle paid
    4. FIND and SEARCH: case-sensitive or not paid
    5. Wildcards in text criteria paid
    6. TEXTBEFORE and TEXTAFTER: split on a delimiter paid
    7. Text search summary paid

  10. Tidying text

    1. CONCAT and the & operator
    2. TEXTJOIN: join a range and skip blanks paid
    3. UPPER, LOWER and PROPER paid
    4. SUBSTITUTE: replace one piece of text paid

  11. Errors and blanks

    1. IFERROR: catch the error, show your text paid
    2. IFNA: catch only a missing match paid
    3. Read #N/A, #VALUE! and #REF! paid
    4. Error handling: which net catches what paid

  12. Dates and deadlines

    1. TODAY and NOW: the volatile clock paid
    2. DATE: build a date from parts paid
    3. DATEDIF: days, months or years between paid
    4. DAYS and simple date maths paid
    5. Date functions summary paid

  13. SUMPRODUCT and friends

    1. SUMPRODUCT: multiply the pair, then add them up paid
    2. SUBTOTAL: one function number, six answers paid
    3. AGGREGATE: a total that says what to ignore paid
    4. Totals that multiply, skip and reconcile paid

  14. Dynamic arrays

    1. UNIQUE: one row per distinct value paid
    2. FILTER: the rows that meet a condition paid
    3. SORT and spilled ranges paid

  15. Real workbooks

    1. A commission sheet that updates itself paid
    2. A headcount and payroll summary paid
    3. An inventory reorder report paid
    4. A monthly close checklist in formulas paid

  16. Capstone projects

    1. Capstone: North gross margin paid
    2. Sales summary end to end paid
    3. Lookup dashboard from three tables paid
    4. Clean up an imported list paid
    5. Budget versus actual with a variance flag paid
    6. Formula audit: fix five broken sheets paid

Browse by skill instead