Excel
Skill pluginagentmarketplace/custom-plugin-data-analyst/skills/excel
Advanced Excel and spreadsheet analytics techniquesFrom its SKILL.md
npx -y skills add pluginagentmarketplace/custom-plugin-data-analyst --skill excelAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
2 things to look at
- no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
- 1 stars1 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
SKILL.md
1.6 KB, as published. Nobody here has run it
Excel Analytics Skill
Overview
Master advanced Excel techniques for professional data analysis and reporting.
Topics Covered
- Pivot tables and advanced filtering
- VLOOKUP, XLOOKUP, INDEX-MATCH
- Power Query and data transformation
- Excel formulas for analysis
- Charts and conditional formatting
Learning Outcomes
- Master advanced Excel functions
- Build dynamic pivot tables
- Create automated reports
- Transform data with Power Query
Error Handling
| 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 |
Related Skills
- foundations (for core concepts)
- visualization (for chart design)
- reporting (for automated delivery)