Can it modify existing Excel files without breaking them?

Absolutely. It is designed to study existing templates and match their formatting, styles, and conventions exactly when performing updates.

How are formula errors prevented?

The skill uses a mandatory recalculation script that scans for #REF!, #DIV/0!, and other errors, providing a detailed summary to fix issues before delivery.

Does this skill support complex Excel formulas?

Yes, it specifically prioritizes dynamic Excel formulas over hardcoded Python values to ensure workbooks remain interactive and updateable by users.

Is this suitable for investment banking or finance tasks?

Yes, it follows industry-standard conventions such as blue text for inputs, black for formulas, and specialized formatting for multiples and currency.

What software is required for the recalculation feature?

The skill assumes LibreOffice is installed to power the recalc.py script, which handles headless formula evaluation and error checking.

Advanced Excel & Financial Modeling

Name: Advanced Excel & Financial Modeling
Author: alijilani-dev

byalijilani-dev

0•

Data Science & ML

Automates the creation, editing, and analysis of professional Excel workbooks with dynamic formulas and industry-standard financial modeling.

The xlsx skill enables Claude to perform sophisticated spreadsheet operations, ranging from high-speed data analysis to the construction of complex financial models. By leveraging pandas for data manipulation and openpyxl for granular formatting, it ensures that all spreadsheets remain dynamic and interactive rather than containing static values. The skill enforces strict professional standards, including specific color-coding for inputs and calculations, while utilizing a specialized recalculation engine to guarantee zero formula errors in the final output.

Key Features

010 GitHub stars

02Advanced data analysis and visualization using pandas and openpyxl

03Dynamic formula generation to ensure spreadsheets remain interactive and updateable

04Industry-standard financial modeling color-coding and professional number formatting

05Automated formula recalculation and error detection via LibreOffice integration

06Template preservation to maintain existing styles and conventions in existing files

Use Cases

01Converting raw CSV data into formatted, professional Excel reports with summaries

02Building automated financial projections with clear assumption-driven formulas

03Updating corporate spreadsheet templates while preserving complex existing formatting

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add alijilani-dev/claude xlsx

For use in Claude.ai and ChatGPT

Download Skill