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.

The course

0% done · Level: Beginner

Start the course

1. Beginner

Your first formulas: totals, averages, simple decisions and text.

0 of 38 done

Your first formula Not done yet
Add up with SUM Not done yet
Average, highest, lowest and how many Not done yet
Fill a formula and lock a cell Not done yet
Make decisions with IF Not done yet
Round numbers Not done yet
Combine tests with AND, OR and NOT Not done yet
Make a sheet easy to read Not done yet
Whole numbers, remainders and roots Not done yet
A week at the café Not done yet Questions about a staff list Not done yet Stock check Not done yet Beginner test Not done yet

2. Intermediate

The conditions, lookups and dates that offices run on.

0 of 63 done

Count, sum and average with a condition Not done yet
Look things up with XLOOKUP Not done yet
Join and tidy text Not done yet
Several conditions at once Not done yet
Dates are numbers Not done yet
Many outcomes: IFS and SWITCH Not done yet
Catch errors with IFERROR Not done yet
INDEX and MATCH Not done yet
VLOOKUP, the older lookup Not done yet
Take text apart Not done yet
Clean up messy text Not done yet
Show numbers and dates as text Not done yet
Working days and month ends Not done yet
Rank a list and measure it Not done yet
Build dates and use today Not done yet
Search text and split it Not done yet
Sales by region Not done yet A quarter of spending Not done yet Tidy up a customer list Not done yet Orders and a price list Not done yet Intermediate test Not done yet

3. Advanced

Arrays that spill, and the maths of money.

0 of 43 done

Formulas that spill Not done yet
The maths of a loan Not done yet
Multiply then add: SUMPRODUCT Not done yet
Name the parts: LET and LAMBDA Not done yet
Reshape a table Not done yet
Is the project worth it? NPV and IRR Not done yet
Point at cells by position Not done yet
Ask a loan other questions Not done yet
Returns when the dates are uneven Not done yet
Row by row, and lists stacked Not done yet
Commission report Not done yet Who are the biggest customers? Not done yet Payroll from two sheets Not done yet Advanced test Not done yet

4. Real projects

A budget report, a loan schedule and a valuation, built part by part. Then the final test.

0 of 4 done

Keyboard shortcuts

Optional. The keys that make Excel fast.

0 of 38 done

Getting around Not done yet
Selecting Not done yet
Entering and editing Not done yet
Copying and filling Not done yet
Working with formulas Not done yet
Formatting Not done yet

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