Formulas & Functions
How to Calculate Percentage in Excel: 4 everyday cases
How to calculate percentage in Excel: marks out of total, share of a whole, increase from last year, and a discount — each in two steps.
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
Excel Basics
Excel Functions: what they are and the 12 to learn first
What an Excel function is, how it differs from a formula, how to type one with autocomplete, and the twelve functions worth learning in order.
Charts
Excel Combo Chart: bars and a line on one chart
Make an Excel combo chart: sales as bars and growth % as a line on a second axis, in five steps, with the two settings that make it readable.
Print, Share & Protect
Print the Header Row on Every Page in Excel
Repeat the heading row on every printed page in Excel with Print Titles, repeat a column too, and add page numbers in the footer.
Data Cleaning
Remove Spaces in Excel: leading, trailing, all, or double
Remove spaces in Excel: TRIM for extra spaces, SUBSTITUTE for every space, Find and Replace for a one-off, and the invisible space that survives all three.
Shortcuts
Excel Shortcut to Insert a Row (and delete one)
Insert a row in Excel with Ctrl+Shift+Plus, delete with Ctrl+Minus, insert several at once, and insert a column the same way.
Shortcuts
Excel Fill Down Shortcut: Ctrl+D and the double-click trick
The Excel fill down shortcut Ctrl+D, fill right with Ctrl+R, the double-click that fills to the bottom, and filling only the blank cells.
Sorting, Filtering & Lists
Excel Yes/No Drop Down: add one in 20 seconds
Make a Yes/No drop down in Excel with Data Validation, colour Yes green and No red, and count the answers.
Fixes & Errors
Excel Keeps Changing Numbers to Dates: stop it
Excel turns 1/2 into 1-Feb and 3-4 into 4-Mar. Why it happens, three ways to stop it, and how to get the original values back.
Showing 217–225 of 294 tutorials · Page 25 of 33
