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.
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
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.
Formatting
Excel Number Format: currency, thousands separator, decimals, negative in red
Excel number formats explained: currency, comma thousands separator, decimal places, percent, dates, and a custom format with negatives in red.
Formulas & Functions
Excel Subtract Formula: minus one cell from another
There is no SUBTRACT function in Excel — use the minus sign. Subtract two cells, a column from another, a fixed number, and dates.
Showing 226–234 of 294 tutorials · Page 26 of 33
