How does this skill prevent formula errors like #DIV/0! or #REF!?

The skill includes a mandatory verification step using a recalculation script powered by LibreOffice. This script scans every cell for errors after the file is generated, ensuring 100% formula integrity.

Why does the skill use Excel formulas instead of calculating results in Python?

Using formulas ensures the spreadsheet remains dynamic. This allows you to change input values directly in Excel and have all dependent calculations update automatically without needing to run code again.

What are the color coding standards used for financial models?

It follows industry standards: Blue for hardcoded inputs, Black for formulas, Green for internal sheet links, Red for external file links, and Yellow backgrounds for key assumptions.

Can Claude update my existing Excel templates without ruining the format?

Yes. This skill is programmed to study and exactly match existing styles, formats, and conventions, ensuring that template-specific patterns always override general defaults.

Advanced Excel & Financial Modeling

Name: Advanced Excel & Financial Modeling
Author: frostant

byfrostant

•

Data Science & ML

Automates professional spreadsheet creation, data analysis, and financial modeling with rigorous formula integrity and industry-standard formatting.

The xlsx skill transforms Claude into a powerful spreadsheet engineer capable of building complex financial models and data analysis tools. It enforces strict professional standards, such as zero-error formula verification and industry-standard color coding (e.g., blue for inputs, black for formulas). By prioritizing dynamic Excel formulas over hardcoded Python values and utilizing LibreOffice for automated recalculation, it ensures that every spreadsheet is production-ready, interactive, and functionally robust for business environments.

Key Features

01Template preservation logic that matches existing styles and conventions during updates

02Automated financial modeling with industry-standard color coding and number formatting

03Dynamic formula generation using openpyxl to ensure interactive spreadsheets

04Seamless data manipulation and visualization using the pandas library

051 GitHub stars

06Automated error detection and formula recalculation powered by LibreOffice integration

Use Cases

01Auditing and fixing broken spreadsheets by identifying and resolving #REF! and #DIV/0! errors

02Building dynamic three-statement financial models with valuation multiples and scenario assumptions

03Automating the conversion of raw CSV/TSV data into formatted, formula-driven Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add frostant/awesome-claude-skills xlsx

For use in Claude.ai and ChatGPT

Download Skill