Dates & Times
Excel Week Number: WEEKNUM, ISO weeks, and grouping by week
Get the week number in Excel with WEEKNUM, the ISO week that matches most calendars, the week's start date, and totals per week with SUMIF.
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
Formulas & Functions
How to Calculate Compound Interest in Excel (formula and FV)
Calculate compound interest in Excel with the plain formula, with FV, with monthly compounding, with monthly deposits, and build a year-by-year table.
Fixes & Errors
Excel Keeps Crashing? 6 fixes, easiest first
Excel keeps crashing or closing itself: update Office, disable add-ins, turn off hardware acceleration, repair the file, clear conditional formatting, repair Office.
Fixes & Errors
Excel Not Opening? Fix Excel won’t open in this order
Excel not opening, or opens to a blank grey screen, or a file won't open — the fixes in order: safe mode, DDE setting, Open and Repair, add-ins, and Office repair.
Dates & Times
Add Months to a Date in Excel (EDATE, and end-of-month)
Add months to a date in Excel with EDATE, subtract months, land on the last day of the month with EOMONTH, and add years or days the same way.
Fixes & Errors
VLOOKUP Not Working? The 7 causes, in the order to check
VLOOKUP not working in Excel — #N/A, wrong value, #REF!, or the formula shows as text. Seven causes in the order to check, each with a 10-second fix.
Charts
Excel Chart with Two Y Axes (secondary axis in 4 clicks)
Put two series with different scales on one Excel chart using a secondary Y axis, label both axes, and fix bars that hide behind each other.
Dates & Times
How to Calculate Age in Excel from a Date of Birth
Calculate age in Excel from a birth date with DATEDIF: years only, years and months, age on a specific date, and why YEARFRAC rounds wrong.
Pivot Tables & Tables
GETPIVOTDATA in Excel: pull one number out of a pivot table
GETPIVOTDATA in Excel: what the formula Excel writes for you means, how to make it use a cell instead of fixed text, and how to turn it off if you just want =B5.
Showing 172–180 of 294 tutorials · Page 20 of 33
