Does this skill support complex Excel formulas?

Yes, the skill emphasizes using dynamic formulas over hardcoded values and includes a recalculation engine to ensure all calculations are accurate and error-free.

Can I use this for professional financial models?

Absolutely. It follows industry-standard conventions for color-coding (e.g., blue for inputs, black for formulas) and specific number formatting for currencies, multiples, and percentages.

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

The skill includes a mandatory verification step using a recalculation script that scans for Excel errors and identifies their exact cell locations for immediate fixing.

Will it overwrite my existing spreadsheet formatting?

No. The skill is specifically instructed to study and match existing styles, templates, and conventions when modifying your files to ensure consistency.

Does it require any external software?

For advanced formula recalculation, it utilizes LibreOffice via a provided script to ensure that spreadsheet values are correctly updated without opening Excel manually.

Excel & Spreadsheet Management

Name: Excel & Spreadsheet Management
Author: MikeyB03

byMikeyB03

Data Science & ML

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

About

This skill empowers Claude to interact natively with Excel files (.xlsx, .xlsm) and CSVs, enabling complex data manipulation and professional-grade financial modeling. It enforces industry-standard formatting—such as specific color-coding for inputs and calculations—while ensuring all workbooks are delivered with zero formula errors. By leveraging pandas for high-level analysis and openpyxl for precision formatting, the skill handles everything from simple data exports to sophisticated multi-sheet financial templates that maintain dynamic formulas and professional aesthetics.

Key Features

Comprehensive spreadsheet creation and multi-sheet editing using openpyxl and pandas.
Advanced data analysis and visualization capabilities for large datasets.
Preservation of existing spreadsheet templates, styles, and conventions during modification.
Industry-standard financial modeling with strict color-coding and number formatting rules.
Automated formula recalculation and error detection via LibreOffice integration.
0 GitHub stars

Use Cases

Building dynamic financial models with automated assumptions and zero-error formulas.
Analyzing large datasets and exporting insights into formatted, professional Excel reports.
Updating existing corporate templates while maintaining strict internal formatting guidelines.

About

Key Features

Comprehensive spreadsheet creation and multi-sheet editing using openpyxl and pandas.
Advanced data analysis and visualization capabilities for large datasets.
Preservation of existing spreadsheet templates, styles, and conventions during modification.
Industry-standard financial modeling with strict color-coding and number formatting rules.
Automated formula recalculation and error detection via LibreOffice integration.
0 GitHub stars

Use Cases

Building dynamic financial models with automated assumptions and zero-error formulas.
Analyzing large datasets and exporting insights into formatted, professional Excel reports.
Updating existing corporate templates while maintaining strict internal formatting guidelines.