Does it use Python for data manipulation?

Yes, it leverages pandas for powerful data analysis and openpyxl for granular control over Excel-specific features like formatting and formula strings.

Can I use this for professional financial modeling?

Absolutely. The skill follows strict industry standards for color-coding—such as blue text for hardcoded inputs and black for formulas—and specific formatting for currencies and multiples.

Does this skill support complex Excel formulas?

Yes, it supports full formula creation and uses a dedicated recalculation script via LibreOffice to ensure all values are accurate and free of errors like #REF! or #VALUE!.

Does it preserve my existing spreadsheet's formatting?

Yes, it is designed to study and match your existing templates, styles, and conventions whenever it modifies an existing file.

What happens if a formula error is detected?

The skill utilizes a mandatory verification step that returns a detailed JSON summary of any errors found, allowing Claude to fix broken references or division-by-zero issues immediately.

Excel & Spreadsheet Assistant

Name: Excel & Spreadsheet Assistant
Author: claudiodearaujo

byclaudiodearaujo

0•

Data Science & ML

Creates, edits, and analyzes complex Excel spreadsheets with professional financial modeling standards and automated formula verification.

This skill equips Claude with the power to handle sophisticated spreadsheet tasks, from building dynamic financial models to performing large-scale data analysis. It enforces industry-standard formatting—such as specific color-coding for inputs and calculations—and ensures zero formula errors through an automated verification and recalculation process using LibreOffice. Whether generating new workbooks with complex nested formulas or updating existing templates while preserving their original style, this skill ensures spreadsheets remain dynamic, updateable, and production-ready.

Key Features

01Template preservation that matches existing styles and conventions

020 GitHub stars

03Hybrid workflow using pandas for data analysis and openpyxl for styling

04Support for various formats including .xlsx, .xlsm, .csv, and .tsv

05Automated formula recalculation and error detection via LibreOffice

06Industry-standard financial modeling conventions (color-coding and number formatting)

Use Cases

01Developing professional-grade financial models with dynamic projections and scenario analysis

02Maintaining complex legacy spreadsheets without breaking existing formulas or organizational styles

03Automating the cleanup and formatting of large datasets into presentable Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill