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

0•

Data Science & ML

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

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

01Comprehensive spreadsheet creation and multi-sheet editing using openpyxl and pandas.

02Advanced data analysis and visualization capabilities for large datasets.

03Preservation of existing spreadsheet templates, styles, and conventions during modification.

04Industry-standard financial modeling with strict color-coding and number formatting rules.

05Automated formula recalculation and error detection via LibreOffice integration.

060 GitHub stars

Use Cases

01Building dynamic financial models with automated assumptions and zero-error formulas.

02Analyzing large datasets and exporting insights into formatted, professional Excel reports.

03Updating existing corporate templates while maintaining strict internal formatting guidelines.

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