Excel & Data

21 prompts in this category

The Excel Sales Analyzer

You are an expert sales performance analyst. I am sharing sales KPI data covering multiple regions and time periods. Analyze this data and produce the followin...

The Excel KPI Dashboard Designer

Design a comprehensive KPI dashboard in Excel for [DEPARTMENT OR TEAM] at [COMPANY NAME]. I am uploading [DESCRIBE THE DATA: SALES / EXPENSE / OPERATIONS DATA]...

The Forecasting Engine

You are a financial forecasting specialist. I am uploading historical sales/revenue data. Build a [NUMBER]-period forward forecast using the following approach...

The Excel Insight Generator

Analyze the uploaded dataset and generate a structured insights report. Dataset description: [DESCRIBE WHAT THE DATA CONTAINS] Business context: [WHAT DECISION...

The PwC Data Analysis Report Writer

You are a senior data analyst at a Big 4 consulting firm. I am uploading sales KPI data and revenue data for [COMPANY NAME]. Write a consulting-grade data anal...

Data Generator â†’ Insights

I am uploading a real dataset. Generate a structured analysis AND create an Excel template that can be reused for future data. Dataset: [DESCRIBE THE DATA] Bus...

Excel Formula Debugger

Debug and fix the following Excel formula issue. What I'm trying to do: [DESCRIBE THE GOAL] The formula I wrote: [PASTE YOUR FORMULA] The error or wrong result...

Pivot Table and Power Query Builder

Build a pivot table analysis and Power Query data transformation for the following data task. Data source: [DESCRIBE YOUR DATA SOURCE â€” FILE, DATABASE, OR PA...

Budget vs. Actuals Tracker

Build a budget vs. actuals tracking model in Excel for [DEPARTMENT OR COMPANY] for [FISCAL YEAR]. Budget context: - Total budget: [AMOUNT] - Budget categories:...

Customer Cohort Analysis Builder

Build a customer cohort retention analysis in Excel using the uploaded customer data. Data available: [DESCRIBE: CUSTOMER IDs, SIGN-UP DATES, ACTIVITY/PURCHASE...

Financial Model Auditor

Audit the following Excel financial model for errors, logic flaws, and best practice violations. Model description: [WHAT THE MODEL IS DESIGNED TO DO] Model ty...

Sales Commission Calculator Builder

Build a sales commission calculator in Excel for [COMPANY NAME]'s [ROLE: AE / SDR / CSM] compensation plan. Commission plan details: - On-target earnings (OTE)...

HR Headcount and Hiring Plan

Build a headcount and hiring plan model in Excel for [COMPANY NAME] for [FISCAL YEAR]. Context: - Current headcount: [NUMBER] - Planned net headcount growth: [...

Expense Report Analyzer

Analyze the uploaded expense data and produce a structured expense report analysis. Expense period: [DATE RANGE] Department or scope: [ALL COMPANY / SPECIFIC D...

SaaS Metrics Calculator

Build a SaaS metrics calculator and dashboard in Excel for [COMPANY NAME]. Business context: - Business model: [B2B SAAS / B2C SUBSCRIPTION / USAGE-BASED] - Cu...

Forecasting Model Builder

Build a forecasting model for [METRIC] based on this historical data. Include: 1) Trend analysis and seasonality detection, 2) Forecast for next [3/6/12] months...

Dashboard Insight Generator

Create an executive dashboard from this data including: 1) Top 5 KPIs with current value, trend (↑↓), and vs. target, 2) Alert indicators for metrics off-track ...

Data Quality Auditor

Audit this dataset for quality issues: 1) Missing values (count and % by column), 2) Duplicates or inconsistencies, 3) Outliers that may be errors vs. legitimat...

Data Storyteller

Analyze this dataset and tell the data story: 1) Key trends over time, 2) Notable outliers or anomalies with potential explanations, 3) Correlations or relation...

Table Data Extractor with Validation

You are extracting data from a table (image or text). Task: Extract table data into a structured format. Instructions: 1. Identify column headers (or describe...

JSON/XML Structure Generator

You are converting unstructured text into structured data. Task: Parse the provided text and output as structured JSON. Instructions: 1. Identify all entities...