AI Tip's PubAI Tip's Pub
← Back
PremiumEND USER3 min read

Analyze an Excel table in plain language

Copilot understands your table's context and analyzes it in plain language, then, if you let it edit, adds columns, dashboards and charts, on a new sheet if needed.

✅ How to

  1. 1Open your table in Excel (here, a Contoso budget tracker) and launch Copilot. It reads and understands the context: column headers, totals, execution rates, with no need to re-explain everything.
    Analyze an Excel table in plain language : étape 1
  2. 2Paste your request and let Copilot analyze: it surfaces trends, computes variances and suggests a fitting visualization.
  3. 3To have it edit the workbook (a variance-vs-target column, formatting, a chart), switch to “Allow Editing” / “Edit with Copilot”. It can create these on a new sheet so your original data stays untouched.
  4. 4Need a real dashboard? Just ask: Copilot assembles key metrics and charts on a dedicated sheet.
  5. 5Want to compare? You can play with models (GPT-5.6, etc.), but Auto mode is plenty for this kind of analysis.

⚡ Prompt to copy

Analyze this table: surface the top 3 trends, add a variance-vs-target column, and suggest a fitting chart. End with 3 recommendations.
💡

Two modes to know: stay in “Allow Editing” (Edit with Copilot) when you want Copilot to change the workbook (columns, charts, dashboards). If you only want to analyze, audit or discuss the open document without touching it, prefer “Chat Only” mode.

#excel#analyse#données#reporting#dashboard

💬 Comments

No comments yet. Be the first!

✨ Discover more

NewPremium

Build an executive dashboard from an Excel file

A dense workbook spread across several sheets? Ask Copilot for a single “Executive Dashboard” sheet: it analyzes all your data and assembles KPIs, tables and charts so an executive grasps the situation at a glance.

END USER3 min read
Premium

Track your Copilot rollout with Copilot Dashboard

To steer adoption, the Copilot Dashboard (enabled via Viva Insights) is the best fit: track Copilot Chat and Microsoft 365 Copilot, per app and more granularly than the native reports.

IT PRO5 min read
NewPremium

Create an Outlook rule with Copilot

No more digging through Outlook's rules menus: tell Copilot what you want to automate in plain language, and it creates the rule for you. Here's the principle, several concrete video examples, where to find your rules, and the few limits to know.

END USER5 min read