Which file formats are supported?

The skill works with .xlsx, .xlsm, .csv, and .tsv files, providing comprehensive spreadsheet support.

Can I use it to edit existing corporate templates?

Yes, it is designed to study and match existing formats, styles, and conventions when modifying files with established patterns.

How does it ensure formulas are correct?

It uses a specialized recalculation script and LibreOffice to evaluate formulas and scan for common errors like #REF!, #DIV/0!, and #VALUE!.

Can this skill handle complex Excel formulas?

Yes, it prioritizes dynamic Excel formulas over hardcoded values and includes a recalculation engine to verify accuracy across all cells.

Does it support industry-standard financial formatting?

Absolutely. It follows specific color-coding conventions, such as blue for inputs and black for formulas, ensuring professional financial output.

Excel & Financial Modeling

Name: Excel & Financial Modeling
Author: claudiodearaujo

byclaudiodearaujo

•

Data Science & ML

Automates the creation, editing, and analysis of professional Excel spreadsheets with dynamic formulas and industry-standard financial formatting.

This skill empowers Claude to perform sophisticated spreadsheet operations, ranging from basic data manipulation to complex financial modeling. It ensures high-quality output by enforcing zero formula errors, adhering to professional color-coding standards, and utilizing LibreOffice for accurate formula recalculation. Whether you need to build dynamic financial projections, analyze large datasets using pandas, or update existing templates while preserving formatting, this skill provides a robust framework for professional-grade Excel automation and data visualization.

Key Features

01Industry-standard financial modeling color-coding and number formatting

02Seamless integration with pandas for analysis and openpyxl for styling

031 GitHub stars

04Automated formula recalculation and error detection via LibreOffice integration

05Support for multiple file formats including .xlsx, .xlsm, .csv, and .tsv

06Dynamic formula generation and validation to prevent hardcoded values

Use Cases

01Updating existing corporate spreadsheet templates while maintaining strict formula integrity

02Building dynamic financial models with automated projections and scenario analysis

03Analyzing large datasets and generating formatted reports with visualizations

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