excel-pivot-wizard

Generate pivot tables and charts from raw data using natural language - analyze sales by region, summarize data by category, and create visualizations effortlessly

Install with Tessl CLI

npx tessl i github:jeremylongshore/claude-code-plugins-plus-skills --skill excel-pivot-wizard

What are skills?

1.29x

Quality

47%

Does it follow best practices?

Impact

87%

1.29x

Average score across 6 eval scenarios

Optimize this skill with Tessl

npx tessl skill review --optimize ./backups/skills-migration-20251108-070147/plugins/business-tools/excel-analyst-pro/skills/excel-pivot-wizard/SKILL.md

SKILL.md

Review

Evals

Evaluation results

80%

28%

Regional Sales Performance Analysis

Number formatting and chart type selection

Criteria

Without context

With context

Millions abbreviation

Thousands separator for counts

100%

Percentage decimal precision

100%

Column chart for comparison

100%

Top performers green

100%

Bottom performers red

100%

Key insights section

100%

Grand total row

100%

Bold or header emphasis

100%

Largest to smallest sorting

Without context: $0.3388 · 1m 27s · 17 turns · 18 in / 5,760 out tokens

With context: $0.6974 · 2m 22s · 25 turns · 181 in / 9,437 out tokens

80%

10%

Product Line Profitability Dashboard

Calculated fields and pivot structure parsing

Criteria

Without context

With context

Profit margin formula

100%

Growth % formula

100%

Percent of total formula

100%

Explicit pivot structure

Largest to smallest sort

100%

Grand total row

100%

Percentage decimal precision

100%

Formula labels in output

100%

Millions abbreviation

Key insights

100%

Without context: $0.3886 · 1m 28s · 21 turns · 22 in / 6,082 out tokens

With context: $0.7730 · 2m 43s · 28 turns · 28 in / 10,228 out tokens

74%

18%

E-Commerce Product Revenue Ranking

Top N analysis and layout conventions

Criteria

Without context

With context

Rank column

100%

Percent of total column

100%

All Others row

100%

Grand total row

100%

Largest to smallest sort

100%

Millions abbreviation

Percentage decimal precision

100%

Column or bar chart

Key insights section

100%

Thousands separator for units

Top 10 subtotal row

100%

Without context: $0.2224 · 1m · 11 turns · 12 in / 3,531 out tokens

With context: $0.4704 · 1m 40s · 22 turns · 94 in / 6,310 out tokens

100%

Monthly Revenue Trend Report

Time trend analysis and chronological sorting

Criteria

Without context

With context

Chronological month order

100%

Line chart recommendation

100%

Trend line in chart

100%

Data labels on chart

100%

Period-over-period growth rates

100%

Best and worst month identified

100%

Overall growth rate stated

100%

Thousands separator for revenue

100%

Percentage decimal precision

100%

At least 3 key findings

100%

Without context: $0.1561 · 49s · 9 turns · 10 in / 2,510 out tokens

With context: $0.5033 · 1m 37s · 22 turns · 360 in / 5,576 out tokens

100%

27%

Customer Satisfaction Cross-Analysis

Cross-tabulation and heatmap conditional formatting

Criteria

Without context

With context

Cross-tab table structure

100%

Explicit pivot structure labeled

30%

100%

Color gradient heatmap

100%

Top 10% dark green

100%

Bottom 10% dark red

100%

Slicers linked to pivot

100%

Grand totals included

50%

100%

Percentage decimal precision

100%

At least 2 key findings

100%

Best and worst cell identified

100%

Without context: $0.1592 · 51s · 8 turns · 9 in / 2,667 out tokens

With context: $0.5479 · 2m 4s · 23 turns · 56 in / 6,562 out tokens

92%

23%

Marketing Channel Performance Report

Multiple aggregations and composition visualization

Criteria

Without context

With context

Multiple aggregations in one table

100%

Combo chart for multi-metric

100%

Pie or donut chart for composition

100%

Thousands separator in spend

100%

Percentage decimal precision

100%

Grand total row

100%

Percent of total column

30%

100%

Largest to smallest sort

At least 2 key findings

100%

Column axis and line axis distinguished

100%

Without context: $0.1206 · 40s · 8 turns · 9 in / 2,254 out tokens

With context: $0.4812 · 1m 43s · 21 turns · 310 in / 5,701 out tokens

Evaluated: 5 days ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Regional Sales Performance Analysis Product Line Profitability Dashboard E-Commerce Product Revenue Ranking Monthly Revenue Trend Report Customer Satisfaction Cross-Analysis Marketing Channel Performance Report

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.