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

The skill includes a mandatory verification step using a recalculation script that scans every cell for errors and provides a detailed report to fix them automatically.

Why is LibreOffice mentioned in the requirements?

LibreOffice is used as a headless engine to recalculate formula results within the .xlsx file, ensuring the file is fully updated when opened in Excel.

Can I use this for professional investment banking models?

Absolutely. It follows industry-standard conventions such as blue text for hardcoded inputs, black for formulas, and green for internal worksheet links.

Does this skill support complex Excel formulas?

Yes, it prioritizes dynamic Excel formulas over hardcoded Python values and uses a dedicated recalculation script to ensure all cell values are accurate.

What Python libraries are required for this skill?

It primarily utilizes pandas for data-heavy analysis and openpyxl for tasks requiring specific formatting, styles, and formula construction.

Advanced Excel & Financial Modeling

Name: Advanced Excel & Financial Modeling
Author: kaodean

bykaodean

Data Science & ML

Automates the creation, editing, and analysis of professional Excel spreadsheets with advanced formula support and industry-standard financial modeling.

About

This skill empowers Claude to handle complex spreadsheet tasks, ranging from high-speed data manipulation with pandas to building sophisticated, production-grade financial models using openpyxl. It ensures total formula integrity through automated recalculations via LibreOffice integration, strictly adheres to professional formatting conventions (such as standard color-coding for hardcodes vs. formulas), and provides robust error checking to eliminate common Excel pitfalls like #REF! or #DIV/0! errors.

Key Features

Automated spreadsheet creation and editing with full formula preservation
Deep data analysis and visualization capabilities using pandas and openpyxl
Automated source documentation for hardcoded assumptions and data points
0 GitHub stars
Automated formula recalculation and error detection using LibreOffice
Industry-standard financial modeling styles including specific color-coding and currency formatting

Use Cases

Updating existing corporate Excel templates while maintaining complex formatting and styles
Building dynamic financial models with automated projections and scenario analysis
Performing bulk data analysis on large .xlsx or .csv datasets with programmatic precision

About

Key Features

Automated spreadsheet creation and editing with full formula preservation
Deep data analysis and visualization capabilities using pandas and openpyxl
Automated source documentation for hardcoded assumptions and data points
0 GitHub stars
Automated formula recalculation and error detection using LibreOffice
Industry-standard financial modeling styles including specific color-coding and currency formatting

Use Cases

Updating existing corporate Excel templates while maintaining complex formatting and styles
Building dynamic financial models with automated projections and scenario analysis
Performing bulk data analysis on large .xlsx or .csv datasets with programmatic precision