Jst-Well-Dan/excel-pivot-wizard
business-analyst/excel-pivot-wizard/SKILL.md
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 --global
skillsauthnpx skillsauth add Jst-Well-Dan/Skill-Box excel-pivot-wizardInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 24, 2026, 8:39 PM1.8s1 file scanned
SKILL.md
- name:
- excel-pivot-wizard
- description:
- |
- allowed-tools:
- Read, Write, Edit, Grep, Glob, Bash(cmd:*)
- version:
- 1.0.0
- author:
- Jeremy Longshore <[email protected]>
- license:
- MIT
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
- Verify source data is in tabular format with headers
- Create pivot table from data range
- Configure rows, columns, values, and filters
- Add calculated fields for custom metrics
- Insert slicers for interactive filtering
- 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
| Error | Cause | Solution | |-------|-------|----------| | Field not found | Changed source data | Refresh data connection | | Calculated field error | Invalid formula | Check field names match exactly | | Slicer not updating | Disconnected report | Reconnect 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
- Microsoft Pivot Table Guide
{baseDir}/references/pivot-formulas.mdfor calculated field syntax
Related Skills
Jst-Well-Dan/video-frames
tools
VerifiedTrustedCommunity
Extract frames or short clips from videos using ffmpeg.
7SKILL.mdUpdated Apr 6, 2026
Jst-Well-Dan/theme-factory
tools
VerifiedTrustedCommunity
Toolkit for styling artifacts with a theme. These artifacts can be slides, docs, reportings, HTML landing pages, etc. There are 10 pre-set themes with colors/fonts that you can apply to any artifact that has been creating, or can generate a new theme on-the-fly.
7SKILL.mdUpdated Apr 6, 2026
Jst-Well-Dan/slack-gif-creator
tools
VerifiedTrustedCommunity
Toolkit for creating animated GIFs optimized for Slack, with validators for size constraints and composable animation primitives. This skill applies when users request animated GIFs or emoji animations for Slack from descriptions like "make me a GIF for Slack of X doing Y".
7SKILL.mdUpdated Apr 6, 2026
Jst-Well-Dan/remotion-best-practices
development
VerifiedTrustedCommunity
Best practices for Remotion - Video creation in React
7SKILL.mdUpdated Apr 6, 2026