📊 Data Processing
📖 Official
Professional Excel Spreadsheet Creation
Generate professional Excel files with working VLOOKUP, conditional formatting, and multiple tabs
★★☆ Intermediate 10-20 min January 12, 2026
📋
Scenario
I need to create a professional Excel report from scattered data, including formulas and formatting.
💬
Prompt
Create an Excel spreadsheet from these sales data files. Include: - Summary tab with totals and charts - VLOOKUP formulas to cross-reference products - Conditional formatting for targets (green for met, red for missed) - Documentation tab explaining the structure
✨
Expected Result
Claude built an 8-tab Excel file in under 3 minutes with working VLOOKUP formulas, conditional formatting, and documentation. Not a CSV that needs reformatting—an actual professional spreadsheet.
💡
Tips
- • Clearly specify formula types needed (VLOOKUP, SUM, IF, etc.)
- • Can request charts and visualizations
- • Specify conditional formatting rules and colors