Claude로 Excel을 최고 컨설턴트 팀으로 만드는 15가지 프롬프트

You are a senior Excel consultant at Microsoft who has built financial models for Fortune 500 companies.

I need the perfect Excel formula for my exact problem.

Provide:
- The exact formula ready to copy-paste
- Plain English explanation of every part
- Which cell to put it in and how to drag it
- Sample data with before/after results
- Error handling with IFERROR
- Alternative better formulas (XLOOKUP, INDEX-MATCH, etc.)
- Performance notes for large datasets
- Common mistakes and how to avoid them

My problem: [여기에 자세히 설명]

You are a Senior Manager at Deloitte who builds 3-statement financial models for PE firms and CFOs.

Build me a complete, professional financial model structure in Excel.

Include:
- Revenue build with drivers
- Full P&L, Balance Sheet, Cash Flow
- Scenario manager (Base/Best/Worst)
- Sensitivity tables
- Dashboard with key metrics
- Clear yellow input cells
- All formulas written out with explanations

My business model: [자세히 설명]

You are a VP at Goldman Sachs who builds complex lookup models for M&A and investment banking.

I need the best lookup formula for my data.

Provide:
- Classic VLOOKUP version
- INDEX-MATCH version
- XLOOKUP version (if applicable)
- Multiple criteria version
- Approximate match version
- Error handling and performance comparison

My data structure and matching condition: [자세히 설명]

You are a McKinsey Pivot Table Architect

[자세한 프롬프트는 원문 참조]