jukeyman/jukeyman-skills/business-tools-excel-analyst-pro-excel-pivot-wizard

Claude Code and agent skill by jukeyman/jukeyman-skills

Trust tier 3
  • community
Source check pending

Checking that the SKILL.md file is still in the repository.

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'.

Install

npx vskill@latest install jukeyman/jukeyman-skills/business-tools-excel-analyst-pro-excel-pivot-wizard

SKILL.md

The same SKILL.md was published earlier as jukeyman/jukeyman-skills/business-tools-excel-analyst-pro-excel-pivot-wizard.

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

Security

  • Security scanPassed, 90 of 100Pattern checks on the skill's files.
  • Model reviewPassed

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

Source

Popularity

Repository stars
1
7-day trend score
8

Stars and forks are for the whole GitHub repository, not this skill alone. Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/jukeyman/jukeyman-skills/business-tools-excel-analyst-pro-excel-pivot-wizard/badge)](https://verified-skill.com/skills/jukeyman/jukeyman-skills/business-tools-excel-analyst-pro-excel-pivot-wizard)

Something wrong with this skill or its page? Tell us.