You are creating a custom analytics agent in the Microsoft 365 Copilot app. The agent will use Microsoft Excel files that contain sales data as knowledge. You need to ensure that the agent can…

Question

Options

• Aa suggested prompt
• Bcode interpreter
• Cimage generator
• Da template

• A
  72% (13)
• B
  6% (1)
• C
  11% (2)
• D
  11% (2)

Explanation

To get the most out of a custom analytics agent in Microsoft 365 Copilot for Excel sales data, use a structured prompt that defines the goal, context, and specific output format. For the best results, ensure your data is formatted as an Excel Table. Suggested Comprehensive Prompt "Analyze the sales data in this file to identify the top 5 performing products by total revenue and regional growth. Perform a mathematical operation to calculate a new column for 'Profit Margin' (Revenue minus Cost), then aggregate the total sales and average profit margin by 'Sales Representative' and 'Region.' Finally, create a professional dashboard on a new sheet featuring a bar chart for product revenue and a line graph showing monthly sales trends over the last 12 Breakdown of Prompt Capabilities Visualizations: Ask for specific chart types (e.g., "Visualize this as a bar chart" or "Create a line graph") to help spot trends. Mathematical Operations: Request new columns based on existing data (e.g., "Create a column for the difference between 'Projected' and 'Actual' sales"). Aggregations: Use natural language to summarize data (e.g., "Calculate the total sales by region") or generate PivotTables for deeper grouping. https://support.microsoft.com/en-us/office/get-insights-about-numerical-data-with-copilot-in-excel- 52d97339-86c0-431c-b46c-e7b07b2898dd

No community discussion yet for this question.