Formulas & Functions
ROUND in Excel: to 2 decimals, to the nearest 10, up or down
ROUND in Excel: round to decimals, to whole numbers, to the nearest 10 or 100, always up or always down, and why formatting is not rounding.
Learn Excel the easy way.
Short, plain-English tutorials on formulas, shortcuts, charts and everyday Excel tasks. No jargon. One idea per post.
Start here Get Daily One LessonLatest tutorials
Formulas & Functions
Excel LEFT Function: the first few characters of a cell
The Excel LEFT function: take the first N characters, everything before a dash or space, and turn the result back into a number.
Formulas & Functions
Excel IF with AND / OR: test two conditions at once
Combine IF with AND or OR in Excel: pass only if both conditions hold, or if either does, with a bonus example that uses both.
Formulas & Functions
Excel IF Cell Contains Text: flag rows with a word in them
Excel formula to check if a cell contains specific text, using ISNUMBER and SEARCH — case-insensitive, partial match, with a Yes/No result.
Formulas & Functions
Nested IF in Excel: three or more outcomes without the mess
Nested IF in Excel explained with a grade example, how to keep the brackets straight, and the IFS function that replaces it in newer Excel.
Formulas & Functions
IFERROR in Excel: hide #N/A and #DIV/0! errors
IFERROR in Excel wraps any formula and shows your own text or a blank instead of #N/A, #DIV/0! or #VALUE!. When to use it and when not to.
Formulas & Functions
Excel AVERAGE Formula: the mean, and averages that skip zeros
The Excel AVERAGE formula, why blanks and zeros give different answers, AVERAGEIF for one condition, and the median when one big number distorts the mean.
Data Cleaning
TRIM in Excel: remove extra spaces that break lookups
TRIM in Excel removes leading, trailing and double spaces — the fix for VLOOKUPs that fail and duplicates that won't merge. Plus the space TRIM cannot remove.
Data Cleaning
Text to Columns in Excel: split names, addresses and codes
Text to Columns in Excel step by step: split by comma, space or a fixed width, keep leading zeros, and undo when it goes wrong.
Showing 235–243 of 294 tutorials · Page 27 of 33
