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.
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
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.
Charts
Excel Pie Chart: make one and label it properly
Make an Excel pie chart in four steps, add percentage labels, and know when a bar chart is the better choice.
Sorting, Filtering & Lists
Data Validation in Excel: only allow the right values
Data validation in Excel: limit a cell to whole numbers, a date range, a list, or text length, with your own error message.
Showing 271–279 of 294 tutorials · Page 31 of 33
