Agents · Lesson 01
Pro
~11 min read
Multi-source research
Researcher: the analyst on your team.
Researcher is one of two flagship named agents Microsoft shipped in Copilot Chat (the other is Analyst). It synthesizes information from your work data — emails, SharePoint, Teams, OneDrive — alongside the web, and produces full reports. Think Deep Research, but with access to your company's context.
Workflow 01 Internal-aware competitive analysis
1
Use Researcher to pull from your work data + the web
The killer Researcher pattern: ask a question that requires both external context and your internal knowledge.
The prompt that works
Hybrid researchRun a competitive analysis on [Competitor X] for our upcoming customer meeting. Use both web sources and our internal data:
From the web: their public positioning, pricing (if listed), product changes in the last 6 months, analyst coverage, recent funding or layoffs.
From our SharePoint and Teams: any sales notes mentioning them in the last 90 days, the competitive battlecard from product marketing, any customer feedback comparing us to them.
Produce a structured report:
- Their current positioning vs. ours
- Top 3 strengths they have (from web + customer feedback)
- Top 3 weaknesses we can lean into
- 3 concrete talking points for the customer meeting
Cite every internal source by document name and last-modified date.
Best use cases
- Competitive analysis for sales conversations
- Market research informed by your CRM
- Strategy memos blending internal data + external context
- Prep for executive briefings
Researcher can only see what your M365 permissions allow. If a SharePoint site is restricted, Researcher can't read it — that's correct behavior, but means some sources may be invisible.
Time savings: A real competitive analysis: 4-6 hours analyst time → 20 min Researcher + review.
Workflow 02 Long-form internal report production
2
Quarterly business review draft, generated from your data
Researcher excels at multi-document synthesis. When you need to pull together a coherent narrative from scattered sources, it's the right tool.
The prompt that works
QBR draftDraft our Q1 business review for the leadership team. Pull from:
- Our Q1 financials in SharePoint (file: Q1-2026-Financials.xlsx)
- Sales pipeline reports in our 'Sales Ops' team site
- Customer success quarterly review in 'CS Team' site
- Engineering velocity metrics from our 'Eng Ops' Teams channel
- Our written Q1 strategy doc from leadership SharePoint
Structure the report:
- Executive summary (1 page)
- Financial performance vs. plan
- Sales: pipeline, wins, losses
- Customer outcomes: NPS, churn, success stories
- Engineering progress vs. roadmap
- Strategic risks identified this quarter
Match the voice of last quarter's review (also in SharePoint, file: Q4-2025-Review.docx).
Best use cases
- Quarterly or monthly business reviews
- Board reports drafted from data sources
- All-hands prep covering multiple functions
- Investor updates pulled from your real data
Researcher's output is a draft. Always review numbers manually — if it misread a cell label in your financials, the wrong number flows through the whole report.
Time savings: QBR draft: 1-2 days of work → 1-2 hours including human review.
Workflow 03 Decision-support research
3
A specific question, all relevant sources
Sometimes you need an answer informed by context, not a research report. Researcher in 'specific question' mode is fast and concrete.
The prompt that works
Decision supportShould we approve the budget request from Marketing for the conference sponsorship?
Pull from:
- The request itself (email from [name], date [date])
- Our last 4 quarters of marketing spend ROI data
- Past conference sponsorships and outcomes (in SharePoint marketing folder)
- Industry benchmarks for B2B conference sponsorship ROI
Don't tell me yes/no — give me:
- The 3 strongest reasons in favor
- The 3 strongest reasons against
- The 1 data point that should drive the decision
- 2 questions to ask Marketing before approving
Best use cases
- Budget approval prep
- Vendor selection support
- Hiring decision context
- Go/no-go on strategic projects
Researcher will respect a 'don't tell me yes/no' instruction. If you want a recommendation, ask for one explicitly.
Time savings: Decision context gathering: 30-60 min → 5 min.
Researcher accessGenerally available in Microsoft 365 Copilot as of June 2025. Requires a Copilot for Microsoft 365 license. Available in Copilot Chat — invoke by selecting 'Researcher' from the agent picker or by prompting with research-focused phrasing.
Run one Researcher task that uses both internal + external sources
Pick a real decision or report you owe someone this week. Frame it as a Researcher prompt that requires both your company's data AND web context. Compare the time and quality to what you'd produce manually.
What you can do now
- Use Researcher for tasks needing both internal + external context
- Cite internal sources by name so you can verify
- Always review numbers from financial or data sources manually
- Frame multi-document syntheses as structured reports, not vague asks
- Know that permission boundaries are enforced — some sources invisible to it
Pro
Up next in Copilot Mastery
Lesson 02 · Analyst — turn data into insight
Analyst is Researcher's sibling agent — focused on quantitative work. Excel-heavy analysis, charts, statistical insight, all from natural language prompts. See the track →