Excel Data Trend Finder

Analyse spreadsheet data and identify the top trends, patterns, and anomalies

🧪 Tested by a human Intermediate 👤 Finance 👤 Manager 👤 Marketing
Analyse this data and identify: (1) The top 3 trends over the time period shown, (2) Any anomalies or outliers that stand out, (3) A comparison between the highest and lowest performing categories, (4) A brief recommendation based on the patterns. Present your findings with specific numbers and percentages. Use a clear, executive-summary style.

Works on

⭐ M365 Copilot (Best) 🟢 ChatGPT 🟠 Claude 🔵 Gemini

Copy & Open in

🟢 ChatGPT 🟠 Claude 🔵 Gemini

Prompt is copied to your clipboard when you click

Tips for Best Results

  • In M365 Copilot (Excel), select your data range first, then use Copilot — it reads the spreadsheet directly
  • In ChatGPT, paste data as a table or upload a CSV file
  • In Claude, you can paste large datasets — it handles long context well
  • Be specific about the time period: “monthly over the last 12 months” gives better results than just “over time”

Variations

Sales Focus

Analyse this sales data and provide: (1) Month-over-month growth rate, (2) Best and worst performing products/regions, (3) Seasonality patterns, (4) Revenue forecast for next quarter based on current trends.

Survey Results

Analyse these survey responses and provide: (1) Key themes from open-text responses, (2) Statistical breakdown of rating questions, (3) Correlation between satisfaction and specific factors, (4) Top 3 actionable recommendations.

📎 More Prompts

Budget Variance Analysis

●●
Analyse this budget data comparing actual spend versus budgeted amounts. For each line item: (1) Calculate the variance (actual minus budget) and variance percentage, (2) Flag any variances greater than 10% as significant, (3) Categorise variances as Favourable or Unfavourable, (4) Suggest possible reasons for the top 5 largest variances, (5) Provide a summary with total budget utilisation percentage. Format as a table with colour-coded indicators.
⭐ M365 🟢 GPT 🔵 Gemini

Correlation Finder

●●●
Analyse for correlations between [VARIABLES]. For each significant one: (1) State the relationship, (2) Strength, (3) Direction, (4) Possible explanations, (5) Caveats. Create a correlation matrix.
⭐ M365 🟢 GPT

Dashboard Metrics Design

●●
Define metrics for a [PURPOSE] dashboard. For each metric: name, definition, data source, calculation, target, frequency, owner, and why it matters. Limit to 8-10 KPIs.
⭐ M365 🟢 GPT 🟠 Claude
💬