將貼上或匯出的混雜格式、空白行或重複資料，清理成一致格式且可供分析的整潔範圍。建議在將原始資料貼入工作表後立即使用。
這個技能專門用於清理從外部來源貼入或匯入 Excel 的原始資料。它會自動偵測並修正同一欄中的不一致格式，例如文字型數字與實際數字混雜、多種日期格式或不一致的字母大小寫。技能還會移除或標記完全重複的資料列，並說明判定重複的規則；同時標準化空白儲存格，區分真正的零值與缺失值。此外，它會修剪多餘空白、正規化語義相同但書寫不一致的分類標籤，最後將文字格式的數字與日期轉換為 Excel 可運算的正確類型。清理完成後，技能會輸出一個整潔且格式一致的資料範圍，並附上一份變更日誌，逐行記錄做了哪些標準化、移除或轉換，讓整個清理過程可追溯、可稽核。此技能支援 Excel 環境，特別適合用於建立樞紐分析表或撰寫公式之前，將原始資料快速準備好。
npx skills add https://github.com/andreworia/claude-excel-skills/tree/main/skills/data-cleaning-for-excelInstalled? Explore more 生產力與協作 skills: steipete/gemini, steipete/gh-issues, steipete/skill-creator · View all 6 →
在貼上或匯入原始資料（CSV 匯出檔、從其他系統複製的資料、或從文件複製的表格）之後，立即使用此技能，然後再於其上建立樞紐分析表或公式。
一個經過清理、格式一致的資料範圍，以及一份簡短的變更日誌，說明哪些內容已被標準化、移除或轉換。
This repo contains 11 individual skills — each has its own dedicated page.
Creates a structured assumption register for any Excel model with columns for name, category, base value, source, Bull/Bear values, sensitivity rank, and owner, plus a formula for computing sensitivity rank from Data Table outputs.
Provides a systematic audit checklist for Excel model formula logic, hardcoded values, circular references, and error handling, with step-by-step instructions for using Excel's native auditing tools.
Enforces the three-tab separation principle for any Excel model, producing a full design for a dedicated Inputs tab, one or more Calculations tabs, and a clean Outputs tab with a conventions checklist.
Defines the master tab structure, naming conventions, color codes, number formats, and print area setup for any new strategy or finance Excel model, serving as the structural template before any content is added.
Designs the executive summary tab of an Excel model with KPI tiles, a narrative block, a sensitivity summary, and an assumption log, formatted for print or screenshot use in a board pack.
Specifies and builds a pivot table from a flat data range, choosing rows, columns, values, and filters. Use it when you have raw tabular data and need a summary view without building it cell by cell.
Builds a driver-based revenue forecast .xlsx with live formulas across separate drivers, build, and output tabs plus checks, rolling a customer or units schedule (beginning, adds, churn, ending) into revenue with Base/Bull/Bear scenario toggles. Use when someone needs a bottom-up revenue model, an ARR build, or a driver-based forecast for planning or a board deck. Do not trigger for editing an existing workbook through the Claude for Excel add-in.
Builds a Base/Bull/Bear scenario switching layer for a model in a .xlsx with a live selector, CHOOSE or INDEX assumption links, a side-by-side output comparison, and a recalc check, then delivers the workbook. Use when someone wants an auditable scenario toggle instead of Excel's hidden Scenario Manager. Do not trigger for editing an existing workbook through the Claude for Excel add-in.
Builds one- and two-variable sensitivity (Data Table) analysis on a model output in a .xlsx with live formulas and a recalc check, then delivers the workbook. Use when someone wants to see how an output (NPV, IRR, EPS, margin) moves as one or two inputs change. Do not trigger for editing an existing workbook through the Claude for Excel add-in.
Ranks variable sensitivities to a key output and builds a tornado chart by swinging each input over a defined range, computing output impact, and producing a horizontal bar chart data structure.
Builds a unit-economics and cohort .xlsx with live formulas across separate assumptions, cohort, and output tabs plus checks, computing CAC, LTV, LTV/CAC, and CAC payback from a monthly cohort retention grid. Use when someone needs unit economics, an LTV/CAC analysis, a payback model, or a cohort retention build. Do not trigger for editing an existing workbook through the Claude for Excel add-in.
Gemini CLI one-shot prompts, summaries, generation, skills, hooks, MCP, or Gemma routing.
Fetch GitHub issues, select candidates, spawn background fix agents, open PRs, and optionally process PR review comments.
Create, edit, audit, tidy, validate, or restructure AgentSkills and SKILL.md files.
Search, install, update, sync, or publish agent skills with the ClawHub CLI and registry.
Delegate coding work to Codex, Claude Code, or OpenCode as background workers; not simple edits or read-only code lookup.
List, configure, authenticate, call, and inspect MCP servers/tools with mcporter over HTTP or stdio.