From excel-analyst-pro
Creates advanced Excel pivot tables with calculated fields, slicers, and dashboard formatting for data analysis, summaries, and interactive reporting.
npx claudepluginhub jeremylongshore/claude-code-plugins-plus-skillsThis skill is limited to using the following tools:
Creates advanced pivot tables with calculated fields, slicers, and dynamic dashboards for data analysis and reporting.
Generates code and configurations for pivot table creation in data analytics workflows with SQL queries, visualization, statistics, and BI. Auto-activates on 'pivot table creator' phrases.
Automates Excel workflows on Windows via CLI for CI/CD pipelines, scheduled tasks, bulk data processing, and coding agents. Supports Power Query, DAX, PivotTables, Tables, Ranges, Charts, VBA.
Generates professional Excel spreadsheets with charts, conditional formatting, sparklines, summaries, and filters for data organization, analysis, and presentation.
Share bugs, ideas, or general feedback.
Creates advanced pivot tables with calculated fields, slicers, and dynamic dashboards for data analysis and reporting.
| 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 |
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
${CLAUDE_SKILL_DIR}/references/pivot-formulas.md for calculated field syntax