Excel & Data

22 prompts in this category

Excel & Data

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...
Excel Demo Data●●●AdvancedWorkflow-ready
Excel & Data

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]...
Excel Demo Data●●●AdvancedExecutive-readySkill-readyWorkflow-ready
Excel & 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...
Excel Demo Data●●●AdvancedWorkflow-ready
Excel & Data

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...
Excel Demo Data●●●AdvancedWorkflow-ready
Excel & Data

Data Analysis Report Writer

You are a senior data analyst with extensive consulting experience. I am uploading sales KPI data and revenue data for [COMPANY NAME]. Write a consulting-grade...
Copilot Chat Demo Data●●●AdvancedWorkflow-ready
Excel & Data

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 Demo Data●●●AdvancedSkill-readyWorkflow-ready
Excel & Data

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...
Excel●●●AdvancedSkill-readyWorkflow-ready
Excel & Data

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...
Excel●●●AdvancedSkill-readyWorkflow-ready
Excel & Data

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:...
Excel●●●AdvancedSkill-readyWorkflow-ready
Excel & Data

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...
Excel●●●AdvancedWorkflow-ready
Excel & Data

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...
Excel●●●AdvancedWorkflow-ready
Excel & Data

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)...
Excel●●●AdvancedWorkflow-ready
Excel & Data

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: [...
Excel●●●AdvancedSkill-readyWorkflow-ready
Excel & Data

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...
Excel●●●AdvancedWorkflow-ready
Excel & Data

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...
Excel●●●AdvancedWorkflow-ready
Excel & Data

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...
Excel●●IntermediateWorkflow-ready
Excel & Data

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 ...
Excel●●IntermediateExecutive-readyWorkflow-ready
Excel & Data

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...
Excel●BeginnerSkill-ready
Excel & Data

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...
Excel●●IntermediateWorkflow-ready
Excel & Data

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...
Copilot Chat●●●AdvancedWorkflow-ready
Excel & Data

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...
Copilot Chat●●IntermediateWorkflow-ready
Excel & DataNew

Three-Statement Financial Model Builder

Create a comprehensive three-statement financial model integrating the income statement, balance sheet, and cash flow statement. Include historical data inputs ...
Excel●●●AdvancedWorkflow-ready