---

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

Related Skills

• foundations (for core concepts)
• visualization (for chart design)
• reporting (for automated delivery)