Does this skill support complex Excel formulas?

Yes, it prioritizes dynamic Excel formulas over hardcoded Python values and includes a verification step to ensure zero formula errors.

Can it handle industry-standard financial modeling formatting?

Absolutely. It follows specific conventions like blue text for hardcoded inputs, black for formulas, and yellow backgrounds for key assumptions.

How does it handle formula recalculation outside of Excel?

It uses a specialized recalculation script powered by LibreOffice to evaluate formulas and detect errors like #REF!, #DIV/0!, or #VALUE! automatically.

Which Python libraries does this skill utilize?

It uses pandas for high-performance data analysis and bulk operations, and openpyxl for complex formatting, formulas, and Excel-specific features.

Advanced Excel & Financial Modeling

Name: Advanced Excel & Financial Modeling
Author: claudiodearaujo

byclaudiodearaujo

0•

データサイエンスとML

Creates and analyzes professional-grade spreadsheets with dynamic formulas, financial modeling standards, and automated recalculation.

This skill empowers Claude to act as a sophisticated spreadsheet engineer, capable of building complex financial models and data analysis tools. It provides a robust framework for creating, modifying, and analyzing Excel files while strictly adhering to financial industry standards, such as specific color coding for inputs and formulas. By integrating both pandas for data manipulation and openpyxl for precision formatting, along with a dedicated formula recalculation engine via LibreOffice, it ensures all generated spreadsheets are dynamic, error-free, and production-ready.

主な機能

010 GitHub stars

02Hybrid workflow utilizing pandas for data processing and openpyxl for cell-level styling.

03Automated formula recalculation and error detection (e.g., #REF!, #DIV/0!) using LibreOffice integration.

04Dynamic formula injection to ensure spreadsheets remain updateable and non-hardcoded.

05Comprehensive support for .xlsx, .xlsm, .csv, and .tsv file formats.

06Strict adherence to financial modeling standards including industry-standard color coding and number formatting.

ユースケース

01Analyzing large datasets within spreadsheets to generate summarized reports and visual data representations.

02Building automated financial projection models with dynamic growth assumptions and cell-linked dependencies.

03Updating existing corporate Excel templates while preserving complex legacy formulas and specific formatting conventions.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claudiodearaujo/izacenter xlsx-official

For use in Claude.ai and ChatGPT

Download Skill