앞으로 엑셀 직접 만들지 마세요! 클로드 하나로 자동화 하는 법

Technological concepts & product features (Claude inside Excel)

Claude 4 for Excel Add-in

• Install via Excel Ribbon → Add-ins
  1. Search Claude
  2. Click Add
  3. Log in with a Claude account
• After installation, Claude appears on the Excel Home ribbon / sidebar.

Compatibility notes / limitations

• Works unconditionally if you have Microsoft 365 subscription.
• Office 2029 / 2021 / Office 2024 (perpetual/research licenses) may not be officially supported.
• Company/school accounts may block it due to IT restrictions (e.g., “permission to use additional features”).
  • A personal Microsoft account often resolves this.
• If the desktop add-in isn’t available:
  • Use Excel for the web (free), then add the Claude add-in there.

Paid plan behavior

• With a paid plan, the workflow “uses everything without extra cost” (only free revisions are restricted).

Skills system (slash commands)

• Claude includes default “skills” (tasks) you can trigger by:
  • Clicking skill names, or
  • Typing / in Claude’s dialog, or
  • Registering your own reusable skills
• Example skills:
  • Clean Data
  • Later skills for recurring tasks (e.g., monthly processing)

---

Review / guide / tutorial: “From installation to executive dashboard”

This video is a step-by-step guide showing how to replace manual Excel work with Claude automation.

1) Setup + installing Claude into Excel

• Step-by-step installation and login via Excel Add-ins.
• Includes a fallback: Excel for the web if desktop licensing/add-in is blocked.

2) Cleaning messy sales data (“Clean Data” skill)

• Claude first reads the data, then proposes a plan before changing anything.
• Key workflow instruction:
  • Use “Show me the plan first” so Claude explains changes and gets permission
  • This improves results compared to fully autonomous edits.
• Demonstrated data improvements:
  • Standardizes order date format
  • Normalizes client/company names into a fixed set (8 standard company names)
  • Cleans and formats sales amounts (including currency/commas issues)
  • Removes duplicates and reduces rows (example: 113 → 110)
• Emphasis on AI self-correction/validation:
  • Claude diagnoses date parsing risks and safely converts to standard date values
• Claimed time saving:
  • Tasks that normally take ~half a day finished in ~3 minutes

3) Analysis: asking the “right questions”

• Problem addressed: users don’t know what to analyze.
• Technique:
  • Have Claude generate five analysis questions a manager/boss would care about.
• Example questions requested:
  • Total annual sales and growth rates (2025 vs 2024)
  • Top 5 clients by sales and growth
  • Product categories with lowest achievement vs 2025 targets
• Claude outputs results and provides traceability.

4) Verification: “Where did this number come from?”

• Auditability demo:
  • Ask Claude to identify which cells/formulas produced a metric
  • Claude points to source cells and explains the sum logic
• Video positioning: makes it easier to trust AI output without fear.

5) Dashboard building (Excel “print/submission” dashboard)

• Core strategy:
  • Don’t ask for everything at once—build incrementally with short commands to keep Claude accurate/stable.
• Dashboard components created (9+ chart types):
  • KPI cards (total sales, growth rate, top product category)
  • Sales bar chart by product category
  • Donut chart by product category proportion
  • Combo chart (monthly bars + line)
  • Heatmap for product group monthly performance intensity
  • Mini charts for monthly rankings inside cells
  • Traffic-light gauge for achievement rate (green if ≥100%, red otherwise)
  • Verification cell that turns green/red if refined sums match original totals
• Live recalculation demo:
  • Change a source sales cell → dashboard KPIs/charts/heatmaps update immediately via underlying formulas (not static pasted numbers).

---

Additional capability: interactive web dashboard (HTML) for presentations

• Uses Claude AI chat in the browser (separate from Excel) to convert the dataset into a clickable interactive HTML dashboard.
• Requested features:
  • Filters (e.g., product family + year) that update charts in real time
  • Underperformers highlighted in red
  • Tooltips on hover for detailed numbers
  • Dark theme styling
  • Adds count-up animation and a specific brand color tone (teal)
• Key contrast:
  • Excel dashboard = for printing/submission
  • Web dashboard = for browsing/click navigation in presentations
• Sharing:
  • Share via link
  • Use screenshots for blogs/social

---

Automation: turning repeat work into one command

Method 1: Save rules in settings

• Save recurring formatting/rules so Claude applies them automatically across pages, e.g.:
  • Date format yyy mmdd
  • Amounts as numbers only
  • Standardized client notation
  • Leave blanks unspecified

Method 2: Create a reusable “skill”

• Convert the entire monthly refining workflow into a skill so it runs with a single slash command next month.

Claimed benefit

• Work that takes an hour becomes ~10 minutes next month.

---

Bonus tools/tips

• Download Transcript
  • Downloads all work as a single file from the sidebar.
• Upload PDFs/photos
  • Use the plus button in the sidebar to have Claude extract transaction items and output structured Excel sheets.
  • Example: 1 PDF → multiple item sheets with totals calculated via formulas.
• Connectors
  • Bring data from Notion or Google Drive into Excel.
  • Example: reusable “skills” for organizing receipts and meeting minutes.

---

Main speakers / sources

• Primary speaker: The video’s host/creator (narrator demonstrating Claude 4 Excel automation; introduced via “Part 2” of the AI $1 series 2026 and later mentions a “Sainty Cor 6” event).
• Technology source: Claude 4 integrated into Microsoft Excel via the Claude add-in/skills system.