Does it follow standard investment banking formatting?

Yes, by default it applies industry standards such as blue text for hardcoded inputs, black for formulas, and specific currency/percentage formatting rules.

Why does the skill require LibreOffice?

LibreOffice is used as a headless engine to recalculate formulas created by Python libraries, ensuring that values are updated and verified before you even open the file.

Can I use this for complex data science tasks?

Absolutely. It leverages the pandas library for heavy data manipulation and visualization, which can then be exported into formatted Excel workbooks for stakeholders.

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

The skill includes a mandatory verification step using a recalculation script that scans all cells for errors and provides a detailed report to ensure the final output is 100% accurate.

Does this skill support existing Excel templates?

Yes, it is specifically designed to study and match existing formats, styles, and conventions, ensuring all modifications blend perfectly with your established corporate templates.

Advanced Excel & Financial Modeling

Name: Advanced Excel & Financial Modeling
Author: davepoon

bydavepoon

•

2,257

•

Data Science & ML

Enables Claude to create, analyze, and format professional Excel spreadsheets and financial models with formula-preserving capabilities.

The XLSX skill transforms Claude into a spreadsheet expert capable of generating complex financial models, performing deep data analysis, and maintaining existing templates with precision. It bridges the gap between Python-based data processing and native Excel functionality by prioritizing dynamic formulas over hardcoded values, enforcing industry-standard formatting (such as blue-text inputs), and utilizing a specialized recalculation engine to ensure zero-error outputs. Whether building a projection model from scratch or updating corporate reporting templates, this skill ensures professional-grade accuracy and styling across .xlsx, .csv, and .tsv formats.

Key Features

012,257 GitHub stars

02Precise template preservation that matches existing styles, conventions, and cell offsets

03Dual-library support utilizing pandas for data analysis and openpyxl for granular formatting

04Automated spreadsheet recalculation and error detection (#REF!, #DIV/0!) using LibreOffice integration

05Formula-first workflow that prioritizes dynamic cell references over static Python-calculated values

06Industry-standard financial model formatting with automated color-coding for inputs and calculations

Use Cases

01Building dynamic 3-statement financial models with automated scenario formatting and audit trails

02Updating legacy spreadsheets while maintaining original formula structures and formatting conventions

03Performing complex data analysis in pandas and exporting results to high-fidelity, board-ready Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add davepoon/buildwithclaude xlsx

For use in Claude.ai and ChatGPT

Download Skill