Agent skill

excel

Advanced Excel and spreadsheet analytics techniques

View SKILL.md on GitHub Repository
Stars 1
Forks 0

Install this agent skill to your Project

npx add-skill https://github.com/pluginagentmarketplace/custom-plugin-data-analyst/tree/main/skills/excel

SKILL.md

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)

Recommended Agent Skills

Expand your agent's capabilities with these related and highly-rated skills.

pluginagentmarketplace/custom-plugin-data-analyst

business-intelligence

BI tools, dashboards, and enterprise analytics platforms

1 0
Explore
pluginagentmarketplace/custom-plugin-data-analyst

databases-sql

SQL database querying, optimization, and data management for analytics

1 0
Explore
pluginagentmarketplace/custom-plugin-data-analyst

visualization

Data visualization design, tools, and storytelling for impactful analytics presentations

1 0
Explore
pluginagentmarketplace/custom-plugin-data-analyst

data-analytics-foundations

Core data analytics concepts, Excel/Google Sheets fundamentals, and data collection techniques

1 0
Explore
pluginagentmarketplace/custom-plugin-data-analyst

advanced-analytics

Advanced analytics including machine learning, predictive modeling, and big data techniques

1 0
Explore
pluginagentmarketplace/custom-plugin-data-analyst

statistics

Statistical analysis methods, hypothesis testing, and probability for data analytics

1 0
Explore

Didn't find tool you were looking for?

Be as detailed as possible for better results