agentsclimarketplace

Excel pivot wizard

Skill jeremylongshore/claude-code-plugins-plus-skills/plugins/business-tools/excel-analyst-pro/skills/excel-pivot-wizard

425 plugins, 2,810 skills, 200 agents for Claude Code. Open-source marketplace at tonsofskills.com with the ccpi CLI package manager.

Install
npx -y skills add jeremylongshore/claude-code-plugins-plus-skills --skill excel-pivot-wizard

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

What its author says it does

Copied from the file, not written here

'Create advanced Excel pivot tables with calculated fields and slicers.

The file declares its own license as MIT. That is the author’s claim about this one file, and it is not the same thing as the license GitHub reports for the repository, which is listed with the other numbers below.

SKILL.md

2.1 KB, as published. Nobody here has run it

Excel Pivot Wizard

Overview

Creates advanced pivot tables with calculated fields, slicers, and dynamic dashboards for data analysis and reporting.

Prerequisites

  • Excel or compatible spreadsheet software
  • Tabular data with headers
  • Clear understanding of analysis dimensions and measures

Instructions

  1. Verify source data is in tabular format with headers
  2. Create pivot table from data range
  3. Configure rows, columns, values, and filters
  4. Add calculated fields for custom metrics
  5. Insert slicers for interactive filtering
  6. Format and style for presentation

Output

  • Configured pivot table with appropriate aggregations
  • Calculated fields for derived metrics
  • Interactive slicers for filtering
  • Dashboard-ready formatting

Error Handling

ErrorCauseSolution
Field not foundChanged source dataRefresh data connection
Calculated field errorInvalid formulaCheck field names match exactly
Slicer not updatingDisconnected reportReconnect slicer to pivot

Examples

Example: Sales Dashboard Request: "Create a pivot summarizing sales by region and product" Result: Pivot with region rows, product columns, revenue values, and date slicer

Example: Financial Analysis Request: "Build a pivot showing monthly trends by cost center" Result: Time-series pivot with calculated YoY growth fields

Resources

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.