Claude Excel Prompts: 50 Ready-to-Use Templates

The Power of the Right Prompt

The difference between a good Claude prompt and a great one can save you hours of work. This curated library of 50 prompts covers the most common Excel automation scenarios professionals face every day.

Financial Analysis Prompts

Prompt 1: Revenue Forecast Model

"Create an Excel formula set to build a 12-month revenue forecast using historical monthly data in columns B2:B13, applying 15% YoY growth rate with seasonal adjustment factors."

Prompt 2: Variance Analysis

"Write formulas to calculate budget vs actual variance, both in absolute dollars and percentage, with conditional formatting to flag variances over 10%."

Prompt 3: DCF Valuation Template

"Build a discounted cash flow valuation model in Excel with: 5-year projections, WACC calculation, terminal value, and sensitivity analysis table."

Data Cleaning Prompts

Prompt 4: Duplicate Removal

"Write a VBA macro to identify and remove duplicate rows based on columns A and C, keeping the most recent entry based on the date in column E."

Prompt 5: Data Standardization

"Create formulas to standardize a customer name column: remove extra spaces, convert to proper case, and flag entries that are likely duplicates using fuzzy matching."

Dashboard & Reporting Prompts

Prompt 6: Executive Dashboard

"Design an Excel dashboard layout with: monthly revenue trend chart, top 10 customers table, regional performance map data, and YTD KPI summary cards."

Conclusion

These 50 prompts are just the beginning. The AI Claude Excel™ system includes 200+ prompts organized by profession, use case, and complexity level.