Marketplace
excel
Advanced Excel and spreadsheet analytics techniques
$ インストール
git clone https://github.com/pluginagentmarketplace/custom-plugin-data-analyst /tmp/custom-plugin-data-analyst && cp -r /tmp/custom-plugin-data-analyst/skills/excel ~/.claude/skills/custom-plugin-data-analyst// tip: Run this command in your terminal to install the skill
SKILL.md
name: excel description: Advanced Excel and spreadsheet analytics techniques version: "2.0.0" sasmp_version: "2.0.0" bonded_agent: 01-data-analytics-foundations bond_type: SECONDARY_BOND
Skill Configuration
config: atomic: true retry_enabled: true max_retries: 3 backoff_strategy: exponential
Parameter Validation
parameters: skill_level: type: string required: true enum: [beginner, intermediate, advanced] default: beginner focus_area: type: string required: false enum: [formulas, pivots, power_query, charts, all] default: all
Observability
observability: logging_level: info metrics: [formula_complexity, pivot_usage, automation_level]
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)
Repository
pluginagentmarketplace
Author
pluginagentmarketplace/custom-plugin-data-analyst/skills/excel
1
Stars
0
Forks
Updated14h ago
Added6d ago