Can it handle professional financial modeling standards?

Absolutely. It follows industry conventions for color-coding inputs (blue), formulas (black), and links (green/red) while enforcing specific number formatting for currency and percentages.

Does it preserve existing spreadsheet formatting when editing?

Yes. The skill is designed to study and match existing styles, conventions, and patterns when modifying your templates to ensure consistency.

How are formula errors like #REF! or #DIV/0! prevented?

The skill uses a mandatory recalculation and verification script that scans all cells for errors after modification, ensuring a zero-error delivery.

What file formats are supported?

It provides comprehensive support for .xlsx, .xlsm, .csv, and .tsv files using high-performance Python libraries.

Does this skill support dynamic Excel formulas?

Yes, it prioritizes writing dynamic Excel formulas over hardcoded values, ensuring your spreadsheets remain interactive and updateable.

Excel & Spreadsheet Expert

Name: Excel & Spreadsheet Expert
Author: rysweet

byrysweet

Data Science & ML

Creates, edits, and analyzes sophisticated Excel spreadsheets with advanced formula support and industry-standard financial formatting.

About

This skill empowers Claude to perform complex spreadsheet tasks including creating dynamic models with formulas, performing deep data analysis using pandas, and modifying existing templates while preserving professional formatting. It features specialized support for financial modeling standards—including color-coded cell conventions and rigorous error checking—and uses a dedicated recalculation engine via LibreOffice to ensure all spreadsheet values are accurate and completely free of formula errors.

Key Features

Template preservation and non-destructive file modification
Automated zero-error verification for cell references and formulas
0 GitHub stars
Dynamic Excel formula generation and automated recalculation
Professional financial modeling with industry-standard color coding
Advanced data analysis and visualization using pandas and openpyxl

Use Cases

Updating existing corporate spreadsheet templates while maintaining strict formatting rules
Generating automated financial models with growth assumptions and scenario analysis
Analyzing large datasets from CSV or XLSX files to generate summary reports

About

Key Features

Template preservation and non-destructive file modification
Automated zero-error verification for cell references and formulas
0 GitHub stars
Dynamic Excel formula generation and automated recalculation
Professional financial modeling with industry-standard color coding
Advanced data analysis and visualization using pandas and openpyxl

Use Cases

Updating existing corporate spreadsheet templates while maintaining strict formatting rules
Generating automated financial models with growth assumptions and scenario analysis
Analyzing large datasets from CSV or XLSX files to generate summary reports