Does it support large datasets?

It leverages pandas for efficient data manipulation and openpyxl for cell-level operations, making it capable of handling significant data analysis tasks.

Can Claude update my existing Excel templates without breaking them?

Yes, the skill is specifically designed to study and match existing formats, styles, and conventions when modifying files, ensuring templates remain intact.

Is this skill suitable for professional financial modeling?

Yes, it follows industry-standard conventions such as blue text for hardcoded inputs, black for formulas, and yellow backgrounds for key assumptions.

How does this skill handle Excel formula errors?

The skill uses a mandatory recalculation script (recalc.py) powered by LibreOffice to scan for and report errors like #REF!, #DIV/0!, and #VALUE! before finishing a task.

Excel & Financial Modeling

Name: Excel & Financial Modeling
Author: JamesPrial

byJamesPrial

0•

데이터 과학 및 ML

Automates the creation, editing, and analysis of professional-grade Excel spreadsheets with dynamic formulas and industry-standard formatting.

This skill enables Claude to perform advanced spreadsheet operations, ranging from high-speed data analysis with pandas to building audit-ready financial models. It enforces rigorous standards including color-coded cell conventions (blue for inputs, black for formulas), zero-error formula verification via LibreOffice-powered recalculation, and the use of dynamic cell references to replace hardcoded values. Designed for precision, it can generate new workbooks from scratch, modify existing templates while preserving complex formatting, and provide detailed data visualizations directly within .xlsx and .csv files.

주요 기능

01Automated spreadsheet creation and editing using openpyxl and pandas

02Mandatory formula recalculation and error detection (recalc.py) for zero-error delivery

03Preservation of existing styles, conventions, and formatting in complex templates

04Support for dynamic formulas, cross-sheet references, and advanced cell styling

05Industry-standard financial modeling with strict color-coding and number formatting

060 GitHub stars

사용 사례

01Updating legacy corporate spreadsheets while maintaining specific brand and structural conventions

02Performing bulk data analysis on CSV/XLSX files and exporting formatted summary reports

03Building dynamic financial models with automated assumption tables and linked projections

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jamesprial/skills xlsx

For use in Claude.ai and ChatGPT

Download Skill