Can I use this for professional financial modeling?

Absolutely. The skill follows industry-standard conventions such as blue text for inputs and black text for formulas, and enforces strict number formatting.

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

The skill includes a mandatory recalculation and verification step that scans for common Excel errors, ensuring the final file is clean and functional.

Does this skill support existing Excel formulas?

Yes, it preserves existing formulas during editing and can recalculate them using an integrated LibreOffice-based script to ensure data accuracy.

Does it require any external software?

For advanced formula recalculation, the skill assumes LibreOffice is installed to power the recalc.py script, though standard data operations work via Python libraries.

Can it handle large datasets?

Yes, it leverages the pandas library to efficiently process large amounts of data before formatting and exporting it to an Excel workbook.

Advanced Excel & Spreadsheet Automator

Name: Advanced Excel & Spreadsheet Automator
Author: claudiodearaujo

byclaudiodearaujo

Data Science & ML

Automates the creation, editing, and analysis of complex Excel spreadsheets with support for formulas, financial modeling, and data visualization.

About

This skill provides Claude with professional-grade spreadsheet capabilities, enabling the automation of intricate Excel tasks while adhering to strict financial modeling standards. It supports comprehensive .xlsx and .xlsm manipulation, including cell formatting, formula insertion, and data analysis using pandas. A standout feature is its integration with a recalculation engine that ensures all formulas are error-free and up-to-date. Whether you are building dynamic financial projections, preserving corporate templates, or analyzing large datasets, this skill ensures technical accuracy and industry-standard presentation.

Key Features

Template-aware editing that preserves existing styles, layouts, and conventions
Comprehensive support for complex formatting, including currency, percentages, and multiples
Deep integration with pandas for advanced data analysis and large-scale manipulation
0 GitHub stars
Automated formula recalculation and error verification using LibreOffice integration
Industry-standard financial modeling with specific color-coding (Blue/Black/Green/Red)

Use Cases

Automating the migration and analysis of data from CSV/TSV files into formatted Excel reports
Updating existing corporate spreadsheet templates with new data while maintaining style consistency
Generating dynamic financial models with linked assumptions and zero formula errors

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

GitHub