Data Cleaning
Find and Replace in Excel: fix a word everywhere at once
Find and replace in Excel with Ctrl+H: change a word across the sheet, replace in a selection only, and remove characters by replacing with nothing.
Author: Srini Vanamala
Print, Share & Protect
Lock Cells in Excel: protect formulas, let people type elsewhere
Lock cells in Excel so formulas cannot be edited while input cells stay open — the two-step method that catches everyone out.
Formatting
Freeze Panes in Excel: keep the heading row in view
Freeze panes in Excel so the heading row (or first column) stays put while you scroll, and how to unfreeze.
Formulas & Functions
SUMIFS in Excel: add rows that match two or more conditions
SUMIFS in Excel: add sales for one person in one month, or amounts between two dates — several conditions, one formula.
Sorting, Filtering & Lists
Excel Filter: show only the rows you want
Turn on the Excel filter with one shortcut, filter by value, text, number or date, see how many rows match, and clear it.
Formulas & Functions
COUNTIF in Excel: count the cells that match
COUNTIF in Excel: count how many times a name appears, how many values are over a number, how many cells are blank or not.
Formulas & Functions
Excel Percentage Formula: percent of total, change, and discount
The Excel percentage formula for the three jobs people need: percent of a total, percentage change, and taking a discount off a price.
Formulas & Functions
Excel Formulas Cheat Sheet: the 20 you actually use
An Excel formulas cheat sheet with the 20 formulas people use every week — what each does, the exact syntax, and a link to the full lesson.
Formulas & Functions
SUMIF in Excel: add only the rows that match
SUMIF in Excel: add sales for one person, amounts over a number, or dates in a month — one condition, one formula.
152 tutorials · Page 15 of 17
