Can it maintain existing spreadsheet formatting?

Absolutely. The skill is designed to study and match existing styles, conventions, and templates, ensuring updates look seamless within established workbooks.

Does this skill support complex Excel formulas?

Yes, the skill prioritizes dynamic Excel formulas over hardcoded values and includes a recalculation engine to ensure all results are accurate and error-free.

What tools does this skill use for data processing?

It leverages pandas for high-performance data manipulation and analysis, and openpyxl for detailed formatting, cell styling, and formula management.

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

It includes a mandatory verification step using a recalculation script that scans for errors, provides a detailed summary of any issues, and requires fixes before final delivery.

Professional Excel & Financial Modeling

Name: Professional Excel & Financial Modeling
Author: sarfraznawaz2005

bysarfraznawaz2005

•

Data Science & ML

Creates, edits, and analyzes professional spreadsheets with industry-standard formatting, dynamic formulas, and automated recalculation.

This skill transforms Claude into a sophisticated spreadsheet analyst capable of handling everything from basic CSV manipulation to complex financial modeling. It enforces strict professional standards, including industry-standard color coding for inputs and formulas, specific number formatting for currency and multiples, and a mandatory 'formula-first' approach that eliminates hardcoded values. By leveraging pandas for data analysis and openpyxl for precise formatting, the skill ensures that spreadsheets remain dynamic and updateable. It includes integrated support for LibreOffice-based recalculation, allowing Claude to verify formula integrity and eliminate common errors like #REF! or #DIV/0! before delivery.

Key Features

01Dynamic formula generation to ensure workbooks remain updateable and calculation-ready.

02Enforcement of industry-standard financial modeling styles and color-coded cell conventions.

03Automated formula recalculation and error verification using integrated LibreOffice tools.

041 GitHub stars

05Deep data analysis, visualization, and manipulation capabilities using the pandas library.

06Automated creation and editing of .xlsx, .xlsm, and .csv files with formula preservation.

Use Cases

01Cleaning and analyzing large datasets while generating professional-grade Excel reports.

02Updating existing corporate templates while strictly adhering to established formatting and style guides.

03Building dynamic three-statement financial models with automated projections and scenario analysis.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sarfraznawaz2005/agent-skills-collection xlsx

For use in Claude.ai and ChatGPT

Download Skill