Charts
Excel Chart Title from a Cell (a title that updates itself)
Link an Excel chart title to a cell so it updates when the cell changes — including a title built from a formula with the month or total inside it.
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
Fixes & Errors
Excel Number Stored as Text: what the green triangle means and how to fix it
What 'Number Stored as Text' means in Excel, why it breaks SUM and lookups, the one-click fix, the fix for thousands of cells, and how to keep leading zeros on purpose.
Pivot Tables & Tables
Pivot Table Calculated Field in Excel: add a formula column to a pivot
Add a calculated field to an Excel pivot table — profit from revenue and cost, margin %, price per unit — edit it, and know the case where it gives the wrong answer.
Dates & Times
How to Calculate Hours Worked in Excel (timesheet with breaks and overtime)
Calculate hours worked in Excel from start and end times, subtract a break, total a week correctly past 24 hours, convert to decimal for pay, and add overtime.
Print, Share & Protect
Protect Certain Cells in Excel (lock some, leave the rest open)
Protect only certain cells in Excel — formulas or headings — while everything else stays editable: unlock all, lock the few, protect the sheet.
Charts
How to Switch the X and Y Axis in an Excel Chart
Switch the X and Y axis in Excel: Switch Row/Column for bar and line charts, swap the series values for a scatter plot, and flip a bar chart's direction.
Dates & Times
Get the Quarter from a Date in Excel (Q1–Q4, and fiscal quarters)
Get the quarter from a date in Excel with one formula, show it as Q3 2026, handle a fiscal year starting in April, and total sales by quarter.
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.
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.
Showing 163–171 of 294 tutorials · Page 19 of 33
