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.
- 11 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 - 9 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 - 8 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
- 9 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 - 11 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
- 12 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 - 10 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 - 9 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
- 10 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 - 9 min read
How to Analyze Amazon Seller Central Reports in Excel
Business Reports, All Orders, and settlement reports from Amazon Seller Central: what the columns mean, the traps, and the questions worth asking.
Read the guide - 7 min read
How to Analyze Shopee and Lazada Order Exports
Export orders from Shopee and Lazada Seller Center, avoid the row-per-item and voucher traps, and get GMV by month, top SKUs, repeat buyers and net payout.
Read the guide
- 10 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 - 7 min read
How to Analyze a QuickBooks Online Export in Excel
Export QuickBooks Online reports to Excel, strip the subtotal and header rows, handle split transactions, then find spend by vendor, month and anomaly.
Read the guide
- 7 min read
ChatGPT for Excel Analysis: What Works and What to Watch
An honest look at using ChatGPT to analyze Excel and CSV files: where it shines, where it trips up, and when a dedicated spreadsheet chat tool fits better.
Read the guide - 7 min read
Copilot in Excel Alternatives: Who Each Tool Is For
What Microsoft Copilot in Excel needs and does well, where it's awkward, and the alternatives worth considering for asking questions of spreadsheets.
Read the guide - 8 min read
Best AI Tools for Excel in 2026: An Honest Roundup
Copilot, ChatGPT, Claude, Gemini, Julius, and ChatExcel compared by what they're built for, what they need, and how to pick one for your spreadsheets.
Read the guide