- Latestly AI
- Posts
- 📊 How to analyze any spreadsheet with AI, and check every number it gives you
📊 How to analyze any spreadsheet with AI, and check every number it gives you
Upload a sheet, ask three questions, get a one-page summary of what changed and why.

Lowest error rate on real dictation. Ahead of Google, OpenAI
Speech models love clean lab audio. Your real prompts don't sound like that. So Wispr Flow tested its in-house speech model, Canto, on 10 hours of real dictations from 2,300+ speakers.
The result: the lowest word error rate of every model tested, including models from Google, OpenAI, AssemblyAI and Deepgram. It also tied for the lowest error rate on LibriSpeech, a standard public benchmark.
For you, that means fewer fixes and longer, richer prompts. Speak your context, constraints and examples into ChatGPT or Claude, and Wispr Flow turns it into clean text in any app. Works on Mac, Windows, iPhone and Android.
🎁 $1,000+ in free AI tools. Access Offers
👋 Welcome to AI at Work
This is the second edition of our new Thursday newsletter.
Every Thursday, you’ll get one practical way to use AI at work, ready to try that day:
⚡ One work upgrade: a better way to handle a task you already do
📋 One prompt to steal: copy, paste and use
📰 Workplace AI news that changes how you work
🧰 Tools worth trying
Short, practical, and readable in about five minutes.
Got a task you’d like us to fix? Hit reply and tell us. We read every message.
AI AT WORK
Work Smarter. Get More Done.
⏱ 5–6 min read
Your manager asks, “What happened with sales last month?” You have the data: 2,000 rows, twelve columns, three tabs.
What you don’t have is two hours to build pivot tables. Today’s upgrade turns any spreadsheet into a clear one-page answer, with numbers you can check.
⚡ THE WORK UPGRADE
📊 Ask your spreadsheet what changed. Get a one-page answer you can trust.
The problem
Most data at work sits in spreadsheets nobody has time to analyze. You scroll, filter, build a chart, then lose track of what you were looking for.
So decisions get made on gut feeling, or the report arrives a week late.
The better way
The AI built into your spreadsheet can now do the first pass for you. Copilot in Excel and Gemini in Google Sheets let you use prompts in your own words to analyze data, generate formulas, create visualizations, and make changes to your spreadsheet. zapier
The trick is how you ask. Don’t ask for “insights.” Ask three specific questions, and make the AI show its calculations.
Before vs. after
Example: monthly sales by product and region.
Before: you build three pivot tables, make a chart, and still aren’t sure why the West region dropped.
After: you ask what changed, what drove it, and what looks unusual. You get a short summary, the formulas behind each number, and one flagged outlier to check.
How to apply it
Prepare one clean table. One header row, one row per record, a clear date column. Remove names, emails and other personal data.
Ask three questions, in this order:
What changed most compared to the previous period?
What is driving that change?
What looks unusual or worth checking?
Make it show its work. Ask for the formula or calculation behind every number it reports.
Spot-check three numbers yourself before you share anything.
The catch
AI can pick the wrong column, miss rows, or describe a number that doesn’t exist. Microsoft now has Copilot highlight the data range it picked, so you can catch a wrong guess before it writes a formula against the wrong data.
Your safeguard: never share a number you haven’t traced back to a formula or a cell.
Useful link: Google’s guide to analyzing data with Gemini in Sheets covers what you can ask, including generating data analysis and insights, and having Gemini review a formula when a cell shows an error. google
📋 STEAL THIS PROMPT
ROLE
You are a careful business analyst. You explain data clearly
to busy managers.
OBJECTIVE
Analyze the attached table and write a one-page summary of what
changed and why.
INPUTS
Data: [ATTACH OR SELECT THE TABLE]
Period to compare: [e.g. October vs. September]
What I care about most: [e.g. revenue by region]
RULES
Calculate every number with a formula or code. Never estimate.
Show the formula or calculation next to each number.
Tell me which columns and rows you used.
If data is missing or unclear, say so. Do not guess.
Short sentences. No jargon.
OUTPUT FORMAT
Headline: the single most important change (one sentence)
Top 3 changes, each with the number and its calculation
What is driving them (only if the data shows it)
One thing that looks unusual and should be checked
One suggested chart
Questions I should ask before deciding anything
Use it for: monthly sales reviews, budget checks, survey results, or any export you need to explain quickly.
Expected output: a summary that fits on one screen, where every number has a formula you can check and every gap is named instead of guessed.
🧰 TOOLS THAT ACTUALLY HELP
✦ Latestly partner or affiliate. We may earn from some links. Everything here is selected because we think it is genuinely useful.
Gemini in Google Sheets
Ask questions about your sheet, generate formulas and fix formula errors from a side panel.
Best for: a fast first look at any export before a meeting.
See what you can ask →
✦ SoftSync
A CRM you run from inside Claude or ChatGPT. Ask for pipeline numbers, open deals or last contact dates in one sentence. Latestly readers get 30% off plus a 30-day trial with code FOUNDER30SSX.
Best for: sales numbers you’d otherwise export to a spreadsheet.
Try SoftSync →
Gemini for BigQuery data in Sheets
After connecting to BigQuery data with Connected Sheets, you can use Gemini to analyze that data conversationally, right in Google Sheets.
Best for: teams whose data is too big for a normal spreadsheet.
Explore the feature →
🤝 FROM OUR PARTNERS
Offers from the companies that help keep Latestly AI free.
📋 Monday.com: run every project from one place
Move project tracking out of scattered spreadsheets into one workspace your whole team can see, update and report on.
Try Monday.com →
📊 Smartsheet: spreadsheets built for projects
Plan projects with tasks, owners and dates in a familiar spreadsheet view, with automations that keep everyone on track.
Try Smartsheet →
📱 T-Mobile for Business: $10,000 in savings on 10 lines
New accounts that add 10 lines on SuperMobile save $1,000 per line, applied as 36 monthly bill credits.
Claim $10,000 in Savings →
For new accounts that add at least 10 lines on SuperMobile. US only.
✦ Sponsored. We may earn from these links. Offers are the providers’ own terms, so check each site before you sign up.
See the GTM Stack Behind Pebl’s Handoff
In global employment, the sale is only the start. Customers stay or leave based on what happens after signature.
At The GTM Garage, Pebl’s Chief Business Officer, Dutta Satadip, walks through the tools behind prospecting, pipeline, and handoff to onboarding, and how Pebl uses AI across the customer lifecycle.
15 min conversation. 15 min open Q&A. For Seed to Series A teams.
💬 LATESTLY AI TAKE
Spreadsheet skill used to mean knowing formulas. Now the formulas write themselves.
The skill that matters is asking the right question, then checking the answer. AI makes analysis faster, but it doesn’t make it true.
The people who stand out won’t be the fastest analysts. They’ll be the ones whose numbers are always right.
Sources: Google Workspace Updates, Google Docs Editors Help, Android Authority, Powerdrill, Bluehost, Zapier, MyExcelOnline, Tech Insider, Microsoft (as reported by Powerdrill), SoftSync. Partner offers (Monday.com, Smartsheet, T-Mobile for Business) are the providers’ own terms, so check each site before you sign up. Data as of November 12, 2026. Product claims are the vendors’ own. Not legal advice. Latestly AI is independent. Sponsored content clearly labelled. No undisclosed paid placements.
We hope you enjoyed this Latestly AI edition.
📧 Got an AI tool for us to review or do you want to collaborate?
Send us a message and let us know!
Was this edition forwarded to you? Sign up here
Latestly AI is now operated by GHE Operating Company II LLC (174 Good Hope Road, Bluffton, SC 29909), which is responsible for your subscriber data.


