Can I use this for professional investment banking models?

Absolutely. It follows strict industry standards including specific color coding (blue for inputs, black for formulas) and precise number formatting for currency and multiples.

What tools are required for formula recalculation?

The skill assumes LibreOffice is available to perform background recalculations via a specialized Python script, ensuring formula values are accurate upon opening.

Will it mess up my existing Excel templates?

No, the skill is designed to study and match existing formatting and conventions, ensuring that modifications respect your established styles and patterns.

How does it handle common Excel errors like #REF! or #DIV/0!?

The skill includes a mandatory verification step using a recalculation script that scans all cells for errors, providing a JSON summary of any issues to be fixed before the file is finalized.

Does this skill support complex Excel formulas?

Yes, it prioritizes dynamic Excel formulas over hardcoded Python results, ensuring your spreadsheet remains interactive and recalculates when source data changes.

Excel & Financial Modeling

Name: Excel & Financial Modeling
Author: bkootaz

bybkootaz

0•

Productivity & Workflow

Automates professional spreadsheet creation, data analysis, and financial modeling with dynamic formulas and industry-standard formatting.

The xlsx skill enables Claude to perform sophisticated spreadsheet operations, moving beyond static data exports to create fully functional, dynamic Excel models. It supports complex formula injection, professional financial formatting conventions (such as color-coded inputs and calculations), and automated error validation. By leveraging pandas for data manipulation and openpyxl for formatting preservation, it ensures spreadsheets remain professional and updateable. The skill includes a mandatory recalculation engine that uses LibreOffice to verify that every model is delivered with zero formula errors, making it an essential tool for analysts and developers alike.

Key Features

010 GitHub stars

02Advanced formatting for currency, percentages, multiples, and years

03Automated formula recalculation and error validation (#REF!, #DIV/0!)

04Dynamic formula creation and preservation to avoid hardcoded values

05Industry-standard financial modeling color coding (blue/black/green/red)

06Comprehensive support for .xlsx, .xlsm, .csv, and .tsv formats

Use Cases

01Updating existing Excel templates while preserving original styles and formula structures

02Analyzing large datasets with pandas and exporting formatted summary reports

03Building automated financial models (DCF, 3-statement) with standardized formatting

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bkootaz/https-github.com-anthropics-skills xlsx

For use in Claude.ai and ChatGPT

Download Skill