CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

excel-pivot-wizard

Create advanced Excel pivot tables with calculated fields and slicers. Use when building data summaries or creating interactive dashboards. Trigger with phrases like 'excel pivot', 'create pivot table', 'data summary'.

Quality

72%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./plugins/business-tools/excel-analyst-pro/skills/excel-pivot-wizard/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

50%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

The body is well-organized with sensible progressive disclosure and a real, relevant reference file, but the actual instructions are high-level directions rather than executable guidance, and the workflow lacks validation checkpoints. It reads more like a capability checklist than an operational playbook.

Suggestions

Make instructions executable: name the concrete mechanism for creating the pivot (e.g., a specific library, script, or openpyxl/xlsxwriter workflow) and show a runnable snippet or command instead of directions like "Create pivot table from data range".

Add validation checkpoints to the workflow, e.g., after creating the pivot verify the field list matches the source headers, and after adding calculated fields confirm the formula references resolve before styling.

Trim the Prerequisites section ("Clear understanding of analysis dimensions and measures" is filler Claude does not need) and the generic Output section, which duplicates what the Instructions already imply.

DimensionReasoningScore

Conciseness

The body is mostly efficient with short sections and no basic-concept explanations, but the Prerequisites list ("Clear understanding of analysis dimensions and measures") and the generic Output section add padding that could be tightened, matching the anchor for mostly efficient with some unnecessary content.

3 / 5

Actionability

Instructions like "Create pivot table from data range", "Configure rows, columns, values, and filters", and "Insert slicers" are high-level hints naming no tool, library, command, or mechanism, matching the anchor for minimal concrete guidance missing the specific steps to execute; the concrete formula syntax lives only in the referenced file, not the body.

2 / 5

Workflow Clarity

The six instructions form a coherent sequence (verify data, build, configure, add fields, insert slicers, format), but there are no validation checkpoints anywhere in the flow; the Error Handling table is after-the-fact troubleshooting rather than in-workflow validation, matching the anchor for steps listed with validation gaps.

3 / 5

Progressive Disclosure

The ~50-line body is a well-sectioned overview that points to a single one-level-deep reference ([`references/pivot-formulas.md`] for calculated field syntax, verified to exist and be relevant), with the Resources section clearly signaling each link's purpose; this matches the anchor for a clear overview with well-signaled shallow references.

5 / 5

Total

13

/

20

Passed

Description

83%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong description that clearly states capabilities, an explicit use-when clause, and concrete trigger phrases in third-person voice. Its only weaknesses are slightly incomplete keyword coverage (no spreadsheet/.xlsx synonyms) and mild overlap risk from the broad "data summary" and "interactive dashboards" terms.

DimensionReasoningScore

Specificity

"Create advanced Excel pivot tables with calculated fields and slicers" lists several concrete capabilities (pivot tables, calculated fields, slicers, dashboards), matching the anchor for several specific actions with minor gaps; it falls short of 5 because coverage is not comprehensive and "advanced" is a mild qualifier rather than an action.

4 / 5

Completeness

It explicitly answers what ("Create advanced Excel pivot tables with calculated fields and slicers") and when ("Use when building data summaries or creating interactive dashboards"), plus concrete trigger phrases, mirroring the anchor-5 example structure; a 4 would require the when-clause to be weaker or less explicit, which is not the case.

5 / 5

Trigger Term Quality

"excel pivot", "create pivot table", "data summary" are phrases users would naturally say, giving good keyword coverage, but common variations like "spreadsheet", ".xlsx", "Excel file", or "summarize data" are missing, so it does not reach the comprehensive synonym/extension level of a 5.

4 / 5

Distinctiveness Conflict Risk

"excel pivot" and "create pivot table" are distinct triggers for a clear niche, but "data summary" and "interactive dashboards" are broad enough to overlap with generic data-analysis or dashboard skills, indicating minor overlap risk rather than minimal.

4 / 5

Total

17

/

20

Passed

Validation

87%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 14 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

allowed_tools_field

'allowed-tools' contains unusual tool name(s)

Warning

frontmatter_unknown_keys

Unknown frontmatter key(s) found; consider removing or moving to metadata

Warning

Total

14

/

16

Passed

Repository

jeremylongshore/tons-of-skills-marketplace

Path

plugins/business-tools/excel-analyst-pro/skills/excel-pivot-wizard/SKILL.md

Reviewed

Table of Contents

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.