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

0•

データサイエンスとML

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

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.

主な機能

01Template-aware editing that preserves existing styles, layouts, and conventions

02Comprehensive support for complex formatting, including currency, percentages, and multiples

03Deep integration with pandas for advanced data analysis and large-scale manipulation

040 GitHub stars

05Automated formula recalculation and error verification using LibreOffice integration

06Industry-standard financial modeling with specific color-coding (Blue/Black/Green/Red)

ユースケース

01Automating the migration and analysis of data from CSV/TSV files into formatted Excel reports

02Updating existing corporate spreadsheet templates with new data while maintaining style consistency

03Generating 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

主な機能

01Template-aware editing that preserves existing styles, layouts, and conventions

02Comprehensive support for complex formatting, including currency, percentages, and multiples

03Deep integration with pandas for advanced data analysis and large-scale manipulation

040 GitHub stars

05Automated formula recalculation and error verification using LibreOffice integration

06Industry-standard financial modeling with specific color-coding (Blue/Black/Green/Red)

ユースケース

01Automating the migration and analysis of data from CSV/TSV files into formatted Excel reports

02Updating existing corporate spreadsheet templates with new data while maintaining style consistency

03Generating dynamic financial models with linked assumptions and zero formula errors