Charts
Excel Chart Types: which one to use for what (with examples)
The Excel chart types that matter — column, bar, line, pie, scatter, stacked, combo, Gantt — and a one-line rule for choosing each.
Author: Srini Vanamala
Dates & Times
Years Between Two Dates in Excel (whole years, or decimal)
Calculate years between two dates in Excel: whole years with DATEDIF, decimal years with YEARFRAC, years and months together, and service length for a list.
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.
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 Won’t Open? Fix it in this order
Excel won't open, 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.
152 tutorials · Page 4 of 17
