Search
20 results for spreadsheets
-
Keyboard Shortcuts That Actually Matter in Spreadsheets
The two dozen shortcuts worth memorizing, ordered by time saved, for navigating, selecting, entering, and auditing data.
-
Build a Pivot Table From Scratch in Under Ten Minutes
Step-by-step construction of a pivot table from raw transactional data, including refresh hygiene and layout choices.
-
Chart Design Rules That Make Spreadsheet Charts Readable
Practical rules for choosing chart types, ordering data, and stripping decoration so charts communicate in seconds.
-
Build Conditional Formatting Heatmaps in Excel and Sheets
Turn a table of numbers into a readable heatmap using color scales, custom rules, and icon sets done right.
-
Dropdown Data Validation Lists That Stay Maintainable
Create dropdown lists from named ranges and tables so options update everywhere without touching each cell.
-
INDEX/MATCH vs VLOOKUP: When and Why to Switch
A practical comparison of VLOOKUP and INDEX/MATCH with rules for choosing the right lookup for your sheet.
-
Protect Sheets but Let Colleagues Edit the Right Cells
Lock formulas and structure while leaving input cells open, using unlocked ranges and sheet protection correctly.
-
Migrate VLOOKUP and HLOOKUP Formulas to XLOOKUP
Replace legacy VLOOKUP and HLOOKUP formulas with XLOOKUP, including left-lookups, defaults for misses, and multi-column returns.
-
Optimize charts that persuade, explained simply — On a budget
A no-nonsense walkthrough to optimize charts that persuade: prerequisites, exact steps, verification, and the failure modes people hit.
-
The quick-start guide to Back up data validation — With what you already own
A no-nonsense walkthrough to back up data validation: prerequisites, exact steps, verification, and the failure modes people hit.
-
How to Script a budget template
A no-nonsense walkthrough to script a budget template: prerequisites, exact steps, verification, and the failure modes people hit.
-
Automate macros safely, explained simply
A no-nonsense walkthrough to automate macros safely: prerequisites, exact steps, verification, and the failure modes people hit.
-
The quick-start guide to Harden data validation — That actually lasts
A no-nonsense walkthrough to harden data validation: prerequisites, exact steps, verification, and the failure modes people hit.
-
Back up pivot tables: a practical guide — Without expensive tools
A no-nonsense walkthrough to back up pivot tables: prerequisites, exact steps, verification, and the failure modes people hit.
-
Optimize pivot tables: a practical guide — That actually lasts
A no-nonsense walkthrough to optimize pivot tables: prerequisites, exact steps, verification, and the failure modes people hit.
-
Set up named ranges: a practical guide — With what you already own
A no-nonsense walkthrough to set up named ranges: prerequisites, exact steps, verification, and the failure modes people hit.
-
Secure date arithmetic: a practical guide — Safely
A no-nonsense walkthrough to secure date arithmetic: prerequisites, exact steps, verification, and the failure modes people hit.
-
The quick-start guide to Set up named ranges — In 10 minutes a day
A no-nonsense walkthrough to set up named ranges: prerequisites, exact steps, verification, and the failure modes people hit.
-
How to Automate named ranges (without expensive tools)
A no-nonsense walkthrough to automate named ranges: prerequisites, exact steps, verification, and the failure modes people hit.
-
Back up a budget template without the fluff — For beginners
A no-nonsense walkthrough to back up a budget template: prerequisites, exact steps, verification, and the failure modes people hit.