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.
All tutorials
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.
Dates & Times
Excel WEEKDAY: day of the week from a date
Get the day of the week in Excel: WEEKDAY for a number, TEXT for the name, flag weekends, and count working days with NETWORKDAYS.
Dates & Times
Get the Month from a Date in Excel: number or name
Get the month from a date in Excel as a number with MONTH, as a name with TEXT, and group a whole column by month for totals.
Formulas & Functions
Excel LEN Function: count characters in a cell
The Excel LEN function counts characters — use it to find cells that are too long, spot hidden spaces, and check codes are the right length.
Sorting, Filtering & Lists
Excel Unique Values: list each item once
Get a list of unique values in Excel three ways: the UNIQUE function, Remove Duplicates on a copy, and Advanced Filter for older Excel — plus counting them.
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.
Excel Basics
Excel Cheat Sheet: shortcuts, formulas and menus on one page
A one-page Excel cheat sheet: the 15 shortcuts, 12 formulas and 8 menu paths that cover a normal working day, each linked to its lesson.
Formatting
Highlight a Whole Row Based on One Cell’s Value in Excel
Highlight an entire row in Excel when one cell says Late, is over a number, or matches a date — one conditional formatting formula and the $ that makes it work.
152 tutorials · Page 10 of 17
