excel-pivot-wizard
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
More from jst-well-dan/skill-box
advanced-video-downloader
Download and transcribe videos from YouTube, Bilibili, TikTok and 1000+ platforms. Use when user requests video download, transcription (转录/字幕提取), or converting video to text/markdown. Supports quality selection, audio extraction, playlist downloads, cookie-based authentication, and AI-powered transcription via SiliconFlow API (免费转录).
75baoyu-post-to-wechat
Posts content to WeChat Official Account (微信公众号) via Chrome CDP automation. Supports article posting (文章) with full markdown formatting and image-text posting (图文) with multiple images. Use when user mentions "发布公众号", "post to wechat", "微信公众号", or "图文/文章".
61baoyu-xhs-images
Generates Xiaohongshu (Little Red Book) infographic series with 9 visual styles and 6 layouts. Breaks content into 1-10 cartoon-style images optimized for XHS engagement. Use when user mentions "小红书图片", "XHS images", "RedNote infographics", "小红书种草", or wants social media infographics for Chinese platforms.
58excel-dcf-modeler
|
47invoice-processor
Automatically process invoices (发票) from PDFs/images to Excel spreadsheets using AI vision recognition. Use this skill when users mention "发票", "invoice", "处理发票", "识别发票", "提取发票", or need to convert invoice files to Excel format.
34development-brainstorming
Use when planning software development tasks, before writing code or implementation plans - refines rough technical ideas into fully-formed designs through collaborative questioning, alternative exploration, and incremental validation. For software architecture, components, data flow, and technical design decisions. Don't use during clear 'mechanical' coding processes
31