Get more out of your spreadsheets.
Practical, in-depth guides on asking the right questions, cleaning data, and the formulas worth knowing — written for people who use Excel every day.
- Guide11 min read
How to Chat With an Excel File Using AI
A practical guide to asking a spreadsheet questions in plain English: what AI can and can't answer, how to phrase questions, and how to check the results.
Read the guide - Guide9 min read
How to Analyze a CSV File With AI (No Formulas)
Turn a raw CSV export into answers in minutes: what to check before you upload, the questions that work, and how to verify AI results against the file.
Read the guide - Guide8 min read
How to Analyze Google Sheets Data With AI
Get AI answers from a Google Sheet: export the right way (CSV vs XLSX, which tab), what changes on the way out, and how to ask once it's loaded.
Read the guide - Charts8 min read
How to Make Charts From Excel Data With AI
Which chart answers which question, how to ask for one in plain English, and the aggregation step that separates a readable chart from a smear.
Read the guide - Data cleaning13 min read
How to Clean Messy Excel Data Before Analysis
Seven data problems that break spreadsheet analysis — placeholders, text numbers, mixed dates, total rows, duplicates, merged cells — and how to fix each fast.
Read the guide - Excel tutorial9 min read
How to Find and Remove Duplicates in Excel
Five ways to find duplicate rows in Excel — conditional formatting, COUNTIF, Remove Duplicates, UNIQUE, pivot tables — and how to decide which rows to keep.
Read the guide - Excel tutorial11 min read
How to Make a Pivot Table in Excel (Step by Step)
Build your first pivot table in five steps, then group by month, show % of total, add a slicer, and fix the three problems that trip up almost everyone.
Read the guide - Excel formulas12 min read
SUMIFS vs Pivot Table: Which Should You Use?
When SUMIFS beats a pivot table and when it doesn't, with the same sales data worked both ways — plus COUNTIFS, AVERAGEIFS, and the AI shortcut.
Read the guide - Excel formulas10 min read
XLOOKUP vs VLOOKUP: Syntax, Differences, and When to Switch
Side-by-side XLOOKUP and VLOOKUP with the same examples: exact match, left lookups, multiple criteria, if-not-found, and the errors each one throws.
Read the guide - Excel formulas9 min read
The 15 Excel Formulas That Do Most Data Analysis
A working reference to the formulas analysts actually use — SUMIFS, COUNTIFS, XLOOKUP, FILTER, UNIQUE, SORTBY, TEXT and date functions — with examples.
Read the guide - Ecommerce10 min read
How to Analyze a Shopify Orders Export (CSV)
What's in a Shopify orders CSV, the one-row-per-line-item trap, and twelve questions worth asking: repeat rate, AOV, top products, refunds.
Read the guide - Finance10 min read
How to Analyze a Stripe Payments Export in a Spreadsheet
Reading a Stripe payments CSV: amounts, statuses, fees, and refunds — plus the MRR, churn, and failed-payment questions you can answer in minutes.
Read the guide