Last Updated: November 21, 2025
Essential Formulas
| Formula | Description | Example |
|---|---|---|
=SUM(A1:A10)
|
Sum range of cells | =SUM(B2:B20) |
=AVERAGE(A1:A10)
|
Average of range | =AVERAGE(C2:C50) |
=COUNT(A1:A10)
|
Count numeric values | =COUNT(A:A) |
=IF(condition, true, false)
|
Conditional logic | =IF(A1>100, 'High', 'Low') |
=VLOOKUP(value, range, col, FALSE)
|
Vertical lookup | =VLOOKUP(A2, D:E, 2, FALSE) |
=CONCATENATE(A1, B1)
|
Join text | =CONCATENATE(A1, ' ', B1) |
=LEFT(text, num)
|
Extract left characters | =LEFT(A1, 5) |
=RIGHT(text, num)
|
Extract right characters | =RIGHT(A1, 3) |
Keyboard Shortcuts (Windows)
| Shortcut | Action |
|---|---|
Ctrl + C
|
Copy |
Ctrl + V
|
Paste |
Ctrl + Z
|
Undo |
Ctrl + Y
|
Redo |
Ctrl + F
|
Find |
Ctrl + H
|
Replace |
Ctrl + S
|
Save |
Ctrl + Home
|
Go to cell A1 |
F2
|
Edit active cell |
Alt + =
|
AutoSum |
💡 Pro Tip:
Use F4 to toggle between absolute ($A$1) and relative (A1) cell references!