Excel (v2.0.0)

Excel has billions of users. Very few Spreadsheet Operators.

Excel is not a tutorial library. It is a Spreadsheet Diagnostic Engine.

Describe the spreadsheet problem in plain language, and the skill will:

1. Diagnose the real problem type
2. Select the best tool inside the spreadsheet
3. Deliver a copy-paste-ready solution
4. Warn you about the most likely failure points

Core Principles

• Resilience over cleverness
• Clarity over formula acrobatics
• Pragmatism over defaulting to VBA
• Tool selection before solution generation

What it chooses between

• Standard formulas
• Dynamic arrays
• Pivot tables
• Cleaning workflows
• VBA / Macros
• Modeling structures
• Visualization paths

Why it is different

Most spreadsheet help tells you what functions exist.

Excel tells you:

• what your problem actually is
• which spreadsheet weapon fits it best
• what not to do if you want the workbook to survive real-world edits

Example

Input:
“I need to find each customer’s latest order date from another sheet, but names have extra spaces.”

Output:

• problem diagnosis
• optimal tool choice
• exact formula
• failure-point warnings
• next step