Can it handle multiple dimensions?

Yes, it supports cross-tabulation, allowing you to group data by multiple rows and columns simultaneously for deeper analysis.

Is professional formatting applied automatically?

Yes, it automatically applies currency formatting, bold headers, and conditional formatting like heatmaps to make the data readable.

How do I trigger the Excel Pivot Wizard?

Simply ask Claude to 'create a pivot table' or use phrases like 'analyze data by category' while working with an Excel file.

Does it create actual charts in Excel?

Yes, it can generate various visualizations including bar, line, and pie charts based on the summarized data from your pivot table.

Can I add custom formulas like Profit Margin?

Absolutely, the skill supports calculated fields such as profit margins, growth percentages, and other custom aggregation formulas.

Excel Pivot Wizard

Name: Excel Pivot Wizard
Author: BbgnsurfTech

byBbgnsurfTech

•

Analytics & Monitoring

Generates complex Excel pivot tables and visual charts from raw data using natural language commands.

About

Excel Pivot Wizard empowers users to transform raw datasets into actionable insights by automating the creation of pivot tables, cross-tabulations, and data visualizations. By translating natural language requests like 'show revenue by region' into structured Excel commands, this skill handles aggregation functions, calculated fields, and professional formatting. It is an essential tool for business analysts and developers who need to generate rapid data summaries, trend analyses, and performance reports without manual spreadsheet manipulation.

Key Features

Custom calculated fields and aggregation functions
Professional conditional formatting and layout styling
Multi-dimensional cross-tabulation and grouping
Natural language to pivot table conversion
3 GitHub stars
Automated chart generation including Line, Bar, and Pie charts

Use Cases

Performing Top-N analysis to identify high-performing products or customers
Summarizing sales performance across multiple regions and product categories
Analyzing time-based revenue trends and growth rates

About

Key Features

Custom calculated fields and aggregation functions
Professional conditional formatting and layout styling
Multi-dimensional cross-tabulation and grouping
Natural language to pivot table conversion
3 GitHub stars
Automated chart generation including Line, Bar, and Pie charts

Use Cases

Performing Top-N analysis to identify high-performing products or customers
Summarizing sales performance across multiple regions and product categories
Analyzing time-based revenue trends and growth rates