excel-pivot-wizard_skill

Overview

This skill creates advanced Excel pivot tables with calculated fields, slicers, and dashboard-ready formatting. It helps turn tabular data into interactive summaries for analysis and reporting. Use it to automate pivot creation, add custom metrics, and build filters for exploration.

How this skill works

The skill inspects a tabular data range with headers and builds a pivot table mapping rows, columns, values, and filters to your requested dimensions. It can add calculated fields for derived metrics, insert slicers for interactive filtering, and apply formatting to make the result presentation-ready. It also validates field names and suggests fixes when source columns change.

When to use it

• Summarizing large datasets by groups (e.g., sales by region and product)
• Creating interactive dashboards with slicers for stakeholders
• Adding custom metrics like growth rates or margins via calculated fields
• Preparing presentation-ready reports with consistent formatting
• Exploring time-series trends and comparing periods (monthly, quarterly)

Best practices

• Ensure your source data is a clean table with consistent headers before running the skill
• Decide which columns are dimensions (rows/columns) and which are measures (values) up front
• Use explicit field names in calculated formulas and refresh if source names change
• Limit slicers to the most useful fields to avoid clutter and slow performance
• Validate calculated field formulas with a small sample before applying to full dataset

Example use cases

• Create a sales dashboard: region as rows, product as columns, sum of revenue as values, and a date slicer
• Build a financial summary: cost centers as rows, monthly totals as values, plus YoY growth calculated field
• Generate an operations report: supplier and category breakdowns with interactive slicers for status and priority
• Produce an executive summary pivot that is formatted and ready for export to PowerPoint