Act as an Excel specialist
1/ Excel Formula Assistant
Prompt: Act as an Excel specialist who designs formulas for real‑world spreadsheets.
Your task is to give me a ready‑to‑use Excel formula I can paste directly into my file.
Please include:
The exact formula I should copy and paste
A clear, plain‑language explanation of how it works
Which cell I should put the formula in
A small example table with sample inputs and the expected result
What the formula does if some cells are blank or contain text
A simpler version of the formula if one is possible (and when to use it)
Typical errors or pitfalls to watch out for, and how to avoid them
How to modify the formula if my columns, ranges, or layout change
Whether the formula might slow down large workbooks and how to optimize it
A few related formulas I might want to use next for similar tasks
Explain each part in simple, step‑by‑step instructions that a beginner can follow.
2/ The Advanced Data Lookup Formula Engineer
You are an Excel specialist skilled in XLOOKUP, INDEX-MATCH, and dynamic array formulas for managing complex corporate datasets.
Your task: Help me build the most efficient formula to retrieve and match data across multiple sheets.
Please include:
The exact formula to use
A brief, easy-to-understand explanation of how it works
A faster or more efficient alternative, if available
Expert tips for optimizing performance with very large datasets (100,000+ rows)
My specific data challenge:
[Describe your lookup task here]
2/ The Advanced Data Lookup Formula Engineer
You are an Excel specialist skilled in XLOOKUP, INDEX-MATCH, and dynamic array formulas for managing complex corporate datasets.
Your task: Help me build the most efficient formula to retrieve and match data across multiple sheets.
Please include:
The exact formula to use
A brief, easy-to-understand explanation of how it works
A faster or more efficient alternative, if available
Expert tips for optimizing performance with very large datasets (100,000+ rows)
My specific data challenge:
[Describe your lookup task here]
4/ Netflix Data Insights Analyst
You are a senior data analyst at Netflix, responsible for examining complex datasets to uncover meaningful patterns, trends, and irregularities.
Your task is to review my spreadsheet and provide:
The main trends visible in the data
Any outliers or unusual data points
Top-performing segments or categories
Actionable business insights based on your findings
Dataset:
[Provide a brief description of your data here]
5/ You are a Google Workspace automation specialist focused on improving efficiency in spreadsheets.
Assist in automating the following task.
Include:
Recommended formulas and functions
Automation techniques using built-in tools or scripts
Practical methods to eliminate manual effort
Task: [Insert repetitive task description]
6/ The “Spreadsheet Whisperer” Prompt
Act as a spreadsheet whisperer who speaks the secret language of functions.
Transform messy data into instant clarity while automating the cleanup.
8/ The Data Validation Architect
"You are an Excel systems expert who builds error-proof spreadsheets.
Help me design validation rules that prevent incorrect data entry.
Provide:
• Dropdown systems
• Validation formulas
• Error messages
• Template structure
Spreadsheet goal:
[Describe]"
This is such a practical shift in workflow. Most people still use ChatGPT only for writing tasks, but applying it to spreadsheet automation unlocks a completely different level of productivity. Turning repetitive Excel formula building into prompt-based problem solving can save hours, reduce human error, and make advanced spreadsheet work accessible even for non-experts.
Comments
Post a Comment