skillZs
★ LIVE SKILL TAGS ★
>>> LIVE SKILLS INDEX <<<
* OPEN SOURCE *
NO LOGIN, NO TRACKING
※ REAL INSTALL DATA ※
← back to all skills
jst-well-dan/skill-box87 installs

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

How do I install this agent skill?

npx skills add https://github.com/jst-well-dan/skill-box --skill excel-pivot-wizard
view source ↗

Is this agent skill safe to install?

  • Gen Agent Trust Hubpass

    The skill is generally safe but possesses a surface for indirect prompt injection because it processes external tabular data while having access to powerful system tools like Bash.

  • Socketpass

    No alerts

  • Snykpass

    Risk: LOW · No issues

  • Runlayerpass

    1/5 files flagged

What does this agent skill do?

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

Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.

<a href="https://skillzs.dev/skills/jst-well-dan/skill-box/excel-pivot-wizard">View excel-pivot-wizard on skillZs</a>