Is it suitable for professional investment banking models?

Yes, it adheres to industry standards, including specific color coding for hardcodes (blue), formulas (black), and internal/external links (green/red).

Does it preserve my existing spreadsheet formatting?

Absolutely. The skill is designed to study and match existing styles, conventions, and templates when modifying files, ensuring consistency.

How does it prevent formula errors like #REF! or #VALUE!?

It uses a specialized recalculation script (recalc.py) that scans every cell for errors after modification and provides a detailed report for immediate fixing.

Can this skill handle complex Excel formulas?

Yes, it supports full formula construction using openpyxl and includes a mandatory recalculation step to verify accuracy and values.

Excel & Spreadsheet Management

Name: Excel & Spreadsheet Management
Author: ShunmeiCho

byShunmeiCho

0•

Data Science & ML

Automates professional spreadsheet creation, financial modeling, and data analysis with rigorous formula verification and industry-standard formatting.

This skill transforms Claude into a sophisticated Excel developer and financial analyst, capable of building complex workbooks, performing deep data analysis, and maintaining legacy templates. It enforces strict financial modeling standards, including color-coded inputs and formula-based logic, while utilizing a robust verification workflow that leverages LibreOffice to recalculate and validate every cell. Whether generating three-statement models or processing large CSVs with pandas, this skill ensures zero-error delivery and professional-grade presentation.

Key Features

01Professional financial modeling with industry-standard color coding and number formatting

02Style-aware editing that preserves existing spreadsheet templates and conventions

03Advanced data manipulation and visualization using the pandas library

040 GitHub stars

05Multi-format support for .xlsx, .xlsm, .csv, and .tsv files

06Automated formula recalculation and error detection to eliminate #REF! and #DIV/0! errors

Use Cases

01Building dynamic three-statement financial models with automated growth assumptions and scenario analysis

02Processing large datasets to generate summarized executive reports with charts and visualizations

03Automating the update of recurring business reports while maintaining complex legacy formatting and styles

Key Features

01Professional financial modeling with industry-standard color coding and number formatting

02Style-aware editing that preserves existing spreadsheet templates and conventions

03Advanced data manipulation and visualization using the pandas library

040 GitHub stars

05Multi-format support for .xlsx, .xlsm, .csv, and .tsv files

06Automated formula recalculation and error detection to eliminate #REF! and #DIV/0! errors

Use Cases

01Building dynamic three-statement financial models with automated growth assumptions and scenario analysis

02Processing large datasets to generate summarized executive reports with charts and visualizations

03Automating the update of recurring business reports while maintaining complex legacy formatting and styles