What data format does Excel Pivot Wizard require?

The skill requires source data to be in a standard tabular format with clearly defined headers to accurately map dimensions and measures.

Can it create custom metrics beyond standard sums?

Yes, it supports the creation of calculated fields, allowing you to build custom metrics and derived KPIs directly within the pivot table.

What happens if my source data headers change?

The skill includes error handling guidance to help you refresh data connections and update field mappings if the source structure is modified.

Does this skill support interactive dashboard elements?

Absolutely. It can insert slicers that provide interactive filtering capabilities, making your pivot tables function as dynamic dashboards.

Excel Pivot Wizard

Name: Excel Pivot Wizard
Author: Brmbobo

byBrmbobo

0•

データサイエンスとML

Automates the creation of advanced Excel pivot tables, calculated fields, and interactive dashboards for streamlined data analysis.

Excel Pivot Wizard is a specialized Claude Code skill designed to transform raw tabular data into sophisticated analytical reports. It handles the complex logic of configuring rows, columns, and values while implementing advanced features like calculated fields for custom metrics and interactive slicers for dynamic filtering. Whether you are building financial models, sales dashboards, or time-series reports, this skill ensures professional formatting and robust error handling to help you derive actionable insights from your spreadsheets faster.

主な機能

01Interactive slicers for dynamic dashboard filtering

02Presentation-ready formatting and styling

030 GitHub stars

04Error handling for data refresh and formula validation

05Automated pivot table configuration from tabular data

06Custom calculated fields for advanced metric derivation

ユースケース

01Generating monthly financial trend reports with YoY growth metrics

02Summarizing large datasets into concise, actionable business summaries

03Building interactive sales dashboards segmented by region and product

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add brmbobo/web2podcast excel-pivot-wizard

For use in Claude.ai and ChatGPT

Download Skill