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.
29 free, copy-ready Excel & Spreadsheets prompts for ChatGPT, Claude and Gemini. Ready-to-use prompts for Excel and Google Sheets formulas, data cleanup, pivot tables, charts and scripts.
29 prompts
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.
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.
You get exact columns, copy-ready reorder-point formulas, a status column and conditional formatting that highlights items to reorder now or this week.
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.
Get a variance table with dollar and percent variances, a materiality filter, timing vs permanent labels, short explanations with next actions, and Excel formulas.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Get a commented, beginner-safe VBA macro built around your sheet names, ranges and trigger, with install steps, test advice and a backup warning.
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.
You get a ready-to-build spreadsheet layout with formulas for overnight shifts, unpaid breaks, weekly hours per employee and highlighted overtime.
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.
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.
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.
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.
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
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.
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.
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.
Yes. Every prompt is free to copy. A free account lets you save prompts to your own vault and edit them.
Categories