29 prompts

  • Build a 13-Week Cash Flow Forecast in Excel with Low-Balance Alerts

    You get a 13-week cash flow sheet layout with committed and expected cash split apart, exact running-balance formulas, and red flags for weeks below your minimum.

  • Build a Break-Even and Pricing Calculator Spreadsheet in Excel

    You get an Excel layout that separates fixed and variable costs, formulas for break-even and margin at three prices, and a ranking of which inputs move the result most.

  • Build an Inventory Tracker Spreadsheet with Reorder Points and Low-Stock Alerts

    You get exact columns, copy-ready reorder-point formulas, a status column and conditional formatting that highlights items to reorder now or this week.

  • Build an Invoice Template in Excel or Google Sheets with Automatic Totals

    You get a cell-by-cell invoice layout with exact formulas for line totals, discount, tax, due date, and a duplicate-proof invoice numbering system.

  • Build a Budget vs Actual Variance Analysis That Separates Timing from Overspend

    Get a variance table with dollar and percent variances, a materiality filter, timing vs permanent labels, short explanations with next actions, and Excel formulas.

  • Build a Power Query Workflow That Combines and Cleans Monthly Excel Files

    You get numbered Power Query steps with paste-ready M code, a full query, and a flag on every step that breaks when column names change.

  • Build an Excel Sales Forecast Comparing Moving Average and FORECAST.ETS

    You get a tested Excel sales forecast with paste-ready formulas for two methods, a MAPE comparison on held-out months, and a clear pick of the better method.

  • Calculate Year-over-Year and Month-over-Month Growth in Excel Without Misleading Percentages

    You get a growth table, exact Excel formulas that handle zero and negative baselines and partial months, plain-language takeaways, and a list of percentages that would mislead.

  • Design a One-Page Manager Dashboard in Excel or Google Sheets

    Get a buildable one-page dashboard plan with a layout grid, a spec for each tile (metric, chart, filter, source range, formula) and numbered build steps.

  • Turn a Spreadsheet Analysis into a Three-Finding Executive Summary Email

    Get a short executive email with three numbered findings backed by your data, one clear recommendation, one open question, and a note on data gaps.

  • Write a Weekly or Monthly KPI Report Narrative from Your Excel Numbers

    Turns your pasted KPI numbers into a report narrative where each metric states the change, the likely driver and a next action, with every claim tied to a figure.

  • Write SQL Queries from a Plain-English Question and Your Table Schema

    Paste your schema and ask a question in plain English. You get a working SQL query, a line-by-line explanation, and a row-count check query to verify the results.

  • Clean and Standardize Messy Spreadsheet Data with Exact Formulas

    Get a column-by-column cleaning plan with ready-to-fill formulas for spaces, case, dates and duplicates, plus a list of rows that need a manual check.

  • Design a Clean Spreadsheet Layout for a Tracker or Budget That Scales

    You get a complete sheet blueprint with tabs, column specs, data types, dropdown lists, summary formulas and setup steps that keep working as rows grow.

  • Explain Any Excel or Google Sheets Formula Step by Step in Plain English

    Paste a formula and get a plain-language walkthrough in evaluation order, a table of what each part returns, common ways it breaks with fixes, and a simpler version.

  • Paste rows from Excel or Google Sheets and get numbered findings tied to exact figures, a trend table, data quality flags and the gaps that limit conclusions.

  • Write a Commented VBA Macro to Automate a Repetitive Excel Task

    Get a commented, beginner-safe VBA macro built around your sheet names, ranges and trigger, with install steps, test advice and a backup warning.

  • Write a Google Apps Script to Automate a Sheets Task with Dry-Run Mode

    Get a working Google Apps Script for your Sheets task, with trigger setup, the permission screens you will see, and a dry-run mode that logs changes first.

  • Build an Employee Shift Schedule and Hours Tracker with Overtime in Excel

    You get a ready-to-build spreadsheet layout with formulas for overnight shifts, unpaid breaks, weekly hours per employee and highlighted overtime.

  • Find Outliers, Duplicates and Bad Data in Your Spreadsheet Using IQR

    Paste a dataset and get a row-by-row table of duplicates, missing values, impossible values and IQR outliers, each with a suggested fix and Excel formulas.

  • Set Up Data Validation Rules That Stop Bad Entries in a Shared Excel Sheet

    You get a column-by-column validation plan with allowed values, custom formulas, input and error messages, plus a helper formula that flags rows already holding bad data.

  • Build Conditional Formatting Rules with Exact Formulas and Rule Order

    You get a table of conditional formatting rules with the exact custom formula, the range to apply each one to, colors, and a rule order that avoids conflicts.

  • Build Excel and Google Sheets Formulas for Workdays, Ages and Deadlines

    You get working date formulas for your exact layout, such as workdays, deadlines, ages and month offsets, with a holiday table, locale pitfalls and a test row.

  • Fix an Excel or Google Sheets Formula That Returns an Error or Wrong Result

    Get a ranked list of the likely reasons your formula fails, a quick check for each, and a corrected formula you can paste straight into your sheet.

FAQ

About these prompts

What are Excel & Spreadsheets Prompts?

Ready-to-use prompts for Excel and Google Sheets formulas, data cleanup, pivot tables, charts and scripts. Each one is a complete, copy-ready prompt: it sets the role and the steps and says what the answer should look like.

Which AI tools do these prompts work with?

They are written for ChatGPT, Claude and Gemini. Each prompt page lists its tools, and most text prompts also work in any capable chat model.

How do I use one?

Open the prompt, copy it and paste it into ChatGPT or your AI tool. You can also open it straight in ChatGPT, Claude, Gemini or Perplexity.

Are these prompts free?

Yes. Every prompt is free to copy. A free account lets you save prompts to your own vault and edit them.