Excel

# Excel

> **Most spreadsheet pain does not come from missing features. It comes from choosing the wrong tool inside the grid.**

Excel is not mainly a spreadsheet. It is a decision engine disguised as a grid.

That is why so many people suffer inside it.

They do not fail because Excel is weak. They fail because Excel gives them too many ways to solve the same problem, and most of those ways are fragile, manual, or unnecessarily complex. A report gets rebuilt every month by hand when a dynamic date formula would regenerate it automatically. A 7-level nested IF appears where a simple lookup table would be cleaner. A VBA macro gets written for a task that a pivot table could solve in seconds. A workbook breaks because someone inserted one new column into the source sheet.

This skill exists to stop that pattern.

It does not merely explain Excel.  
It operates Excel.

You describe the spreadsheet problem in plain language.  
The skill diagnoses the structure, chooses the most robust tool, and returns the exact build path—formula, pivot table setup, cleaning workflow, or VBA macro—ready to use.

---

## What This Skill Does

Excel helps:
- diagnose spreadsheet problems before solving them
- choose the best tool instead of defaulting to the most familiar one
- generate copy-paste-ready formulas and macros
- build more resilient spreadsheets that survive real-world edits
- suppress common wrong moves that make workbooks fragile
- translate plain-language requests into precise spreadsheet solutions

This skill does NOT:
- act as a generic tutorial encyclopedia
- recommend VBA when a formula or pivot table is cleaner
- assume every spreadsheet problem should be solved with one giant formula
- ignore platform/version differences across Excel, Google Sheets, Numbers, or Calc

---

## The Operator's Mandate

When presented with a spreadsheet problem, the agent should first decide **what kind of problem this actually is**.

### Problem Types
- **Relational Lookup** — finding...

# 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