Available with: Microsoft 365 Copilot for Finance
Finance scenario: Analyze business performance
Scenario
Make better decisions using Copilot for Finance
Aggregate budget and spend data into an Excel spreadsheet, then use Copilot for guidance on how to standardize the data formatting.

Copilot in Excel
Example prompt: Suggest formulas to standardize the data formatting, including removing trailing spaces and correcting capitalization.
Use Copilot for Finance in Excel to streamline the variance analysis process, looking at actuals and budgeted figures.

Copilot in Excel
Copilot for Finance (Preview)
Action: Open Copilot for Finance in Excel and select Analyze variances. Define variance threshold.
Review the variance analysis summary report for any large or unexpected variances.

Copilot in Excel
Copilot for Finance (Preview)
Action: Review any budget variances using the threshold set in step 2.
Use Copilot in PowerPoint to accelerate the creation of a presentation summarizing key findings from the variance analysis summary.

Copilot in PowerPoint
Example prompt: Create a presentation from the following variance analysis summary [Paste summary].
Use Copilot in Outlook to draft an email summarizing the variance analysis summary. Attach the PowerPoint and share with stakeholders.

Copilot in Outlook
Example prompt: Draft an email to stakeholders based on the following variance analysis summary.
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 Finance Scenarios
Finance 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