Understand the move. Build the habit.
Excel keyboard shortcuts
and formula practice.
All Training is Free
Learn how to move around a worksheet, write a formula and check what the result means. SheetFluency combines short explanations with practical spreadsheet examples, so you can build useful skills one step at a time.
Try the public beta. Practice keyboard skills, follow formula lessons or explore a separate Free Practice workbook. This is a bounded simulator, not the complete Microsoft Excel application. Some commands are reference-only; browser shortcut handling varies.
Explore the Excel-style simulator at your own pace.
All keyboard lessons, formula lessons and the practice workbook in the current beta are free to use.
Read a keyboard example · Read formula examples
The interactive trainer is designed for a desktop or laptop with a physical keyboard. These lessons remain readable on mobile.
Example · monthly balance
What is left after expenses?
Revenue is 2,400. Expenses are 1,650. Subtract expenses from revenue to find a balance of 750.
Illustrative figures, not financial advice. Formula in B3: =B1-B2.
Lesson 1 · navigation and editing
Move to a cell, then edit with intention.
In Windows desktop Excel, navigation and editing are different states. Recognizing the difference helps you avoid replacing a value by accident.
1. Go directly to B3
Press Ctrl + G, type B3, then press Enter. Go To selects the cell without changing its contents.
2. Edit the formula
With B3 selected, press F2 to edit its existing formula. If it contains =B1-B2, you are editing that expression—not the displayed result of 750.
3. Commit or cancel
Press Enter to commit an edit, or Escape to abandon the current edit. Escape does not undo an edit that was already committed.
Check your understanding: To inspect a formula without changing it, use F2, read it, then Escape. Browser and operating-system shortcuts can differ; these steps describe Windows desktop Excel, not guaranteed browser key handling.
Lesson 2 · formulas and references
Write the relationship, not just the answer.
Subtract with cell references
Enter =B1-B2 in B3. With B1 equal to 2,400 and B2 equal to 1,650, the result is 750. If expenses change to 1,800, the same formula returns 600.
Typing 750 instead would store a fixed number; it would not follow later changes to the inputs.
Sum a range
If C2, C3 and C4 contain 120, 80 and 50, =SUM(C2:C4) returns 250. The colon means the continuous range from C2 through C4, including both ends.
A quick check: 120 + 80 = 200, then 200 + 50 = 250. Estimate or calculate a small example to catch an incorrect range.
Keep one reference fixed
Suppose B2 contains a price of 80 and E1 contains a rate of 10%. In C2, =B2*$E$1 returns 8. Copy the formula down to C3 and it becomes =B3*$E$1.
B2 is relative and moves with the copy. The dollar signs keep column E and row 1 fixed. They do not change the value or turn it into currency.
Practice that explains the why.
The beta trainer uses synthetic worksheet scenarios. Keyboard lessons introduce supported commands; Formula foundations combines worked examples, guided tasks and fresh checks of understanding. It is a bounded browser simulator, not Microsoft Excel, and does not reproduce every Excel feature. Free Practice lets you explore supported commands separately from lessons. Workbooks and drafts use browser-local storage; keep your own copies of important work. Local progress does not automatically follow you to another site, browser or device.
This learning page has no advertising scripts or account form. No workbook is requested by these examples. Do not enter confidential information into practice workbooks. Training is ad-free. The beta may have limitations or bugs; do not use it as your only copy of important work.
Practice guides for everyday Excel tasks
Read a short example, predict the result, then practice in the trainer.