Does it create charts automatically?

Yes, it generates context-aware visualizations like line charts for trends and bar charts for comparisons based on your specific analysis request.

How does it handle large datasets?

It is designed to interpret and summarize transaction-level data, applying professional formatting, sorting, and grouping to make large datasets immediately readable.

Can I add custom formulas to the analysis?

The skill supports calculated fields, allowing you to define custom formulas such as profit margins, growth percentages, or weighted averages.

Can it handle multiple aggregation types?

Yes, the skill can simultaneously calculate sums, averages, counts, and other metrics within a single pivot table structure.

Excel Pivot Wizard

Name: Excel Pivot Wizard
Author: BbgnsurfTech

byBbgnsurfTech

•

Ciencia de Datos y ML

Automates the creation of complex Excel pivot tables and data visualizations using natural language commands.

Acerca de

The Excel Pivot Wizard is a specialized skill for Claude Code that transforms raw datasets into actionable insights through automated pivot table generation and professional visualization. It intelligently maps natural language requests—such as 'analyze sales by region' or 'show monthly revenue trends'—into structured Excel operations, handling row/column groupings, aggregations, calculated fields, and conditional formatting. This skill is ideal for business analysts and data managers who need to perform rapid cross-tabulation, time-series analysis, or top-N reporting without manually navigating Excel's complex menus.

Características Principales

Advanced calculated fields for custom metrics like profit margins
Natural language data summarization and cross-tabulation
3 GitHub stars
Automatic chart generation including column, line, and combo charts
Automated slicer and filter integration for interactive reporting
Professional formatting with conditional highlighting and heatmaps

Casos de Uso

Performing product-level revenue rankings and Pareto analysis to identify top drivers
Analyzing customer segments to identify high-value groups and average order values
Generating monthly sales performance reports with regional breakdowns and growth trends

Acerca de

Características Principales

Advanced calculated fields for custom metrics like profit margins
Natural language data summarization and cross-tabulation
3 GitHub stars
Automatic chart generation including column, line, and combo charts
Automated slicer and filter integration for interactive reporting
Professional formatting with conditional highlighting and heatmaps

Casos de Uso

Performing product-level revenue rankings and Pareto analysis to identify top drivers
Analyzing customer segments to identify high-value groups and average order values
Generating monthly sales performance reports with regional breakdowns and growth trends