Is it suitable for professional financial modeling?

Absolutely. It follows strict industry standards for color-coding (e.g., blue for hardcodes, black for formulas) and professional number formatting for currency, percentages, and multiples.

How does it handle formula errors?

The skill uses a mandatory recalculation script that scans for common Excel errors like #REF!, #DIV/0!, and #VALUE!, ensuring models are delivered with zero errors.

What file formats are supported?

The skill provides comprehensive support for .xlsx, .xlsm, .csv, and .tsv files, covering everything from simple data exports to macro-enabled workbooks.

Does this skill support existing Excel templates?

Yes, it is designed to study and match existing formats, styles, and conventions to ensure seamless updates without overwriting established patterns.

Why does it use formulas instead of hardcoding values?

Using Excel formulas ensures the spreadsheet remains dynamic and updateable, allowing users to modify input data and see recalculated results instantly.

Excel & Spreadsheet Management

Name: Excel & Spreadsheet Management
Author: claudiodearaujo

byclaudiodearaujo

•

数据科学与机器学习

Enables Claude to create, edit, and analyze professional Excel spreadsheets with advanced formulas, financial modeling standards, and automated recalculation.

This skill equips Claude with professional-grade spreadsheet capabilities, ensuring high-quality output for financial modeling, data analysis, and report generation. It enforces industry-standard formatting, preserves existing templates, and guarantees error-free formulas by utilizing Python libraries like pandas and openpyxl alongside a dedicated recalculation engine. Whether building a complex financial model from scratch or updating an existing workbook, this skill ensures data integrity and dynamic functionality across .xlsx, .xlsm, and .csv formats.

主要功能

011 GitHub stars

02Dynamic formula creation with automated error detection

03Advanced data manipulation and analysis via pandas

04Industry-standard financial model color-coding and formatting

05Preservation of existing spreadsheet styles and conventions

06Automated formula recalculation using LibreOffice integration

使用场景

01Building robust financial models with standardized assumptions and formatting

02Performing deep data analysis on large datasets and exporting results with live formulas

03Automating the update of complex Excel templates while preserving existing macros and styles

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claudiodearaujo/sistema-de-narra-o-de-livro xlsx-official

For use in Claude.ai and ChatGPT

Download Skill