ExcelDailyDrills

Learn Excel by doing.

Type real formulas in a real grid, get instant feedback, and build skills you'll use at work. Start now, no account needed.

Start the first lesson →

Level 1

0 XP total

Daily goal

0 / 30 XP

Streak

0 🔥

StartThe grid: cells, rows and columns →

Fundamentals

Free: everything you need to start.

  1. 1The grid: cells, rows and columnsFind your way around a sheet: cell names, ranges and what cells can hold.
  2. 2Your first formulasMake the spreadsheet do the math: =, + − * /, and cell references.
  3. 3Relative and absolute references ($)Copy formulas safely: when references move, and how $ locks them.
  4. 4Adding up with SUMTotal a whole range in one go, mix ranges and numbers, and fix common mistakes.
  5. 5AVERAGE, MIN, MAX and COUNTSummarize a list: its average, extremes, and how many entries it has.
  6. 6Rounding: ROUND, ROUNDUP, ROUNDDOWNRound values for real, not just for display.
  7. 7Decisions with IFCompare values and return different results depending on the answer.
  8. 8Combining tests: AND, OR, NOTCheck several conditions at once, inside or outside {fn:IF}.

Errors and conditions

Handle errors and count or sum by condition.

  1. 9Reading errors and IFERRORWhat #DIV/0!, #NAME?, #REF! and #VALUE! mean, and how to handle them.
  2. 10Counting by condition: COUNTIF and COUNTIFSCount rows that match one or several conditions, including partial text.
  3. 11Summing by condition: SUMIF, SUMIFS, AVERAGEIFTotal or average only the rows that match your conditions.

Lookups

Find and fetch data from tables.

  1. 12Finding data with XLOOKUPLook up a value in one column and return the matching value from another.
  2. 13The classic: VLOOKUPRead and write VLOOKUP, still everywhere in existing workbooks, including approximate matches.
  3. 14INDEX and MATCHFind positions with MATCH, fetch by position with INDEX, and combine them for two-way lookups.

Text and dates

Clean, split and join text; calculate with dates.

  1. 15Pulling text apart: LEFT, RIGHT, MID, LEN, FINDExtract parts of codes, names and e-mails.
  2. 16Cleaning and joining textTRIM, PROPER/UPPER/LOWER, SUBSTITUTE, & and TEXTJOIN for tidy data.
  3. 17Working with datesDate math, YEAR/MONTH/DAY, DATE, EOMONTH, EDATE and NETWORKDAYS.

Modern Excel and speed

Dynamic arrays and keyboard shortcuts.

  1. 18Dynamic arrays: UNIQUE, SORT, FILTEROne formula, many results: lists that spill into the cells below.
  2. 19Keyboard shortcuts for speedJump, select and edit without the mouse.

Case studies

Put everything together on realistic data.

  1. 20Case study: the bakery's weekAnswer the owner's questions with lookups, conditional sums and IF.
  2. 21Case study: the gym's membersSpot inactive members and compare plans with COUNTIFS, AVERAGEIF, dates and IF.