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

0•

データサイエンスとML

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

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.

主な機能

01Automated spreadsheet creation and editing with full formula preservation

02Deep data analysis and visualization capabilities using pandas and openpyxl

03Automated source documentation for hardcoded assumptions and data points

040 GitHub stars

05Automated formula recalculation and error detection using LibreOffice

06Industry-standard financial modeling styles including specific color-coding and currency formatting

ユースケース

01Updating existing corporate Excel templates while maintaining complex formatting and styles

02Building dynamic financial models with automated projections and scenario analysis

03Performing bulk data analysis on large .xlsx or .csv datasets with programmatic precision

主な機能

01Automated spreadsheet creation and editing with full formula preservation

02Deep data analysis and visualization capabilities using pandas and openpyxl

03Automated source documentation for hardcoded assumptions and data points

040 GitHub stars

05Automated formula recalculation and error detection using LibreOffice

06Industry-standard financial modeling styles including specific color-coding and currency formatting

ユースケース

01Updating existing corporate Excel templates while maintaining complex formatting and styles

02Building dynamic financial models with automated projections and scenario analysis

03Performing bulk data analysis on large .xlsx or .csv datasets with programmatic precision