Can I use it for professional financial modeling?

Absolutely. It follows industry-standard conventions, such as blue text for hardcoded inputs and black for formulas, ensuring models are readable for finance professionals.

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

The skill utilizes a mandatory recalculation script that scans all cells for errors post-creation, providing a detailed report to ensure every model is delivered with zero errors.

Does this skill support existing Excel templates?

Yes, it is specifically designed to study and match existing styles, conventions, and formatting when modifying your existing workbook templates.

Why use this instead of standard Python CSV exports?

This skill creates dynamic .xlsx files with actual formulas rather than static values, allowing the spreadsheet to remain functional and updateable by end-users in Excel.

Advanced Excel & Financial Modeling

Name: Advanced Excel & Financial Modeling
Author: MikeyB03

byMikeyB03

データサイエンスとML

Creates, edits, and analyzes professional Excel workbooks with dynamic formulas, automated recalculation, and industry-standard formatting.

概要

The xlsx skill transforms Claude into a sophisticated spreadsheet engineer capable of building production-grade financial models and data analysis tools. Unlike basic CSV exporters, this skill prioritizes dynamic integrity by enforcing the use of Excel formulas over hardcoded values and implementing a rigorous verification process to eliminate errors like #REF! and #DIV/0!. It adheres to strict financial industry standards for color coding and number formatting while leveraging powerful libraries like pandas and openpyxl to manipulate complex, multi-sheet workbooks. Whether you are automating recurring reports, building projection models from scratch, or performing deep-dive data analysis, this skill ensures your spreadsheets remain functional, professional, and audit-ready.

主な機能

Automated formula recalculation and error detection via LibreOffice integration.
Comprehensive workbook manipulation using both pandas and openpyxl libraries.
Automated data source documentation and cell-level commenting for audit trails.
0 GitHub stars
Industry-standard financial modeling standards (blue text for inputs, black for formulas).
Strict preservation of existing template styles, conventions, and formatting.

ユースケース

Building dynamic three-statement financial models with automated growth projections.
Generating audit-ready reports from raw data with professional currency and percentage formatting.
Cleaning and analyzing large datasets across multiple sheets with automated summaries.

概要

主な機能

Automated formula recalculation and error detection via LibreOffice integration.
Comprehensive workbook manipulation using both pandas and openpyxl libraries.
Automated data source documentation and cell-level commenting for audit trails.
0 GitHub stars
Industry-standard financial modeling standards (blue text for inputs, black for formulas).
Strict preservation of existing template styles, conventions, and formatting.

ユースケース

Building dynamic three-statement financial models with automated growth projections.
Generating audit-ready reports from raw data with professional currency and percentage formatting.
Cleaning and analyzing large datasets across multiple sheets with automated summaries.