78 shortcuts that working analysts use, grouped the way you work: move, select, enter, format, insert, paste, total and find. Each one shows the Windows and the Mac keys, and most have a practice round that checks you pressed them.
A plus sign means press the keys together: hold Ctrl, then press the letter. A comma means one after the other. That is how the ribbon key tips work: for Alt, H, A, C you press and release Alt, then press H, then A, then C.
Symbol keys go by the symbol Excel’s help uses. On a US keyboard, Ctrl+Shift+$ is Ctrl+Shift+4, Ctrl+Shift+Plus is Ctrl+Shift+= and Ctrl+` is the key to the left of 1.
On a Mac
Excel for Mac uses Cmd where Windows uses Ctrl for most commands, but not for all of them. The number formats keep Control (Ctrl+Shift+$), Ctrl+U edits the active cell and Option+Right moves to the next sheet. Mac laptops have no Home, End or Page keys, so press Fn with the arrow keys. The function keys can need Fn too, unless you change it in the keyboard settings. Excel for Mac has no ribbon key tips.
Browser-reserved keys
Shortcut practice runs in your browser, and the browser keeps a few keys for itself: Ctrl+T, Ctrl+N, Ctrl+W and Ctrl+Page Down in Chrome and Edge, and Cmd+T, Cmd+N, Cmd+W and Shift+Cmd+T on a Mac. The tables mark them. They work as usual in Excel itself, and where Excel has a second key for the same command, such as Ctrl+L for a table, practice uses that one.
Practice, not memorization
Reading a list doesn’t make keys automatic.
Pressing them does.
Practice gives you ten reps at a time in a working sheet, checks what each key did, and brings back the ones you missed a few days later. The keyboard shortcuts unit of the Excel course teaches them one skill at a time, starting with entering data faster.
Common questions
Which Excel shortcuts are worth learning first?
The ones you would use every hour: Ctrl+Arrow to jump to the edge of the data, Ctrl+Shift+Arrow to select it, Ctrl+D to fill down, F4 to lock a reference, Alt+= for AutoSum, and Ctrl+Alt+V then V to paste values.
Do Excel shortcuts work the same on a Mac?
Most of them, with Cmd where Windows has Ctrl. Some are different: you edit a cell with Ctrl+U, AutoSum is Shift+Cmd+T, the next sheet is Option+Right, and there are no ribbon key tips. The tables show both keyboards.
How do I paste values only in Excel?
Copy the cells, select where they go, press Ctrl+Alt+V (Mac: Ctrl+Cmd+V), then V and Enter. The formulas stay behind and only the numbers they showed are pasted.
Can I practice Excel shortcuts online?
Yes. Shortcut practice runs in a spreadsheet in your browser. It checks what each key did, times every rep and brings back the shortcuts you missed. It is free, and it needs a keyboard.