formulastreak

For Excel and Google Sheets

Spreadsheet formulas, five minutes a day.

Short daily lessons on a live sheet in your browser. Write real formulas, see the cells recalculate, get checked instantly, and keep a streak going. From your first =B2*C2 to XLOOKUP and SUMIFS.

Free, no account needed for the first 9 lessons.

Click a cell (or use the arrow keys) to insert its address · Enter shows the resultD2 = $91.00
ABCD
1ItemSoldPriceTotal
2Sourdough loaf14$6.50$91.00
3Croissant32$2.80$89.60
4Cinnamon bun21$3.20$67.20
5Baguette18$3.00$54.00
6Rye loaf9$7.00$63.00
Try:

This is a real sheet. Edit the formula in D2 and the whole column recalculates.

A lesson is a few minutes of doing, not watching.

  1. 1

    See the idea work

    Each lesson opens with one idea and a Try it button that types the formula into a real cell, so you see it calculate before you read on.

  2. 2

    Write the formula yourself

    Type in the formula bar or tap cells to insert references. The sheet recalculates as you type, with hints for every function.

  3. 3

    Get checked, cell by cell

    Wrong? You'll see exactly which cell is off and what it should show. Right? XP, a streak day and the next step.

From first formula to job-ready.

16 units, 55 lessons and 275 exercises on realistic sheets: a plant shop's orders, a sales team's quarter, a household budget, a project plan.

Open the course map
  1. 1

    Cells and formulas

    Free

    =A2*B2, operators, fill down, $A$1

    • Your first formula
    • Divide, brackets and percentages
    • Copy a formula down
    • Lock it with $
  2. 2

    Ranges and functions

    Free

    SUM, AVERAGE, COUNT, MIN, MAX, ROUND

    • Ranges and SUM
    • AVERAGE, MAX and MIN
    • COUNT and COUNTA
    • Shares and percent change
    • ROUND, and functions inside functions
  3. 3

    Decisions

    Pro

    IF, AND, OR, nested IF, IFERROR

    • TRUE, FALSE and IF
    • More than two outcomes
    • AND and OR
    • IFS and SWITCH
    • Errors and blank cells
  4. 4

    Lookups

    Pro

    VLOOKUP, INDEX/MATCH, XLOOKUP

    • VLOOKUP
    • INDEX and MATCH
    • XLOOKUP
  5. 5

    Conditional totals

    Pro

    SUMIFS, COUNTIFS, AVERAGEIFS, wildcards

    • SUMIF and criteria
    • SUMIFS
    • COUNTIF, AVERAGEIFS and MAXIFS
    • Wildcards
  6. 6

    Text and dates

    Pro

    TRIM, LEFT, FIND, TEXT, DATE, NETWORKDAYS

    • Tidy text: TRIM and PROPER
    • Cut text: LEFT, RIGHT and MID
    • Find a position: FIND and LEN
    • Join text and TEXT()
    • Dates
  7. 7

    Dates and time maths

    Pro

    DATEDIF, YEARFRAC, WORKDAY, hours

    • Years, months and tenure
    • Weekdays and working days
    • Hours and times
  8. 8

    Cleaning text at scale

    Pro

    SUBSTITUTE, CLEAN, split names, VALUE

    • SUBSTITUTE, CLEAN and invisible spaces
    • Split names and codes
    • Numbers stored as text
  9. 9

    Data quality

    Pro

    Duplicates, type checks, IFS, SWITCH

    • Find duplicates
    • Check and convert types
  10. 10

    Advanced lookups

    Pro

    Two-way, tiers, multiple criteria

    • Two-way lookups
    • Tiers and brackets
    • Lookups on several conditions
  11. 11

    Dynamic arrays

    Pro

    FILTER, UNIQUE, SORT, SEQUENCE, #

    • FILTER
    • UNIQUE and SORT
    • SEQUENCE and spill ranges
  12. 12

    LET and LAMBDA

    Pro

    LET, LAMBDA, MAP, BYROW, REDUCE

    • LET
    • LAMBDA
  13. 13

    Statistics

    Pro

    MEDIAN, PERCENTILE, STDEV.S, CORREL

    • Typical values and spread
    • Ranks, percentiles and bands
  14. 14

    Money and finance

    Pro

    PMT, FV, NPER, NPV, IRR

    • Simple and compound interest
    • Loan payments
    • Amortization schedule
    • Savings, NPV and IRR
  15. 15

    Reporting patterns

    Pro

    SUMIFS grids, growth, running totals, top N

    • Summary grids and SUMPRODUCT
    • Running totals and growth
    • Top N and rankings
  16. 16

    Job test pack

    Pro

    Timed, original job-test problems

    • Warm-up round
    • Core round
    • Final round
    • Case study

Built so the skill actually sticks.

  • Checked as a real formulaAnswers must start with = and use the sheet's cells. We also re-run them on changed data, so a typed-in number never passes. That's the habit your future spreadsheets need.
  • Excel and Google Sheets, honestlyEverything taught works in both. Where they differ (XLOOKUP in older Excel, IFS, Sheets-only functions), the lesson says so.
  • A streak, not a guilt tripA daily goal you pick, streak backups for busy days, and a daily review that brings back exactly the exercises you're about to forget.
12 340An example of what a few weeks looks like

Free guides with live sheets.

The formulas people search for most, explained with examples you can edit right on the page.

All guides

Free formula tools, no account needed.

For Excel and Google Sheets. They run in your browser and send nothing you paste to anyone.

All free tools

Questions

Do I need Excel or Google Sheets installed?+

No. Every lesson runs on a live sheet in your browser, on your phone or computer. What you learn works the same when you open Excel or Google Sheets at work.

Is it for Excel or for Google Sheets?+

Both. The course teaches formulas that behave the same in each, and points out the few differences, such as XLOOKUP needing Excel 2021 or Microsoft 365.

How are answers checked?+

On our server, against an answer key built from the official solution. Your formula must use the sheet's cells, and it's re-run on changed data, so typing in the result doesn't pass.

What does it cost?+

Units 1 and 2 are free, with no time limit and no card. Pro, which opens soon, unlocks the rest for $6 a month, $40 a year or $99 once.

Your first formula takes about a minute.

No account, no card, no install. Just a sheet and a blinking cursor.

Start now