What is the Excel Pivot Wizard skill?

It is a specialized Claude Code skill that automates the creation of advanced Excel pivot tables, including layout, calculations, and interactive elements.

How do I trigger the pivot table creation?

You can trigger the skill using natural language phrases such as 'create pivot table', 'excel pivot', or 'data summary' followed by your specific requirements.

Does it require specific data formatting?

Yes, the source data should be in a tabular format with clear headers to ensure the skill can correctly identify dimensions and measures.

Can I create custom metrics with this skill?

Absolutely. The skill supports calculated fields, allowing you to define custom formulas for metrics like profit margins or growth rates.

Excel Pivot Wizard

Name: Excel Pivot Wizard
Author: Jst-Well-Dan

byJst-Well-Dan

•

Ciencia de Datos y ML

Generates sophisticated Excel pivot tables, calculated fields, and interactive slicers for rapid data analysis and reporting.

Acerca de

The Excel Pivot Wizard skill empowers users to transform raw tabular data into insightful, dashboard-ready summaries directly within Excel. It automates the complex setup of pivot tables, including the configuration of rows, columns, and filters, while adding advanced features like custom calculated metrics and interactive slicers. This skill is ideal for business analysts and data professionals who need to generate dynamic financial reports, sales summaries, or cost center trends without the manual overhead of traditional spreadsheet configuration.

Características Principales

Professional dashboard-ready formatting and styling
Dynamic configuration of rows, columns, values, and filters
Integration of interactive slicers for user-driven data filtering
4 GitHub stars
Automated pivot table generation from tabular data sources
Support for custom calculated fields and derived metrics

Casos de Uso

Building regional sales dashboards with product-level drill-downs
Performing monthly financial trend analysis with YoY growth metrics
Summarizing departmental cost center data for executive reporting

Acerca de

Características Principales

Professional dashboard-ready formatting and styling
Dynamic configuration of rows, columns, values, and filters
Integration of interactive slicers for user-driven data filtering
4 GitHub stars
Automated pivot table generation from tabular data sources
Support for custom calculated fields and derived metrics

Casos de Uso

Building regional sales dashboards with product-level drill-downs
Performing monthly financial trend analysis with YoY growth metrics
Summarizing departmental cost center data for executive reporting