excel
Installation
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
Related skills
More from pluginagentmarketplace/custom-plugin-data-analyst
python-analytics
Python data analysis with pandas, numpy, and analytics libraries
80data-analytics-foundations
Core data analytics concepts, Excel/Google Sheets fundamentals, and data collection techniques
24data-cleaning
Data cleaning, preprocessing, and quality assurance techniques
20reporting
Automated reporting and business intelligence delivery
11visualization
Data visualization design, tools, and storytelling for impactful analytics presentations
9programming
Python and R programming for data analysis, automation, and reproducible analytics
7