How does it ensure there are no formula errors like #REF! or #DIV/0!?

The skill utilizes a mandatory recalculation script powered by LibreOffice that scans every cell for errors after the file is generated, ensuring a 100% error-free delivery.

Can it work with existing Excel templates?

Yes, it is designed to study and match existing formats, styles, and conventions of your templates, ensuring that any modifications look seamless and professional.

Does this skill support complex Excel formulas?

Yes, it specifically prioritizes using Excel formulas (like SUM, AVERAGE, and growth rates) over hardcoding values to ensure your spreadsheets remain dynamic and interactive.

What file formats are supported?

The skill supports a wide range of spreadsheet formats including .xlsx, .xlsm, .csv, and .tsv files.

Can it follow specific financial formatting standards?

Absolutely. It follows industry conventions like blue text for hardcoded inputs, black for formulas, and specific currency/multiple formats used in investment banking and corporate finance.

Excel & Financial Modeling

Name: Excel & Financial Modeling
Author: dobeutech

bydobeutech

•

Data Science & ML

Creates and manages professional spreadsheets with dynamic formulas, financial formatting standards, and advanced data analysis capabilities.

This skill equips Claude with a robust toolkit for handling complex spreadsheet tasks, ranging from high-stakes financial modeling to large-scale data analysis. It enforces industry-standard formatting conventions—such as color-coded inputs and specific currency styles—while prioritizing dynamic Excel formulas over hardcoded values to ensure workbooks remain updateable. By leveraging pandas for data manipulation and openpyxl for precise formatting, combined with a LibreOffice-powered recalculation engine, it delivers error-free, production-ready spreadsheets that meet professional business requirements.

Key Features

01Industry-standard financial formatting including color-coded inputs and custom number styles

02Dynamic formula construction to prevent hardcoded calculation errors

03Support for reading, modifying, and preserving existing workbook templates and styles

04Automated formula recalculation and error verification via LibreOffice integration

051 GitHub stars

06Comprehensive data analysis and visualization using the pandas library

Use Cases

01Building dynamic financial projections, valuation models, and 3-statement models from scratch

02Automating the cleanup and analysis of large CSV or Excel datasets for business reporting

03Updating existing corporate templates with new data while maintaining strict formatting rules

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dobeutech/dobeu-claude-skills xlsx

For use in Claude.ai and ChatGPT

Download Skill