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.
All tutorials
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.
Pivot Tables & Tables
Pivot Table Count Unique Values in Excel (Distinct Count)
Count unique values in an Excel pivot table with Distinct Count — the one tick box when you create the pivot — plus the helper-column way for older Excel.
Import, Export & Convert
Excel to Word: paste a table that looks right (and stays linked)
Get an Excel table into Word three ways: paste as a Word table, paste as a picture, or paste a link that updates when the spreadsheet changes.
Import, Export & Convert
Excel to JSON: convert a sheet to JSON in 3 ways
Convert Excel to JSON with a formula that builds each row, with Power Query for clean output, or with a free converter — and the shape developers expect.
Excel Basics
How to Hide Rows in Excel (and unhide them)
Hide rows in Excel with Ctrl+9, hide every row that matches a filter, unhide one or all, and use Group to collapse sections instead.
Print, Share & Protect
Protect a Sheet in Excel: stop accidental edits in 3 clicks
Protect a sheet in Excel so cells cannot be changed, allow specific cells to stay editable, choose what users may still do, and unprotect.
Charts
Excel Scatter Plot: see if two things are related
Make a scatter plot in Excel, add a trendline and its equation, label the points with names, and read what the pattern means.
Print, Share & Protect
How to Print Gridlines in Excel (and why they sometimes won’t)
Print gridlines in Excel with one tick box, print them for part of a sheet, use borders when gridlines won't print, and fix the greyed-out option.
152 tutorials · Page 5 of 17
