FeaturedBeginner
Meeting Notes Organizer
Turn messy meeting notes into a clear summary with decisions made and tasks to do.
Productivity
ProductivityBeginnerFeatured
Excel & Google Sheets Formula Expert
Generate complex spreadsheet formulas with explanations, from VLOOKUP to array formulas and pivot tables.
Quick Info
Works with
3 AI tools
Fill in
4 fields
Added
Jan 27, 2026
ChatGPT, Claude +14 fields to fill
The Prompt
Your Prompt
You are an Excel/Google Sheets power user and instructor. Help me create formulas for:
Spreadsheet Tool: [TOOL]
What I Need: [TASK]
Data Description: [DATA]
Current Skill Level: [LEVEL]
Provide:1. The Formula (exact formula ready to paste)
2. Step-by-Step Explanation (break down each part)
3. Visual Example (show sample data in a table and result)
4. Common Errors (what could go wrong + fixes)
5. Alternative Approaches (2 other ways to achieve the same result)
6. Pro Tip (a shortcut or advanced technique)
If the task is complex, also provide:
- Helper columns strategy (break it into steps)
- Named ranges recommendation
- Data validation suggestions
- Conditional formatting rules
- Pivot table instructions (if relevant)
Format formulas in code blocks. Explain like I'm a smart person who doesn't live in spreadsheets.
Spreadsheet Tool: [TOOL]
What I Need: [TASK]
Data Description: [DATA]
Current Skill Level: [LEVEL]
Provide:1. The Formula (exact formula ready to paste)
2. Step-by-Step Explanation (break down each part)
3. Visual Example (show sample data in a table and result)
4. Common Errors (what could go wrong + fixes)
5. Alternative Approaches (2 other ways to achieve the same result)
6. Pro Tip (a shortcut or advanced technique)
If the task is complex, also provide:
- Helper columns strategy (break it into steps)
- Named ranges recommendation
- Data validation suggestions
- Conditional formatting rules
- Pivot table instructions (if relevant)
Format formulas in code blocks. Explain like I'm a smart person who doesn't live in spreadsheets.
Example Output
Task: Calculate monthly sales growth percentageFormula =IF(B2="","",ROUND((B2-B1)/B1*100,1)&"%") Example Data| Month | Sales | Growth |
|-------|-------|--------|
| Jan | $10,000 | - |
| Feb | $12,500 | 25.0% |
| Mar | $11,800 | -5.6% |
Explanation-IF(B2="","",...)— Skips empty cells
-(B2-B1)/B1— Calculates percentage change
-ROUND(...,1)— Rounds to 1 decimal
-&"%"— Adds the % symbol
Pro TipUseFORMAT > Number > Percentinstead of manually adding '%' — lets you sort and chart the data properly.
Fill In These Fields
Replace the highlighted parts with your own information.
[TOOL]Which spreadsheet app
Example: Google Sheets
[TASK]What you want to calculate
Example: Calculate monthly sales growth % and highlight negative months in red
[DATA]Describe your data
Example: Column A: Month names, Column B: Monthly sales figures, 12 rows
[LEVEL]Your spreadsheet skill
Example: Know basics (SUM, IF) but struggle with VLOOKUP
Pro Tips
- 1Always describe your data structure — column headers and sample rows help a lot
- 2Mention whether you need the formula for one cell or to drag it down
- 3For Google Sheets, mention it specifically — some formulas differ from Excel
- 4Ask for LAMBDA or LET functions for complex calculations (Excel 365)
Try This Prompt With
Copy the prompt above and paste it into any of these AI tools.
Related Prompts
Personalized AI Chatbots
Your Business Never Sleeps. Neither Should Your Chatbot.
Imagine an AI that answers customers instantly, captures leads while you sleep, and never takes a day off. We build custom chatbots that turn visitors into revenue, on autopilot.