Does this skill help with Power Query?

Yes, it provides specific guidance and M code examples for building ETL processes, including data cleaning, filtering, and merging.

Will Claude be able to write the M code for me?

Yes, this skill provides structured patterns for generating M code to automate repeatable data transformation tasks.

Can I use this for complex financial modeling?

Absolutely. The skill includes advanced formulas like INDEX/MATCH, SUMIFS, and financial best practices for creating robust models.

How does this help with data cleaning?

It offers automated workflows for removing duplicates, splitting columns, and normalizing data using both native Excel functions and Power Query.

Excel Data Analysis

Name: Excel Data Analysis
Author: spjoshis

byspjoshis

•

Data Science & ML

Simplifies complex data analysis in Excel using advanced formulas, Pivot Tables, and Power Query automation.

The excel-analysis skill empowers Claude to assist with sophisticated data manipulation and business intelligence within Microsoft Excel. It provides comprehensive guidance on building dynamic Pivot Tables, writing complex formulas like INDEX/MATCH and SUMIFS, and implementing ETL processes using Power Query's M language. This skill is ideal for professionals needing to transform raw datasets into actionable insights, automate reporting workflows, or perform ad-hoc financial modeling with industry-standard best practices.

Key Features

01Power Query ETL automation and M code generation

021 GitHub stars

03Advanced Pivot Table configuration and calculated fields

04Data cleaning and transformation workflows for large datasets

05Complex formula construction including VLOOKUP, INDEX/MATCH, and Array formulas

06Implementation of Excel best practices for scalability and documentation

Use Cases

01Automating monthly financial reporting and sales performance analysis

02Building interactive business dashboards and stakeholder-ready reports

03Cleaning and normalizing messy raw data from CSV or external sources

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add spjoshis/claude-code-plugins excel-analysis

For use in Claude.ai and ChatGPT

Download Skill