Keyboard

No mouse needed.

Anywhere

←↑↓→
Move the selection around the page
Enter
Open whatever is selected
1…9
Go to a section along the top (or, in a workbook, to one of its sheets)
CtrlQ
Leave an open workbook for its list. Works while in the sheet; asks first if you have typed anything
Alt→
Next section (Alt ← for previous), or next sheet in a workbook. Also Alt PgDn and Alt PgUp
CtrlPgDn
Next section or sheet, as in Excel. Needs focus mode
CtrlHome
Top of the page (Ctrl End for the bottom)
S
Start, or continue after your last solved challenge
X
A random function drill (on the Drills page)
G
Jump into the spreadsheet
F
Focus mode: full screen, browser shortcuts handed to the page
?F1
Show or hide this list

On a challenge

CtrlEnter
Check your answer; once it is right, go to the next challenge. In an exam, the next question. Works while in the sheet
Ctrl/
Show a hint. Works while in the sheet
C
Check your answer
H
Show a hint
AltR
Reset the sheet. Works while in the sheet
AltP
Previous question in an exam (Alt N for the next). Works while in the sheet
B
Begin a practice exam

Moving and selecting in a spreadsheet

←↑↓→
Move one cell
Ctrl↓
Jump to the edge of the data
Home
Start of the row (Ctrl Home for A1, Ctrl End for the last cell)
CtrlG
Go to a cell or range: type it in the name box. Also F5
AltPgDn
Next sheet of a workbook with several (Alt PgUp for previous). Its sheets take over the tabs along the bottom. Mid-formula, select cells there to use them
Shift↓
Select a range (add Ctrl to reach the edge of the data)
ShiftSpace
Select the row (Ctrl Space for the column)
CtrlA
Select everything in use
EnterTab
Move down or right. With a range selected, travel through it
Esc
Cancel a copy, or leave the sheet for the page

Writing a formula

=
Start a formula (or just type)
Tab
Complete the suggested function name
←↑↓→
Pick a cell; hold Shift for a range
F4
Lock the reference: A1, $A$1, A$1, $A1
F2
Edit a cell, or switch the arrows between picking cells and moving the text cursor
Alt=
AutoSum the numbers above
Ctrl'
Copy the formula from the cell above
Enter
Confirm. Esc cancels
CtrlEnter
With a range selected, fill every cell with what you typed

Editing a spreadsheet

CtrlC
Copy (Ctrl X to cut)
CtrlV
Paste. Add Shift to paste values only
CtrlD
Fill down: from the cell above, or the top row through a range
CtrlR
Fill right
Delete
Clear the selected cells
CtrlZ
Undo (Ctrl Y to redo)
Ctrl[
Go to the cells a formula uses (Ctrl ] for cells that use this one)
Ctrl`
Show formulas instead of results

Formatting

CtrlB
Bold (Ctrl I italic, Ctrl U underline, Ctrl 5 strikethrough)
CtrlShift1
Number with two decimals and thousands commas
CtrlShift4
Currency
CtrlShift5
Percentage
CtrlShift3
Date (Ctrl Shift 2 for time, Ctrl Shift 6 for scientific)
CtrlShift~
General: remove the number format
CtrlShift7
Border round the selection (Ctrl Shift − removes borders)

On a Mac, use ⌘ wherever Ctrl is shown and Option wherever Alt is shown (Ctrl Space is taken by macOS). For number formats on a Mac use Control+Shift, as Excel does: ⌘+Shift+3, 4 and 5 are macOS screenshots. Ctrl+PgUp/PgDn, Ctrl+W, Ctrl+T and Ctrl+N belong to the browser; focus mode hands them to the page in Chrome and Edge.

Free Excel practice · no signup · nothing to install

Your CV says “proficient in Excel.” Let’s make it true.

Learn Excel by typing real formulas into a real spreadsheet, marked the moment you press Enter. This whole page is a sheet. Point at things.

Start now
Try it. This one is live. Loading…
ABC
1
Item
Cost
2
Rent
850
3
Food
240
4
Travel
95
5
Phone
30
6
Total
7

This is a monthly budget. In B6, work out the total cost of all four items. Click the yellow cell and type =SUM(B2:B5), then press Enter.

One course, start to finish

Short lessons, practice after each one, real data at the end of every level. All of it is free.

1 Beginner 9 lessons2 Intermediate 16 lessons3 Advanced 10 lessons4 Real projects 4 steps

How it works

Learn Excel is hands-on Excel practice. No videos to sit through: you learn each function by using it on a small, realistic sheet.

  1. Step 1

    Type a formula

    Into a real grid with real data. Arrow keys pick cells and ranges, the way they do in Excel.

  2. Step 2

    Watch it calculate

    Every function runs for real, from SUM to XLOOKUP to arrays that spill down the sheet.

  3. Step 3

    Get it marked

    We swap the data behind the scenes. A formula that works passes. A typed-in number does not.

Questions people ask

Is it free?

Yes. Every challenge here is free, and there is nothing to install.

Do I need Excel?

No. The spreadsheet runs in your browser. The formulas are the same ones you will type in Excel, and most work in Google Sheets too.

Do I need an account?

No. Open a challenge and start typing. Your progress is saved in this browser.

How are answers checked?

Your formula is run on the data you can see and on hidden variations of it. Any formula that gives the right results passes, so there is no guessing which one we wanted.

I am a complete beginner. Where do I start?

With SUM, in the sheet at the top of this page. The beginner challenges assume nothing, and each has hints that walk you to the answer.

Does it work on a phone?

It works, but it is built for a keyboard, like Excel itself. A laptop is best.

Cell B6 is waiting.

The first challenge takes about a minute. You will have written a real formula by the end.

Start now

Not affiliated with Microsoft. Excel is a trademark of Microsoft Corporation.