excel

majiayu000 的头像作者 majiayu000

Advanced Excel and spreadsheet analytics techniques

📖 中文导读:Advanced Excel and spreadsheet analytics techniques 以下正文为该技能的原始 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
  • foundations (for core concepts)
  • visualization (for chart design)
  • reporting (for automated delivery)