The Library
Browse every prompt
Filter by platform, role, function or prompt type. Save the ones you want, copy them straight into your favourite AI tool.
AI platformAll platforms
Job roleAll roles
FunctionAll functions
Prompt typeAll types
Build a spreadsheet formula from plain English
Plain-English description in, paste-ready spreadsheet formula out — Excel or Google Sheets dialect. Includes the "when it breaks" caveats most AI prompts skip.
Find the right numbers to track in Excel for my business
Copilot explains each number in plain English, writes the exact Excel formula, sanity-checks it on row one, and flags 2 ways the number could mislead you.
Excel formula generator from plain English
Describe what you want in plain English and get the exact Excel formula plus a walk-through.
Pivot table builder from raw data
Turn raw Excel data into a pivot table with the right rows, columns, values, and filters.
Chart type recommendation for a dataset
Get an opinionated chart pick for your dataset plus formatting notes and a headline.
Simple 3-statement financial model
Build a 12-month founder-friendly revenue, cost, and profit model directly in Excel.
Messy data cleaning checklist
Walk through a prioritised, teach-me-as-you-go cleanup of a messy Excel file.
Conditional formatting rules writer
Get a tight set of conditional formatting rules that spotlight the numbers that matter.
Budget vs actual variance table
Build a budget vs actual variance table with formulas, flags, and a short written commentary.
Sales pipeline tracker sheet
Ship a lightweight Excel pipeline sheet with weighted forecast, next steps, and overdue flags.
Payroll summary sheet
Structure a monthly AU payroll summary with gross, super, PAYG, net, and compliance reminders.
Inventory turnover calculator
See which SKUs turn, sit, or die and get an action plan per bucket in one Excel view.
VLOOKUP and XLOOKUP writer
Get the XLOOKUP formula plus a VLOOKUP fallback and a walk-through of every argument.
Data validation rules for a shared sheet
Add data validation rules, dropdowns, and friendly error messages to a shared Excel sheet.
Monthly financial report structure
Get the one-page monthly financial report structure, formulas, and commentary a founder needs.
KPI dashboard layout for a small team
Lay out a one-tab Excel KPI dashboard with tiles, sparklines, colour rules, and a story panel.
Excel formula error debugger
Diagnose Excel #VALUE, #NAME, #N/A, #DIV/0 errors and get the fixed formula with a walk-through.
Auto-categorise an Excel transaction column for sole trader tax
Copilot categorises a year of sole trader transactions into ATO deduction categories, applies business %, computes the deductible amount, and surfaces what to take to your accountant.
Vendor evaluation matrix
Score vendors with a weighted matrix, consistent rubric, deal-breaker column, and a 5-min recommendation memo.
Risk assessment template
Design a risk register with scoring rubric, top-5 summary, and a 1-page memo the sponsor can sign off on.
Convert an Excel formula to Google Sheets (or vice versa)
Convert spreadsheet formulas between Excel and Google Sheets, with a callout of any function that doesn't exist in the target and the workaround used.
Debug an error message — paste it, get the fix
Paste any error message, get a plain-English explanation, the most likely cause, and a step-by-step fix. Works for code, Zapier, Excel, Webflow, anywhere.
Categorise Excel transactions into BAS categories
Copilot reads each bank transaction in Excel and assigns BAS category, GST flag, and confidence, then surfaces the 10 most ambiguous rows for human review.
Write variance commentary in Excel for budget vs. actuals
Copilot writes the budget vs. actuals variance commentary, grouping by favourable / unfavourable / timing, with a headlines block and a watch list of variances trending wrong.
Build a 6-month sales forecast in Excel from 12 months of history
Copilot in Excel builds a 6-month sales forecast with seasonality, three scenarios, a line chart, and the one assumption you should challenge most.
Build a pivot table in Excel from a messy export
Copilot lists the data quality issues in a messy export, applies the minimum cleanup on a copy, builds the pivot with slicers, and tells you what the pivot is actually saying.
Find anomalies in an Excel expense column
Copilot in Excel scans an expense column for statistical anomalies, duplicates, suspicious round numbers, and new vendors, then ranks the top 10 to review.
Reconcile two lists in Excel and surface the mismatches
Copilot reconciles two Excel lists by key, produces a side-by-side mismatch table with dollar impact, and suggests the likely reason per mismatch.
Clean an Excel date column with mixed formats
Copilot identifies every date format in a messy Excel column, converts each row to your target format, flags the rows it could not parse, and respects AU locale.
Build a one-page Excel dashboard from raw data
Copilot turns a raw Excel data export into a clean one-page dashboard with key number tiles, mini trend charts, one breakdown, and a 50-word summary in your brand voice.