Does this skill support complex Excel formulas?

Yes, it prioritizes creating dynamic Excel formulas over hardcoding values, ensuring your spreadsheets remain updateable and functional.

Can it follow professional financial modeling standards?

Absolutely. It follows industry-standard conventions such as blue text for hardcoded inputs, black for formulas, and specific formatting for currencies and multiples.

How are formula errors prevented?

The skill includes a mandatory verification step using a recalculation script that scans for errors like #REF!, #DIV/0!, and #VALUE! before finalizing files.

What libraries does Claude use for spreadsheet tasks?

Claude utilizes pandas for high-speed data analysis and openpyxl for complex formatting, formula preservation, and workbook structure management.

Can I use this to update my existing corporate templates?

Yes, the skill is designed to study and match existing formats, styles, and conventions to ensure modifications look seamless within established files.

Advanced Excel & Spreadsheet Automation

Name: Advanced Excel & Spreadsheet Automation
Author: ai-wes

byai-wes

Data Science & ML

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

About

This skill empowers Claude to perform complex spreadsheet operations, ranging from high-level data analysis with pandas to granular formatting and formula management with openpyxl. It enforces rigorous financial modeling standards, including specific color-coding for inputs and calculations, and utilizes a dedicated recalculation script to ensure zero-error formula delivery. Whether generating new dynamic models or updating legacy templates, this skill ensures that spreadsheets remain functional, professional, and audit-ready.

Key Features

Deep data analysis and visualization using pandas integration
Automated formula creation and validation with zero-error enforcement
Formula recalculation and error scanning via LibreOffice support
0 GitHub stars
Industry-standard financial modeling color-coding and number formatting
Strict preservation of existing workbook templates and formatting patterns

Use Cases

Building dynamic financial models with linked assumptions and automated projections
Modifying existing complex spreadsheets while preserving original formula logic
Transforming raw data into formatted corporate reports with charts and tables

About

Key Features

Deep data analysis and visualization using pandas integration
Automated formula creation and validation with zero-error enforcement
Formula recalculation and error scanning via LibreOffice support
0 GitHub stars
Industry-standard financial modeling color-coding and number formatting
Strict preservation of existing workbook templates and formatting patterns

Use Cases

Building dynamic financial models with linked assumptions and automated projections
Modifying existing complex spreadsheets while preserving original formula logic
Transforming raw data into formatted corporate reports with charts and tables