Available with: Microsoft 365 Copilot Chat
Financial Services scenario: Capital Markets – Research and summarize market trends
Scenario
Use Copilot Chat to research and summarize market trends
Analysts and teams can use Copilot Chat to swiftly research, summarize, and analyze key trends, enabling faster, data-driven decision making and customer support.
When a capital markets analyst receives a request to provide a summary of current market trends, sector movements, or economic drivers, using Copilot Chat can help expedite Web research, including citations to verify resource credibility.
Microsoft 365 Copilot Chat1
Sample prompt: “What are the key drivers affecting the bond market this quarter?”
The analyst uses Copilot Chat in Excel to ask questions about the best way to update a cash flow model to include the new inputs from the market research.
Microsoft 365 Copilot Chat1
Sample prompt: “Where in this cash flow model can I update the growth assumptions for each region?”
The analyst also needs to add some data to the model for new markets and asks Copilot for help in update the VLOOKUP equations to include the new data.
Microsoft 365 Copilot Chat1
Sample prompt: “Can you help me expand my VLOOKUP equations to include new data?”
The analyst creates some bullet points based on the research and Excel data. Copilot can create a report based on the bullet points.
Microsoft 365 Copilot Chat1
Sample prompt: “Draft a summary report based on the bullet point below.”
To anticipate client or team questions, the analyst also uses Copilot Chat to review a presentation and create a list of questions that people may have about it.
Microsoft 365 Copilot Chat1
Sample prompt: “What are some questions I may get asked during this presentation?”
1Access Microsoft 365 Copilot Chat at m365copilot.com, or the Microsoft 365 Copilot Chat mobile app and set toggle to “Web”.
2Access Microsoft 365 Copilot Chat at m365copilot.com, the Microsoft 365 Copilot Chat mobile app, or the Microsoft 365 Copilot Chat app in Teams, and set toggle to “Work”.
3AI Agents allow Copilot to access your organization-specific apps. In the past this would have required an API call to get data from a system of record.
The content in this example scenario is for demonstration purposes only. You should evaluate how Copilot aligns with your organization’s business processes, regulatory requirements, and responsible AI principles.
What's next
Explore more Financial Services Scenarios
Financial Services Scenario LibraryStart using Copilot
Go to the Copilot app to try a new scenario now. Everyone can start with Copilot Chat and if you are licensed Microsoft 365 Copilot connects to your work data and apps.
Start using CopilotView all downloadable content
Download our functional scenario kits, scenario guides, and day in the life guides to accelerate your Copilot implementation.
View downloads