Does this skill support complex Excel formulas?

Yes, it prioritizes dynamic Excel formulas over hardcoded values and includes a validation step using a recalculation script to ensure zero formula errors.

Can it be used for professional financial modeling?

Absolutely. It follows strict industry standards for color-coding (blue for inputs, black for formulas) and specific number formatting for currencies, multiples, and percentages.

How does it handle formula recalculation?

The skill includes a recalc.py script that uses LibreOffice to evaluate all formulas and identify any calculation errors before finalizing the file.

What Python libraries does this skill utilize?

It uses pandas for data manipulation and analysis, and openpyxl for detailed cell formatting, styling, and formula management.

Excel & Spreadsheet Expert

Name: Excel & Spreadsheet Expert
Author: billlzzz18

bybilllzzz18

•

数据科学与机器学习

Creates, modifies, and analyzes Excel spreadsheets with production-grade formulas, professional formatting, and financial modeling standards.

关于

This skill empowers Claude to handle complex spreadsheet tasks, ranging from high-performance data analysis with pandas to building sophisticated financial models using openpyxl. It enforces strict industry standards for financial modeling, such as blue-text inputs and black-text formulas, while ensuring zero-error integrity through a mandatory recalculation workflow. By prioritizing dynamic cell references over hardcoded values, it ensures that every spreadsheet produced remains scalable, updateable, and professional.

主要功能

1 GitHub stars
Industry-standard financial modeling formatting and color-coding
Template preservation and style-matching for existing workbooks
Dynamic formula generation with zero-error validation (#REF!, #DIV/0!)
Comprehensive data analysis and visualization using pandas and openpyxl
Automated formula recalculation via LibreOffice integration

使用场景

Generating formatted executive reports with complex cross-sheet calculations
Processing and cleaning large datasets from CSV or XLSX files for business intelligence
Building automated financial projection models with dynamic growth assumptions

关于

主要功能

1 GitHub stars
Industry-standard financial modeling formatting and color-coding
Template preservation and style-matching for existing workbooks
Dynamic formula generation with zero-error validation (#REF!, #DIV/0!)
Comprehensive data analysis and visualization using pandas and openpyxl
Automated formula recalculation via LibreOffice integration

使用场景

Generating formatted executive reports with complex cross-sheet calculations
Processing and cleaning large datasets from CSV or XLSX files for business intelligence
Building automated financial projection models with dynamic growth assumptions