Excel Basics
How to Hide Rows in Excel (and unhide them)
Hide rows in Excel with Ctrl+9, hide every row that matches a filter, unhide one or all, and use Group to collapse sections instead.
Category: Excel Basics
Excel Basics
How to Make a Budget in Excel (simple monthly budget, step by step)
Make a monthly budget in Excel from a blank sheet: income, expense categories, planned vs actual, what's left, and a bar that shows overspending.
Excel Basics
How to Add Columns in Excel: insert one, several, or between every column
Add a column in Excel with right-click or Ctrl+Shift+Plus, insert several at once, add one at the end of a table, and undo if it went in the wrong place.
Excel Basics
How to Insert a Checkbox in Excel (and count the ticks)
Insert a checkbox in Excel — the one-click way in Excel 365, the Developer-tab way in older versions, link it to a cell, and count how many are ticked.
Excel Basics
How to Hide Columns in Excel (and unhide them later)
Hide columns in Excel with a right-click or Ctrl+0, hide several at once, unhide them, and use Group instead when you hide and show often.
Excel Basics
How to Unhide All Rows in Excel (and columns) in one go
Unhide all rows in Excel with select-all and one shortcut, unhide columns the same way, and fix rows that stay hidden because of a filter or zero height.
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.
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.
Excel Basics
Excel Tips and Tricks: 15 small things that save an hour a week
Fifteen Excel tips and tricks most people never learn: Flash Fill, double-click fill, the status bar calculator, paste values, transpose, and more.
11 tutorials · Page 1 of 2
