Excel cheat sheet
| Category | Description | Excel Formula/Shortcut |
|---|---|---|
| Math | Add numbers | =SUM(A1:A10) |
| Math | Average of numbers | =AVERAGE(A1:A10) |
| Math | Count numbers | =COUNT(A1:A10) |
| Math | Count non-empty cells | =COUNTA(A1:A10) |
| Math | Round a number | =ROUND(A1, 2) |
| Math | Multiply numbers | =PRODUCT(A1:A10) |
| Math | Maximum value | =MAX(A1:A10) |
| Math | Minimum value | =MIN(A1:A10) |
| Logical | If condition | =IF(A1>10, "Yes", "No") |
| Logical | And condition | =AND(A1>0, B1>0) |
| Logical | Or condition | =OR(A1>0, B1>0) |
| Logical | Not condition | =NOT(A1>0) |
| Logical | If error handling | =IFERROR(A1/B1, "Error") |
| Text | Concatenate text | =CONCATENATE(A1, " ", B1) |
| Text | Convert to uppercase | =UPPER(A1) |
| Text | Convert to lowercase | =LOWER(A1) |
| Text | Proper case (capitalize words) | =PROPER(A1) |
| Text | Extract left characters | =LEFT(A1, 3) |
| Text | Extract right characters | =RIGHT(A1, 3) |
| Text | Extract middle characters | =MID(A1, 2, 3) |
| Text | Find text position | =FIND("a", A1) |
| Text | Replace text | =SUBSTITUTE(A1, "old", "new") |
| Lookup | Vertical lookup | =VLOOKUP(A1, B1:C10, 2, FALSE) |
| Lookup | Horizontal lookup | =HLOOKUP(A1, B1:M2, 2, FALSE) |
| Lookup | Index and match | =INDEX(B1:B10, MATCH(A1, A1:A10, 0)) |
| Lookup | Exact match lookup | =XLOOKUP(A1, A1:A10, B1:B10) |
| Date | Current date | =TODAY() |
| Date | Current date and time | =NOW() |
| Date | Difference in days | =DATEDIF(A1, B1, "d") |
| Date | Difference in months | =DATEDIF(A1, B1, "m") |
| Date | Day of the month | =DAY(A1) |
| Date | Month number | =MONTH(A1) |
| Date | Year number | =YEAR(A1) |
| Stats | Median value | =MEDIAN(A1:A10) |
| Stats | Mode of numbers | =MODE(A1:A10) |
| Stats | Standard deviation | =STDEV(A1:A10) |
| Shortcut | Copy | Ctrl + C |
| Shortcut | Paste | Ctrl + V |
| Shortcut | Cut | Ctrl + X |
| Shortcut | Undo | Ctrl + Z |
| Shortcut | Redo | Ctrl + Y |
| Shortcut | Select all | Ctrl + A |
| Shortcut | Insert new row | Ctrl + Shift + + |
| Shortcut | Delete row | Ctrl + - |
| Shortcut | Format cells | Ctrl + 1 |
| Shortcut | Bold text | Ctrl + B |
| Shortcut | Italic text | Ctrl + I |
| Shortcut | Go to cell | F5 |
| Shortcut | AutoSum | Alt + = |
| Shortcut | Fill down | Ctrl + D |
| Shortcut | Fill right | Ctrl + R |
| Shortcut | Switch worksheets | Ctrl + Page Up/Down |
