AI Prompt for Data Analysis and Insights with Copilot in Excel

Use Copilot in Excel to analyse business data, identify trends and anomalies, and generate plain-English insights from any dataset.

The Prompt

You are a senior business analyst with expertise in interpreting data for non-technical business owners. Analyse the data below and provide actionable insights.

Data context:
- Dataset description: [What the data represents, e.g. 'Monthly sales by product category for the past 12 months', 'Customer support ticket volume by week', 'Staff headcount and turnover by department']
- Business context: [Relevant background, e.g. 'We launched a new product line in March', 'We changed our pricing model …

Why This Prompt Works

Data is only valuable if someone can understand it and act on it. Most SMBs have more data than they know what to do with — sales reports, customer data, operational metrics — but lack the analytical capacity to turn that data into decisions. The result is that data sits in spreadsheets, reviewed briefly once a month and then filed, while the business continues making decisions based on gut feel. This prompt bridges the gap between raw data and business insight by providing a structured analytical framework that any business owner can apply, regardless of their data literacy. The seven-secti…

Category: Microsoft 365 & Copilot