Agents in action

Working with Microsoft Copilot

Susanth Sutheesh

Copilot Solution Engineer, Microsoft

Analyst Agent overview

The Agent Store in Copilot, showing Researcher and Analyst among the built-in agents

Working with Microsoft Copilot

Analyst Agent overview

The Agent Store in Copilot, with the Analyst agent highlighted among the built-in agents

Working with Microsoft Copilot

Analyst Agent overview

 

Which region has shown the fastest growth compared to last quarter?

  • Best with structured data like spreadsheets or CSVs
  • Enables precise insights, e.g., growth comparisons
  • Ask business questions in plain language; Copilot handles analysis

 

A structured spreadsheet - Registrations.xlsx with Region, Sign-ups, and Growth columns - captioned "structured data leads to precise analysis"

Working with Microsoft Copilot

Analyst Agent example

$$

Upload data and ask for analysis with reasoning:

Find the top 3 regions by total registrations and show them in a chart. Walk me through your reasoning.

  • Groups the data and builds the chart - no formula written
  • Shows its reasoning steps, so you can defend the number in the meeting

The Analyst agent's regional breakdown, with its reasoning steps shown above the ranked table

Working with Microsoft Copilot

Researcher Agent overview

 

  • The Researcher Agent gathers in-depth information from your files
  • It extracts precise details from documents and presentations
  • Goes beyond summarization to provide deeper analysis

 

A document being examined by a magnifier, extracting "precise details" and "deeper analysis"

Working with Microsoft Copilot

Researcher Agent overview

 

 

Diagram: many sources feed a Researcher agent that returns a cited answer

 

 

  • Connects ideas across files to reveal gaps and themes
  • Powers strategic tasks like planning and messaging
  • Acts as a business analyst Copilot, delivering real insights
Working with Microsoft Copilot

Researcher Agent example

 

Give Researcher an open-ended question:

Research the reusable water bottle market: 2026 trends, main competitors, and what buyers care about. Cite sources.

 

The Researcher agent working through its transparent multi-step research plan

Working with Microsoft Copilot

Let's practice!

Working with Microsoft Copilot

Preparing Video For Download...