What libraries are required to run these operations?

The skill utilizes pandas for heavy data analysis and openpyxl for granular control over formatting, formulas, and sheet structure.

How does the skill ensure there are no formula errors?

The skill uses a mandatory recalculation workflow via a LibreOffice script that checks every cell for common errors like #REF!, #DIV/0!, and #VALUE!, providing a detailed report for correction.

Can I use this for professional investment banking models?

Absolutely. It follows strict industry standards such as blue text for hardcoded inputs, black for formulas, and green for internal worksheet links.

Does this skill support existing Excel templates?

Yes, it is specifically designed to study and match the existing formatting, styles, and conventions of your files, ensuring that new data blends seamlessly with established patterns.

Why does it prefer formulas over hardcoded values?

Using Excel formulas (like =SUM(B2:B9)) instead of Python-calculated results ensures the spreadsheet remains dynamic, allowing users to update data directly in Excel and see immediate recalculations.

Excel & Financial Modeling

Name: Excel & Financial Modeling
Author: ZhanlinCui

byZhanlinCui

•

Ciencia de Datos y ML

Automates professional-grade spreadsheet creation, financial modeling, and data analysis with dynamic formula preservation and error-free validation.

This skill empowers Claude to act as a high-end spreadsheet engineer and financial analyst. It provides a robust framework for creating, editing, and analyzing .xlsx and .csv files using a combination of pandas for data manipulation and openpyxl for complex formatting. Unlike basic tools, it enforces industry-standard financial modeling conventions, ensures dynamic formula integrity over hardcoded values, and utilizes a LibreOffice-backed recalculation engine to guarantee zero formula errors in the final output.

Características Principales

01Professional financial modeling with industry-standard color coding and number formatting

02Seamless data analysis, cleaning, and visualization via pandas

03Automated formula recalculation and error scanning using LibreOffice integration

04Dynamic formula generation that avoids hardcoding to ensure updateable workbooks

0517 GitHub stars

06Template preservation that respects and matches existing file styles and conventions

Casos de Uso

01Updating existing reporting templates while maintaining formula logic and structural integrity

02Building investment-grade financial models with automated valuation multiples and growth projections

03Performing complex data cleaning and statistical analysis on large enterprise datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add zhanlincui/ultimate-agent-skills-collection xlsx

For use in Claude.ai and ChatGPT

Download Skill