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

0•

データサイエンスと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.

主な機能

01Automated formula recalculation and error detection via LibreOffice integration.

02Comprehensive workbook manipulation using both pandas and openpyxl libraries.

03Automated data source documentation and cell-level commenting for audit trails.

040 GitHub stars

05Industry-standard financial modeling standards (blue text for inputs, black for formulas).

06Strict preservation of existing template styles, conventions, and formatting.

ユースケース

01Building dynamic three-statement financial models with automated growth projections.

02Generating audit-ready reports from raw data with professional currency and percentage formatting.

03Cleaning and analyzing large datasets across multiple sheets with automated summaries.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add mikeyb03/skills xlsx

For use in Claude.ai and ChatGPT

Download Skill