Formula Description Example
=SUM(A1:A5) Adds values in a range Adds values from A1 to A5
=AVERAGE(B1:B5) Calculates average
=MIN(C1:C5) Smallest number
=MAX(C1:C5) Largest number
=ROUND(D1, 2) Rounds to 2 decimal places
Formula Description Example
=IF(A1>100, "High", "Low") Conditional logic Returns "High" if A1 > 100
=AND(A1>0, B1<10) Both conditions must be TRUE
=OR(A1>100, B1<5) Any one condition must be TRUE
=NOT(A1=100) Opposite of condition TRUE if A1 ≠ 100
Formula Description Example
=VLOOKUP("Apple", A2:B10, Finds "Apple" in 1st column and returns
Vertical lookup
2, FALSE) value from 2nd column
=HLOOKUP(90, A1:D2, 2,
Horizontal lookup
TRUE)
Returns value from 2nd
=INDEX(A1:C3, 2, 3)
row, 3rd column
=MATCH(100, A1:A10, 0) Returns position of value
Formula Description Example
=CONCAT(A1, " ", B1) or =A1 & " " & B1 Combine text
=LEFT(A1, 4) Extracts first 4 characters
=RIGHT(A1, 3) Extracts last 3 characters
=MID(A1, 2, 5) Extracts 5 characters from 2nd position
=LEN(A1) Counts characters
Formula Description Example
=LOWER(A1) / =UPPER(A1) Converts to lowercase/uppercase
=TRIM(A1) Removes extra spaces
Formula Description Example
=TODAY() Current date
=NOW() Current date & time
=DATEDIF(A1, B1, "d") Days between dates
=TEXT(A1, "dd-mm-yyyy") Formats date
Formula Description Example
=ISBLANK(A1) Checks if a cell is empty
=IFERROR(A1/B1, "Error") Handles division by zero
=COUNT(A1:A10) Count of numbers
=COUNTA(A1:A10) Count of non-empty cells
=UNIQUE(A1:A10) Lists unique values (Excel 365+)
=FILTER(A1:B10, B1:B10>100) Filters values >100 (Excel 365+)
Action Shortcut
Move to beginning of row Home
Move to beginning of sheet Ctrl + Home
Move to end of used range Ctrl + End
Move to next sheet Ctrl + Page Down
Move to previous sheet Ctrl + Page Up
Move to edge of data region Ctrl + Arrow Key
Action Shortcut
Edit active cell F2
Copy Ctrl + C
Cut Ctrl + X
Paste Ctrl + V
Undo Ctrl + Z
Redo Ctrl + Y
Delete selected cells Delete
Insert row Ctrl + Shift + +
Delete row Ctrl + -
Action Shortcut
Bold Ctrl + B
Italic Ctrl + I
Underline Ctrl + U
Open Format Cells dialog Ctrl + 1
Center align Alt + H + A + C
AutoFit column width Alt + H + O + I
Add border Ctrl + Shift + &
Remove border Ctrl + Shift + _
Action Shortcut
AutoSum Alt + =
Insert function Shift + F3
Recalculate formulas F9
Apply filter Ctrl + Shift + L
Open filter dropdown Alt + ↓ (on filtered cell)
Action Shortcut
Action Shortcut
Select entire column Ctrl + Space
Select entire row Shift + Space
Select entire worksheet Ctrl + A (twice if inside a table)
Extend selection by cell Shift + Arrow Key
Select to last used cell Ctrl + Shift + End
Action Shortcut
New workbook Ctrl + N
Open workbook Ctrl + O
Save workbook Ctrl + S
Close workbook Ctrl + W
Rename worksheet Alt + H + O + R
Insert new worksheet Shift + F11
Action Shortcut
Start slideshow from beginning F5
Start slideshow from current slide Shift + F5
Next slide Right Arrow or N
Previous slide Left Arrow or P
Black screen during slideshow B
White screen during slideshow W
Insert new slide Ctrl + M
Duplicate slide Ctrl + D
Save presentation Ctrl + S
Open presentation Ctrl + O
Action Shortcut
Bold text Ctrl + B
Group objects Ctrl + G
Ungroup objects Ctrl + Shift + G
Align objects (menu) Alt + H, G, A
