Skill

excel-pivot-wizard

Creates advanced Excel pivot tables with calculated fields, slicers, and dashboard formatting for data analysis, summaries, and interactive reporting.

data-engineering

From excel-analyst-pro

Install

Run in your terminal

npx claudepluginhub nickloveinvesting/nick-love-plugins --plugin excel-analyst-pro

Tool Access

This skill is limited to using the following tools:

ReadWriteEditGrepGlobBash(cmd:*)

Supporting Assets

View in Repository

assets/README.md

references/README.md

references/pivot-formulas.md

scripts/README.md

Skill Content

Similar Skills

ui-ux-pro-max

Provides UI/UX resources: 50+ styles, color palettes, font pairings, guidelines, charts for web/mobile across React, Next.js, Vue, Svelte, Tailwind, React Native, Flutter. Aids planning, building, reviewing interfaces.

ui-ux-pro-max

57.6k

context7-mcp

Fetches up-to-date documentation from Context7 for libraries and frameworks like React, Next.js, Prisma. Use for setup questions, API references, and code examples.

context7-plugin

51.4k

market-sizing-analysis

2 files

Calculates TAM/SAM/SOM using top-down, bottom-up, and value theory methodologies for market sizing, revenue estimation, and startup validation.

startup-business-analyst

32.9k

Stats

Parent Repo Stars0

Parent Repo Forks0

Last CommitMar 20, 2026

Actions

View Source View Plugin View on GitHub View README

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
${CLAUDE_SKILL_DIR}/references/pivot-formulas.md for calculated field syntax