Advanced Excel and spreadsheet analytics techniques
Executes advanced Excel operations including pivot tables, XLOOKUP, and Power Query when analyzing spreadsheet data. Automatically resolves common errors like #REF! and #N/A with optimized formulas.
/plugin marketplace add pluginagentmarketplace/custom-plugin-data-analyst/plugin install data-analyst-roadmap@pluginagentmarketplace-data-analystThis skill inherits all available tools. When active, it can use any tool Claude has access to.
assets/config.yamlassets/schema.jsonreferences/GUIDE.mdreferences/PATTERNS.mdscripts/validate.pyMaster advanced Excel techniques for professional data analysis and reporting.
| Error Type | Cause | Recovery |
|---|---|---|
| #REF! error | Broken cell reference | Check and update references |
| #N/A error | Lookup not found | Use IFERROR wrapper |
| Slow calculation | Too many formulas | Convert to values, optimize |
| File corruption | Crash during save | Enable AutoRecover, use cloud backup |
Use when working with Payload CMS projects (payload.config.ts, collections, fields, hooks, access control, Payload API). Use when debugging validation errors, security issues, relationship queries, transactions, or hook behavior.
Applies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply.
Creating algorithmic art using p5.js with seeded randomness and interactive parameter exploration. Use this when users request creating art using code, generative art, algorithmic art, flow fields, or particle systems. Create original algorithmic art rather than copying existing artists' work to avoid copyright violations.