| 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 |
| config | [object Object] |
| parameters | [object Object] |
| observability | [object Object] |
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)