Bronwen - Excel Power Query Data Cleanup Builder AI Skill - slide 1
Bronwen - Excel Power Query Data Cleanup Builder AI Skill - slide 2
Bronwen - Excel Power Query Data Cleanup Builder AI Skill - slide 3
Bronwen - Excel Power Query Data Cleanup Builder AI Skill - slide 4

技能檔案資料分析師 Claude Skills

Bronwen - Excel Power Query Data Cleanup Builder AI Skill

Turns a messy weekly export into a Power Query script that cleans it with one refresh.

$9· 單一檔案,永久擁有

永久擁有 · 立即下載

All-in-one

或者全部,$6.99/月

Bronwen 和另外 2,500+ 位專家,都在你的 AI 裡。直接叫名字就行。

訂閱 · 每月 $6.99

免費 7 天,之後 $6.99/月 · 可隨時取消

  • Visa
  • Mastercard
  • American Express
  • Apple Pay

30 天退款保證 · 由 Stripe 提供安全結帳

閱讀開頭幾行
# Bronwen - Excel Power Query Data Cleanup Builder

## Role

You are Bronwen, an Excel specialist who has turned hundreds of "the export is a mess, I fix it by hand every Monday" workflows into a refresh button. You think in applied steps: Source, Promoted Headers, Changed Type, and the rest of the recipe, each one named so that the person who inherits the workbook can read the query like a checklist.

You take a messy file (CSV, TXT, an Excel sheet, a folder of monthly exports) and a description of the layout the user wants, and you give them: the M script, the same recipe as Excel clicks, what to expect at each step, how to refresh it and how to check that the result is right.

You write for Power Query in Excel (Get & Transform). You do not run it, so you tell the user what to look for in the preview to confirm each step. You do not invent columns, formats or business rules.

## How you differ from Vince (Power BI Developer)

技能檔案 · 179 行 · 顯示前 12 行

使用方式

  1. 購買或訂閱以 $9 加入購物車,檔案就永久屬於你。或者訂閱:商店裡所有檔案,$6.99/月。
  2. 在你的 AI 中開啟下載檔案後加到 Claude(Settings → Capabilities → Skills → Upload),或貼到 ChatGPT 專案中。訂閱者則只需連接一次你的 AI。

    Claude

    Anthropic 的 AI 聊天,支援網頁、桌面和手機 · 約 3 分鐘

    所有 Claude 方案都能用,包括 Free。

    • Team 或 Enterprise 方案:由工作區擁有者在 Organization settings 中新增一次,之後每個人只要點選 Connect。
    • 點選 Connect 後沒有反應?請允許 claude.ai 的彈出視窗,然後再試一次。

    用手機嗎?先在電腦上設定一次,之後它會自動出現在 Claude 手機 App 中。 把連結寄給我

    購買檔案後
    1. 從訂單郵件或你的帳戶下載 .skill 檔案。

    2. 在 Claude 的 Settings › Capabilities 開啟程式碼執行,然後前往 Customize › Skills › + › Create skill › Upload a skill。

    3. 開啟新對話,用名字叫出專家。

    開啟完整指南

  3. 喊名字就能用開始新對話,用名字叫出 Bronwen。從第一則訊息起,它就像那位專家一樣工作。

包含的內容

  • bronwen-excel-power-query-data-cleanup-builder.skill技能檔案 · 179 行 · 立即下載
  • Complete M script with readable applied-step names and comments
  • Same recipe as Excel clicks, with what the preview should show per step
  • Control totals and checks to prove the cleanup did not lose rows
  • Refresh notes: file paths, layout changes, privacy-level errors

你的 AI 能做什麼

看看實際範例
你的提問

ERP CSV with 3 title lines, months as columns, subtotal rows and amounts like 1,234.50. I need Region, Rep, Month, Amount as a flat table for a PivotTable. Excel 365 on Windows. Sample rows below.

AI 的回答

You get: a diagnosis of the sample → the target table definition → a full M script with named steps → a step table of what the preview should show → the Excel click path → a validation checklist with a control total → refresh and sharing notes → a table of common errors → open questions.

// faq

購買前的常見問題

What does Bronwen - Excel Power Query Data Cleanup Builder do?+

Bronwen reads your sample rows and target layout, then delivers a complete Power Query M script with named applied steps, the equivalent Excel click path, a table of what the preview should show after each step, a validation checklist with control totals, refresh and sharing notes, and a guide to common errors. It is built for recurring CSV and ERP exports.

How is Bronwen different from Vince?+

Vince is our Power BI developer: data models, DAX measures, relationships and report pages. Power Query is one part of his world, and the output is a model. Bronwen works in Excel, where the output is a clean worksheet table or PivotTable source that refreshes from the same messy export. She handles Excel-specific loading, file paths and PivotTable refresh.

Does Bronwen run the script or guess my data?+

No. She never claims the script was run, so she tells you what to check in the preview after each step. Column names are copied exactly from your sample, and anything not visible in it is marked as needed. Choices like dropping duplicates or turning a dash into null are stated as assumptions.

What Excel versions does it support?+

She writes for Power Query in Excel as used in Microsoft 365 and recent versions on Windows, and notes where Mac or Excel Online differ. Menu names are given as in Microsoft 365, and when a path may differ in your version she says so and names the command so you can find it.

要怎麼開啟?+

從訂單郵件或你的帳戶下載 .skill 檔案。在 Claude 的 Settings › Capabilities 開啟程式碼執行,然後前往 Customize › Skills › + › Create skill › Upload a skill。開啟新對話,用名字叫出專家。

你用的是 ChatGPT、Gemini 或其他 AI?看看使用方式