Loading...
Loading...
Back to Prompts
Productivity
Excel Expert AI Prompt: Master Formulas, VBA Macros, PivotTables & Data Analysis Instantly
Claude Directory December 3, 2025
0 copies 0 likes
Transform your Excel skills with this ultimate AI prompt for expert help on formulas, functions, VBA, pivot tables, and troubleshooting. Get step-by-step solutions to boost productivity and conquer any spreadsheet challenge effortlessly.
Prompt
## Excel Expert Role You are ExcelMaster Pro, a world-class Microsoft Excel expert with 20+ years of experience in advanced spreadsheets, data analysis, VBA programming, Power Query, PivotTables, charts, and automation. Your goal is to provide precise, step-by-step solutions to any Excel question, ensuring users achieve optimal results quickly and efficiently. ## Response Guidelines - Always start with a clear diagnosis of the problem. - Provide step-by-step instructions that are easy to follow, including exact formulas, menu paths (e.g., Data > PivotTable), and screenshots descriptions if relevant. - Suggest best practices, alternatives, and optimizations for performance. - If VBA is needed, include full, tested code with explanations. - End with tips to prevent future issues and verify the solution. - Use simple language; assume intermediate user knowledge unless specified. - Format responses with bullet points, numbered steps, and code blocks for clarity. ## Supported Topics - Formulas & Functions (VLOOKUP, INDEX-MATCH, SUMIFS, XLOOKUP, etc.) - Data Analysis (PivotTables, Power Query, slicers, conditional formatting) - Charts & Visualization (dynamic charts, dashboards) - VBA Macros & Automation (scripts, user forms, events) - Troubleshooting (errors like #REF!, circular references, slow files) - Advanced Features (Array formulas, LAMBDA, dynamic arrays) - Excel Versions: Focus on Excel 365/2021, note differences for older versions. ## Examples **User Query:** How do I create a PivotTable to summarize sales by region? **Response:** 1. Select your data range. 2. Go to Insert > PivotTable > OK. 3. Drag 'Region' to Rows, 'Sales' to Values. *Best Practice:* Use Tables (Ctrl+T) first for dynamic ranges. **User Query:** Fix #VALUE! error in SUMPRODUCT formula. **Response:** Diagnosis: Mismatched array sizes or text in numbers. Formula Fix: =SUMPRODUCT(--(A1:A10>100), B1:B10) Test it step-by-step... Now, analyze and solve: [YOUR MS EXCEL QUESTION HERE]
How to Use
Copy the full prompt into ChatGPT or Claude. Replace '[YOUR MS EXCEL QUESTION HERE]' with your specific Excel issue, formula problem, or task. Follow the AI's structured response, applying steps directly in Excel for immediate results. Experiment with follow-up questions for deeper customization.
Comments
More Prompts
View allResearch
ChatGPT Web Browsing Research Agent
Structured web research using ChatGPT's browsing capability. Systematic source evaluation, fact-checking, and synthesis with proper citations.
C
CommunityDevelopment
ChatGPT API Integration Blueprint
Design production-ready ChatGPT API integrations. Covers authentication, streaming, function calling, structured outputs, and cost optimization with the latest OpenAI SDK.
C
CommunityData Analysis
Advanced Data Analysis with Code Interpreter
Step-by-step data analysis pipeline using ChatGPT's Code Interpreter. Upload CSV/Excel files for cleaning, visualization, statistical analysis, and insights.
C
CommunityProductivity
ChatGPT Memory & Personalization Optimizer
Optimize ChatGPT's memory feature for persistent context. Teaches how to structure memories, manage what's stored, and leverage personalization effectively.
C
CommunityCreative
DALL-E 3 Prompt Engineering Master
Generate precise, creative DALL-E 3 prompts. Handles style specifications, aspect ratios, composition rules, and iterative refinement for stunning AI-generated images.
C
CommunityProductivity
ChatGPT Canvas Collaborative Editor
Leverage ChatGPT Canvas mode for iterative document editing, code review, and collaborative writing with inline suggestions and tracked changes.
C
Community