Can this skill handle complex Excel formulas?

Yes, it supports full formula construction using openpyxl and includes a recalculation script to ensure all formulas are evaluated and error-free.

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

The skill includes a mandatory verification step that scans for errors and provides a detailed summary to fix them before the file is finalized.

Does it support industry-standard financial formatting?

Absolutely. It enforces specific color coding for inputs, formulas, and links, following common investment banking and corporate finance standards.

Can I use it to analyze data from existing spreadsheets?

Yes, it leverages the pandas library to read, analyze, and visualize data from .xlsx, .csv, and .tsv files effectively.

Does it preserve my existing Excel templates?

Yes, it is designed to study and match existing formatting and conventions, ensuring modifications blend seamlessly with your established patterns.

Excel & Financial Modeling

Name: Excel & Financial Modeling
Author: Fergana-Labs

byFergana-Labs

•

Data Science & ML

Creates, analyzes, and manages complex Excel spreadsheets with a focus on financial modeling standards and formula integrity.

The xlsx skill empowers Claude to handle sophisticated spreadsheet tasks ranging from simple data entry to complex financial modeling. It enforces industry-standard color coding—such as blue for hardcoded inputs and black for formulas—to ensure professional-grade outputs. By integrating with pandas for data analysis and openpyxl for precise formatting, the skill allows for dynamic spreadsheet generation where formulas are verified and recalculated via a specialized script, making it an essential tool for analysts who require programmatic yet human-readable Excel workbooks.

Key Features

01Zero-error formula verification and recalculation using LibreOffice integration

02Template preservation to maintain existing file styles and conventions

03Support for complex cell formatting, including custom currency and multiples

04Automated financial model formatting with industry-standard color coding

05Deep data analysis and visualization using the pandas library

0610 GitHub stars

Use Cases

01Automating the update of recurring reporting templates while preserving logic

02Generating dynamic financial models with automated projections and assumptions

03Cleaning and analyzing large datasets from CSV or XLSX files for business intelligence

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add fergana-labs/claude_agent_desktop xlsx

For use in Claude.ai and ChatGPT

Download Skill