# Excel

> Advanced Excel and spreadsheet analytics techniques

- Skill: `pluginagentmarketplace/excel` (Agent Skill, multi-file: 6 files)
- Install (CLI): `npx skillmds@latest add pluginagentmarketplace/excel`
- Raw SKILL.md: https://api.skillmd.com/api/skills/pluginagentmarketplace/excel/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: pluginagentmarketplace (https://skillmd.com/u/pluginagentmarketplace)
- Updated: 2026-09-10
- Page: https://skillmd.com/skills/pluginagentmarketplace/excel

---


# 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)