excel-pivot-wizard

Name: excel-pivot-wizard
Author: jst-well-dan

github.com/jst-well-danData & databases1087 installsUpdated 31w ago

About excel-pivot-wizard

Excel Pivot Wizard is a guide for building pivot tables for analysis and reporting, including calculated fields, slicers, and dashboard-ready formatting.

Key features

01Create and configure pivot tables
02Add calculated fields and custom metrics
03Insert slicers for interactive filtering
04Format results for presentation

Use cases

01Summarize sales by region and product
02Review monthly trends by cost center
03Prepare interactive pivots for data reports

Install

Copy the command and run it in a terminal.

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

After installing, type/excel-pivot-wizardin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

assets/

README.md

references/

pivot-formulas.md

README.md

scripts/

README.md

Details

From the project 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
{baseDir}/references/pivot-formulas.md for calculated field syntax

Comments

Markdown supported

Details

Author: jst-well-dan
Repository: jst-well-dan/skill-box
Category: Data & databases
Installs: 87
GitHub stars: 10

Report

More skills

All skills

hyperframes-core

github.com/heygen-com

930.6k

The HyperFrames composition contract — build one renderable project. Use for composition structure, the `data-*` timing attributes, `class="clip"`, tracks, sub-compositions, variables, framework-owned media playback, deterministic-render rules, and validation. Also covers Tailwind projects and the STORYBOARD.md / SCRIPT.md plan formats. Read before writing composition HTML.

lark-base

open.feishu.cn

823.2k

Operate on Feishu Base: create tables, fields, records, and views; handle statistics, formulas/lookups, forms, dashboards, app mode (BaseApp/AppMode pages and components), Workspace directories, workflows, role permissions, and the template center (Base template categories, lists, and search). Use when encountering Base/multidimensional tables/bitable, BaseApp/AppMode, or /base/ or /app/ links. Do not use lark-apps for BaseApp; route file import/export to lark-drive and authentication/authorization to lark-shared.

lark-sheets

open.feishu.cn

821.8k

Feishu Spreadsheets: create and operate spreadsheets. Supports worksheets and row/column structures (add/delete/merge/size/hide/freeze/group), cell read/write (values/formulas/styles/comments/cell images), range copy/move/sort/fill, find and replace, bulk updates, and creating and maintaining objects such as charts, pivot tables, conditional formatting, filters and filter views, dropdown lists, sparklines, and floating images. Also supports formula validation, restoring historical versions, and importing/exporting local Excel/CSV files and Feishu spreadsheets. Use when users need to create or edit spreadsheets, summarize and visualize data, format spreadsheets, calculate formulas (including migrating Excel formulas), or build financial models (DCF, three statements, budgets, Sensitivity, etc.). For multidimensional tables (Base/bitable), use lark-base. If users want to search for spreadsheet files in cloud storage (Drive/cloud storage) by name or keyword, use lark-drive's drive +search to locate resources first. When users provide a doubao.com /sheets/ URL/token, use this skill directly; do not fall back to WebFetch because the domain is not Feishu. Routing is based on the URL path pattern and token, not the domain.

remotion-best-practices

github.com/remotion-dev

701.4k

Best practices and domain knowledge for building videos programmatically with Remotion (videos in React/TypeScript, rendered to MP4). Use whenever writing or editing Remotion code — scaffolding a video project, animating with interpolate/spring over useCurrentFrame(), sequencing scenes and transitions, captions/subtitles, audio, GIFs/Lottie/3D, charts, visual effects, dynamic duration via calculateMetadata, or rendering. Consult before reaching for a Remotion API, since its components and props evolve (e.g. @remotion/media).