Does this skill support complex Excel formulas?

Yes, it supports full formula construction and includes a mandatory verification step using LibreOffice to ensure zero errors like #REF!, #VALUE!, or #DIV/0!.

Can it handle professional financial modeling standards?

Absolutely. It follows strict conventions such as blue text for hardcoded inputs, black for formulas, and green for internal links, ensuring models are audit-ready.

How does it handle formula recalculation?

The skill uses a dedicated recalc.py script that leverages LibreOffice to evaluate all formulas and verify their accuracy before finalizing the file.

Will it overwrite my existing spreadsheet formatting?

No. The skill is designed to study and exactly match existing templates, styles, and conventions when modifying files, preserving your established patterns.

Excel & Financial Modeling Pro

Name: Excel & Financial Modeling Pro
Author: Krosebrook

byKrosebrook

•

データサイエンスとML

Automates spreadsheet creation, complex financial modeling, and data analysis with professional formatting and formula integrity.

概要

This skill empowers Claude to handle sophisticated spreadsheet tasks, ranging from large-scale data analysis to production-grade financial models. It enforces strict industry standards, including specific color-coding for inputs and calculations, precise number formatting, and mandatory formula recalculation to eliminate errors like #REF! or #DIV/0!. By combining the data processing power of pandas with the formatting capabilities of openpyxl, it ensures every spreadsheet is dynamic, audit-ready, and professional.

主な機能

Production-grade financial modeling with industry-standard color coding and formatting
Automated formula verification and recalculation to ensure zero calculation errors
Seamless integration with pandas for high-performance data analysis and visualization
Template preservation that matches existing styles and conventions during modifications
Support for multiple formats including .xlsx, .xlsm, .csv, and .tsv
1 GitHub stars

ユースケース

Analyzing and cleaning large datasets before exporting to audit-ready Excel workbooks
Building automated financial projection models with dynamic scenarios and assumptions
Generating formatted corporate reports from raw data sources with proper sourcing documentation

概要

主な機能

Production-grade financial modeling with industry-standard color coding and formatting
Automated formula verification and recalculation to ensure zero calculation errors
Seamless integration with pandas for high-performance data analysis and visualization
Template preservation that matches existing styles and conventions during modifications
Support for multiple formats including .xlsx, .xlsm, .csv, and .tsv
1 GitHub stars

ユースケース

Analyzing and cleaning large datasets before exporting to audit-ready Excel workbooks
Building automated financial projection models with dynamic scenarios and assumptions
Generating formatted corporate reports from raw data sources with proper sourcing documentation