Productivity Guides
Practical, step-by-step guides to build productivity skills you can apply at work.
37 Guides
AI Tools for Data Analysis: A Beginner's Workflow
How to use ChatGPT, Copilot, and Claude for real data work — clean data, write SQL, and build reports. A practical workflow with prompts and guardrails.
Copilot in Excel: Practical Data Cleaning Workflows
What Copilot in Excel actually does well, where it quietly fails, and the prompts that turn messy columns into clean tables and real answers.
Excel Advanced Charts: Combo, Waterfall, Profit-Loss
Build combo, waterfall, and profit-loss charts in Excel. Show variance and running totals the way finance teams expect.
Excel Conditional Formatting: Make Your Data Talk
Turn a wall of gray numbers into a report your boss reads in five seconds. Color scales, data bars, icon sets, and formula rules with recipes.
Excel Conditional Formatting Advanced: Rules That Scale
Beyond the presets, Excel conditional formatting builds rules that scale. Flag outliers and trends across whole tables.
Excel Date Functions: EDATE, EOMONTH, NETWORKDAYS
Excel EDATE, EOMONTH, and NETWORKDAYS handle month-ends and working days. Build a project timeline and a payroll day count.
Excel Drop-Down Lists & Data Validation: Step by Step
Stop typing the same values repeatedly. Build Excel drop-down lists with data validation, create dependent lists, and keep spreadsheets error-free.
Excel Dynamic Arrays Explained: Spill Ranges and #SPILL!
Dynamic arrays changed how Excel formulas work. Understand spill ranges, the #SPILL! error, and implicit intersection with clear examples.
Excel FILTER: Extract Rows by Condition
The Excel FILTER function pulls rows that match a condition into a spill range. Learn the syntax with a real sales table you can copy today.
Excel Formula Errors: Fix #N/A, #VALUE! and #REF!
Why Excel throws #N/A, #VALUE!, #REF!, #DIV/0! and #NAME?, what each one actually means, and the fastest way to fix it without rebuilding your sheet.
Excel GROUPBY and PIVOTBY: Reports Without PivotTables
Excel GROUPBY and PIVOTBY build pivot-style reports with formulas. No PivotTable dialog, just live spill ranges.
Excel IF and IFS: Nested Logic Without the Pain
Excel IF and IFS test conditions without unreadable nested stacks. Replace five IFs with one IFS on a grading example.
Excel Data Import: CSV, PDF, and Web into Sheets
Get data into Excel from CSV, PDF, and the web with Power Query. Stop retyping and build refreshable imports.
Excel LAMBDA: Write Your Own Reusable Formulas
Excel LAMBDA turns a formula into a named, reusable function. Build a clean margin calculator and stop copy-pasting logic.
Excel Named Ranges: Readable, Robust Formulas
Excel named ranges make formulas readable and resistant to breakage. Name a rates table and watch your model get clearer.
Excel Not Responding or Running Slow: Real Fixes That Work
Excel freezing, hanging, or crawling on large files? These 9 fixes target the actual causes — volatile formulas, bloated ranges, add-ins — not guesswork.
Excel Pivot Tables Advanced: Calculated Fields and Slicers
Go beyond the basics with Excel pivot tables: calculated fields, grouping, and slicers that make reports interactive.
Excel Power Query for Data Transformation: A Practical Guide
Power Query cleans and reshapes messy data before it ever hits your sheet. Learn to combine, unpivot, and transform data with repeatable steps.
Excel SEQUENCE: Number Series and Date Ranges
Excel SEQUENCE builds number series and date grids with one formula. Build a 12-month calendar and an invoice numbering column.
Excel Shortcuts You Should Know
50 keyboard shortcuts that save 2+ hours per week. Copy the cheat sheet and start using them on Monday.
Excel SORT and SORTBY: Reorder Data Live
Excel SORT and SORTBY reorder ranges live as source data changes. See worked examples with a product list and a by-column sort.
Excel Spill and Dynamic Array Troubleshooting
Dynamic array formulas throw #SPILL! for clear reasons. A troubleshooting path for blocked spills and unexpected outputs.
Excel Tables and Structured References
Excel Tables turn ranges into smart objects. Use structured references that survive column inserts and auto-expand.
Excel TEXT, TEXTJOIN, and CONCAT: Format and Merge Text
Format dates and merge cells with Excel TEXT, TEXTJOIN, and CONCAT. Build clean labels and report headers from raw columns.
Excel UNIQUE: Distinct Values in One Formula
Excel UNIQUE returns distinct values from a range in one formula. List categories, customers, or regions without manual de-duplication.
Excel VBA Automation for Beginners: Repetitive Tasks
Write your first Excel macro without being a programmer. Learn the VBA basics, record a macro, and automate the tedious reporting you do weekly.
Excel What-If Analysis: Goal Seek, Data Tables, Scenarios
Excel What-If tools reverse-engineer targets. Use Goal Seek, Data Tables, and Scenario Manager on a pricing model.
Excel XLOOKUP: The Modern VLOOKUP Replacement
XLOOKUP replaces VLOOKUP and fixes its biggest headaches: it looks left, defaults to exact match, and handles missing values cleanly. See real examples.
Google Sheets ARRAYFORMULA and QUERY
Google Sheets ARRAYFORMULA and QUERY bring Excel-style power to Sheets. Apply formulas to whole columns and pull filtered datasets.
Google Sheets Tips That Will Save You Hours Each Week
Eight Google Sheets tricks that turn a 45-minute repetitive task into a one-minute formula. Conditional formatting, QUERY, IMPORTRANGE, named ranges, and more.
Google Sheets vs Excel
Which one should you learn first? An honest comparison based on features, jobs, and price.
How to Use Pivot Tables
Summarize thousands of rows in seconds. The definitive pivot table cheat sheet.
How to Use VLOOKUP
Look up data across tables like a pro — with examples you can copy.
INDEX-MATCH vs XLOOKUP vs VLOOKUP: Which to Use and When
Three lookup functions, one job. See a side-by-side comparison, the exact cases each wins, and the modern recommendation for 2026.
REGEX in Excel: REGEXTEST, REGEXEXTRACT and REGEXREPLACE
Excel now has three regex functions. Learn the patterns that solve real cleanup jobs — emails, phone numbers, SKUs — with copy-ready formulas.
Remove Duplicates in Excel: 5 Methods Compared
Five ways to remove duplicates in Excel, from the built-in button to Power Query and a formula check — plus which one keeps your first or last record.
Excel SUMIFS and COUNTIFS: Aggregation That Scales
SUMIFS beats SUMIF the moment you need two conditions. Learn the syntax rules, the date traps, and the array tricks that replace helper columns.