Does this skill support complex Excel formulas?

Yes, it prioritizes Excel formulas over hardcoded values to ensure spreadsheets remain dynamic and updateable when source data changes.

What libraries does this skill use for spreadsheet operations?

It uses pandas for high-performance data analysis and openpyxl for complex formatting, cell-level styling, and formula preservation.

Will it overwrite my existing spreadsheet formatting?

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

Can it handle professional financial modeling standards?

Absolutely. It follows industry standards such as blue text for hardcoded inputs, black for formulas, and specific formatting for currencies, multiples, and percentages.

How are formula errors prevented?

The skill utilizes a mandatory recalculation workflow that scans every cell for common Excel errors like #REF!, #DIV/0!, and #VALUE! before the file is finalized.

Excel & Financial Spreadsheet Master

Name: Excel & Financial Spreadsheet Master
Author: nerver111

bynerver111

0•

数据科学与机器学习

Automates professional spreadsheet creation, complex financial modeling, and data analysis with full support for formulas, formatting, and error-free recalculation.

This skill empowers Claude to handle sophisticated spreadsheet tasks, ranging from basic CSV manipulation to building audit-ready financial models. It enforces strict industry standards for color-coding and number formatting while ensuring spreadsheets remain dynamic by prioritizing Excel formulas over hardcoded values. By leveraging pandas for data analysis and openpyxl for cell-level control, it provides a comprehensive workflow that includes automated formula recalculation and error detection to ensure 100% accuracy in every delivery.

主要功能

01Strict adherence to industry-standard financial modeling color-coding and formatting

02Automated creation and editing of .xlsx and .xlsm files with dynamic formula support

03Mandatory formula recalculation and error scanning (#REF!, #DIV/0!, etc.)

040 GitHub stars

05Seamless template preservation and style matching for existing workbooks

06Advanced data manipulation and visualization using pandas and openpyxl

使用场景

01Automating the cleaning and analysis of large datasets for business intelligence reports

02Building dynamic three-statement financial models and valuation projections

03Updating existing corporate spreadsheet templates while maintaining original styles and logic

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nerver111/git-skill-test xlsx

For use in Claude.ai and ChatGPT