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.
The Excel chart types that matter — column, bar, line, pie, scatter, stacked, combo, Gantt — and a one-line rule for choosing each.
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.
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.
Calculate compound interest in Excel with the plain formula, with FV, with monthly compounding, with monthly deposits, and build a year-by-year table.
Excel keeps crashing or closing itself: update Office, disable add-ins, turn off hardware acceleration, repair the file, clear conditional formatting, repair Office.
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.
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.
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.
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.
One short Excel lesson in your inbox every morning. Free, no spam, unsubscribe any time.
Also join us on Facebook