Does this skill support complex Excel formulas?

Yes, it supports full formula creation and uses a dedicated recalculation script to ensure all logic is processed correctly and error-free.

What file formats are supported?

It supports .xlsx, .xlsm, .csv, and .tsv formats for reading, writing, and editing operations.

Can it handle professional financial modeling standards?

Absolutely. It follows industry-standard color coding (blue for inputs, black for formulas) and ensures assumptions are placed in separate cells rather than hardcoded.

Will it break my existing Excel formatting?

No, the skill is designed to study and exactly match existing formats, styles, and conventions when modifying your templates.

How does it prevent formula errors like #REF! or #DIV/0!?

It utilizes a 'recalc.py' script powered by LibreOffice to scan all cells for errors after modification, providing a detailed report for any necessary fixes.

Excel & Spreadsheet Mastery

Name: Excel & Spreadsheet Mastery
Author: ttmouse

byttmouse

•

Data Science & ML

Automates comprehensive spreadsheet creation, financial modeling, and data analysis while ensuring zero formula errors and industry-standard formatting.

This skill enables Claude to perform professional-grade spreadsheet operations, ranging from simple data entry to complex financial modeling and data visualization. It supports a wide array of formats including .xlsx, .xlsm, .csv, and .tsv, utilizing powerful libraries like pandas for data manipulation and openpyxl for intricate formatting. The skill enforces rigorous standards such as industry-standard color coding for financial models, the use of dynamic formulas over hardcoded values, and a mandatory verification process using a LibreOffice-powered recalculation script to guarantee spreadsheets are delivered without errors like #REF! or #DIV/0!.

Key Features

01Advanced formula construction with automated error detection and recalculation

0225 GitHub stars

03Template preservation that matches existing styles and formatting conventions

04Source documentation and assumption tracking for hardcoded data

05Industry-standard financial modeling (Blue/Black/Green/Red text conventions)

06High-performance data analysis and visualization using pandas

Use Cases

01Building dynamic, error-free financial models with professional formatting

02Analyzing and transforming large datasets into formatted Excel reports

03Modifying existing spreadsheet templates while preserving complex formulas and styles

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ttmouse/skills xlsx

For use in Claude.ai and ChatGPT

Download Skill