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.
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
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.
Excel Basics
How to Make a Budget in Excel (simple monthly budget, step by step)
Make a monthly budget in Excel from a blank sheet: income, expense categories, planned vs actual, what's left, and a bar that shows overspending.
Dates & Times
Convert Text to Date in Excel: 3 fixes that always work
Convert text to real dates in Excel with Text to Columns, DATEVALUE, or DATE with pieces — for dd/mm/yyyy, 20260929, and dates with dots.
Showing 181–189 of 294 tutorials · Page 21 of 33
