Can it modify existing Excel templates without breaking formatting?

Yes, it is specifically designed to study and exactly match existing styles and conventions, ensuring that template patterns are preserved during updates.

How does this skill handle Excel formula errors?

The skill utilizes a mandatory recalculation script (recalc.py) that scans every cell for errors like #REF!, #DIV/0!, and #VALUE!, ensuring all models are delivered error-free.

Which Python libraries are used for spreadsheet operations?

It leverages pandas for high-performance data manipulation and openpyxl for complex formatting, formulas, and preserving Excel-specific features.

Does it support professional financial formatting?

Absolutely. It follows industry standards such as blue text for hardcoded inputs, black for formulas, and specific currency, percentage, and multiple formatting rules.

Excel & Spreadsheet Mastery

Name: Excel & Spreadsheet Mastery
Author: rysweet

byrysweet

0•

データサイエンスとML

Enables professional spreadsheet creation, data analysis, and financial modeling with rigorous formula verification and industry-standard formatting.

This skill empowers Claude to perform advanced spreadsheet operations, ranging from basic CSV manipulation to building complex financial models with professional formatting and dynamic formulas. It enforces strict standards such as zero-error formula verification using a dedicated recalculation engine, color-coded financial conventions, and comprehensive data analysis via pandas. Whether you are generating new reports, analyzing large datasets, or updating established templates while preserving existing styles, this skill ensures accuracy, auditability, and professional-grade output in .xlsx, .xlsm, and other spreadsheet formats.

主な機能

01Advanced data analysis and visualization using pandas for large-scale data manipulation

02Template preservation logic that matches existing styles and formatting patterns

03Dynamic formula creation with automated recalculation and error detection via LibreOffice

04Professional financial modeling standards including color-coded inputs and formula conventions

05Strict verification for common Excel errors like #REF!, #DIV/0!, and circular references

060 GitHub stars

ユースケース

01Performing data cleaning and statistical analysis on large datasets with automated spreadsheet export

02Automating the update of complex corporate reporting templates while maintaining formula integrity

03Building dynamic financial projection models from raw business assumptions and data sources

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rysweet/azurehaymaker xlsx

For use in Claude.ai and ChatGPT