Excel Beginner Series
Learn Excel by actually typing formulas — right here in your browser.
A live practice grid, five bite-size lessons, instant feedback, and a quiz. No sign-up, no install. Master SUM, AVERAGE, IF and VLOOKUP in about fifteen minutes.
The practice sheet
Your live spreadsheet
Six columns (A–F), eight rows, preloaded with sample sales data. Click any cell and type. Start a formula with =, for example =SUM(B2:B7) or =C2*B2. Results compute instantly.
Guided lessons
Five lessons, one skill each
Check yourself
The 10-question quiz
Pick an answer to see instantly whether it is right, with a plain-English explanation.
Your score
0/10Keep this handy
Cheat sheet: the 10 most-used formulas
| Formula | What it does |
|---|---|
| =SUM(B2:B7) | Adds every number in the range. |
| =AVERAGE(C2:C7) | Mean of the numbers in the range. |
| =MIN(C2:C7) | Smallest number in the range. |
| =MAX(C2:C7) | Largest number in the range. |
| =COUNT(B2:B7) | How many cells contain numbers. |
| =IF(B2>50,"High","Low") | Returns one value if true, another if false. |
| =VLOOKUP("Mouse",A2:C7,3,FALSE) | Finds a row by its first column and returns column 3. |
| =B2*C2 | Multiplies two cells (units times price). |
| =$C$2*B3 | Locks C2 so it never shifts when copied. |
| =SUM(B2:B7)/COUNT(B2:B7) | Combine functions: a manual average. |