Turning data into insights

Working with Microsoft Copilot

Susanth Sutheesh

Copilot Solution Engineer, Microsoft

Why Excel and Visual Reasoning?

Visual reasoning: turning numbers into a table, chart or summary you can think with
Copilot reads your data and works out the analysis
It writes the formulas and builds the charts for you

A table of raw regional sign-up numbers turning into a clean bar chart, showing how Copilot converts numbers into a clear visual

It can also:

Diagram: your spreadsheet feeds an Analyst agent that returns an insight and a chart

In the Copilot app, with the file attached

Upload your data, then ask for a summary:

Using the attached file, show total registrations by region as a summary table

Copilot's summary table of registrations by region

Refine the table into a chart:

Now show that as a bar chart, sorted from highest to lowest

Copilot's sorted bar chart of registrations by region

A progression from a summary table to a sorted chart to a short narrative

A side-by-side comparison: Word and PowerPoint take text-only instructions, while Excel lets you point Copilot at a table or range

Illustration of a green Excel sheet showing labeled columns for Region, Sales, and Profit, symbolizing clear data organization

Working with Microsoft Copilot