How do I trigger the Excel Pivot Wizard?

Simply ask Claude to 'Create a pivot table', 'Analyze sales data', or use specific phrases like 'Show revenue breakdown by region' to activate the skill.

Does it require specific column headers to work?

The skill uses natural language processing to identify your data fields; however, clear headers help it more accurately map rows, columns, and values.

Can it handle custom formulas and calculated fields?

Yes, it can create custom calculated fields such as Profit Margin % or YOY Growth based on the existing columns in your dataset.

What types of visualizations can this skill create?

The skill can generate various charts including column, bar, line, pie, and combo charts, along with conditional formatting for heatmap effects.

Excel Pivot Wizard

Name: Excel Pivot Wizard
Author: intent-solutions-io

byintent-solutions-io

数据科学与机器学习

Generates professional Excel pivot tables and visualizations from raw data using natural language commands.

关于

Excel Pivot Wizard is a specialized Claude Code Skill designed to transform raw datasets into actionable insights through automated pivot table creation and data visualization. By translating natural language requests into structured analysis, it handles row/column grouping, complex aggregations, and professional formatting, making it indispensable for business analysts and developers who need to summarize large volumes of data without manual Excel configuration. The skill automatically interprets the grain of your data and suggests the most effective visualizations—from trend lines to heatmaps—to highlight key performance indicators.

主要功能

Natural language to pivot table structure translation
Interactive slicer and filter integration for dynamic reports
Automated chart generation including bar, line, and Pareto charts
Support for calculated fields and complex aggregation functions
Professional styling with conditional formatting and heatmaps
0 GitHub stars

使用场景

Performing customer segmentation and average order value (AOV) deep-dives
Generating automated monthly revenue trend reports and growth analysis
Summarizing sales performance across multiple regions and product categories

关于

主要功能

Natural language to pivot table structure translation
Interactive slicer and filter integration for dynamic reports
Automated chart generation including bar, line, and Pareto charts
Support for calculated fields and complex aggregation functions
Professional styling with conditional formatting and heatmaps
0 GitHub stars

使用场景

Performing customer segmentation and average order value (AOV) deep-dives
Generating automated monthly revenue trend reports and growth analysis
Summarizing sales performance across multiple regions and product categories