| 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 |
