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

Data Science & ML

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

About

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

0 GitHub stars
Advanced data analysis and visualization using pandas and openpyxl
Dynamic formula generation to ensure spreadsheets remain interactive and updateable
Industry-standard financial modeling color-coding and professional number formatting
Automated formula recalculation and error detection via LibreOffice integration
Template preservation to maintain existing styles and conventions in existing files

Use Cases

Converting raw CSV data into formatted, professional Excel reports with summaries
Building automated financial projections with clear assumption-driven formulas
Updating corporate spreadsheet templates while preserving complex existing formatting

About

Key Features

0 GitHub stars
Advanced data analysis and visualization using pandas and openpyxl
Dynamic formula generation to ensure spreadsheets remain interactive and updateable
Industry-standard financial modeling color-coding and professional number formatting
Automated formula recalculation and error detection via LibreOffice integration
Template preservation to maintain existing styles and conventions in existing files

Use Cases

Converting raw CSV data into formatted, professional Excel reports with summaries
Building automated financial projections with clear assumption-driven formulas
Updating corporate spreadsheet templates while preserving complex existing formatting