Prompt/Porter
Sign in

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 platform
All platforms
ChatGPTClaudeGeminiGrokMidjourneyDALL-EStable DiffusionCopilotPerplexityNotionNano BananaHiggsfieldOther
Job role
All roles
Small Business OwnerFounder / Solo OperatorMarketerSales ManagerAdvertising ManagerSocial Media ManagerContent CreatorDesignerDeveloperSales RepCustomer SupportAccountant / BookkeeperRecruiter / HRProduct ManagerResearcherEducatorExecutiveWriterStrategistOther
Function
All functions
Social Media ContentVideo CreationImage CreationStrategyFinance & InvestingEmail & CopywritingSEOSales & Lead GenerationProduct ManagementHR & RecruitingLegal & ComplianceData & AnalyticsSoftware DevelopmentDesign & UXCustomer SupportEducation & TrainingResearch & SummarisationPersonal ProductivityHealth & WellnessInteractive DashboardsAI Skills & PromptingMarketingOther
Prompt type
All types
Standard promptAgent promptDashboardSkillWorkflow
14 prompts·Search: "formula"
Copilot
#data analysis

VLOOKUP and XLOOKUP writer

Get the XLOOKUP formula plus a VLOOKUP fallback and a walk-through of every argument.

Copy
Copilot
#business

Monthly financial report structure

Get the one-page monthly financial report structure, formulas, and commentary a founder needs.

Copy
Copilot
#data analysis

Excel formula error debugger

Diagnose Excel #VALUE, #NAME, #N/A, #DIV/0 errors and get the fixed formula with a walk-through.

Copy
Copilot
#data analysis

Excel formula generator from plain English

Describe what you want in plain English and get the exact Excel formula plus a walk-through.

Copy
Copilot
#business

Budget vs actual variance table

Build a budget vs actual variance table with formulas, flags, and a short written commentary.

Copy
ChatGPT
#creative

Generate 30 short-form video hooks

Generates thirty short-form video hooks across formula categories for batch testing.

Copy
Copilot
#data analysis

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.

Copy
ChatGPT
#coding

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.

Copy
ChatGPT
#coding

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.

Copy
Gemini
#data analysis

Build a Google Sheets formula from a plain-English description

Describe what you want in plain English and get the Google Sheets formula, an explanation, an alternate version, test cases, and a fragility warning.

Copy
Notion
#productivity

Build a Notion formula for a custom database calculation

Inside Notion AI, generates a Notion 2.0 formula with paste-ready code, a plain-English walkthrough, three test cases, and an alternative approach if a rollup would be simpler.

Copy
Gemini
#data analysis

Clean up a messy column in Google Sheets

Paste in a messy Sheets column and get a single formula that fills a clean version, plus a flag column for the rows that need a human eye.

Copy
Claude
#creative

Build a 'first 30 seconds' script formula

Provides a reusable formula for the first 30 seconds of any short-form video that holds attention.

Copy
ChatGPT
#marketing

Write 15 hooks for short-form video

Generates fifteen tested hook formulas for TikTok, Reels, and YouTube Shorts.

Copy