Excel Basics
How to Move a Column in Excel (without overwriting anything)
How to move a column in Excel: the Shift-drag method that inserts instead of overwriting, cut and insert, and swapping two columns.
All tutorials
Formulas & Functions
How to Use VLOOKUP in Excel: a beginner’s walkthrough
How to use VLOOKUP in Excel from a blank sheet: build the lookup table, write the formula piece by piece, copy it down, and fix #N/A.
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.
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.
152 tutorials · Page 9 of 17
