Can I use it for data visualization?

Yes, it leverages pandas for data manipulation and openpyxl for formatting, allowing for the creation of clean, professional data visualizations within the spreadsheet.

Does it support industry-standard financial formatting?

Absolutely. It follows standard conventions such as blue text for inputs, black for formulas, and yellow backgrounds for key assumptions to ensure models are audit-ready.

Why is LibreOffice mentioned in the requirements?

LibreOffice is used as a backend engine to perform actual cell recalculations, ensuring that the 'data' values in the spreadsheet match the results of the formulas provided.

Can it modify existing Excel templates without breaking them?

Yes. The skill is designed to study and match existing formats, styles, and conventions, ensuring that modifications blend seamlessly with your established patterns.

How does this skill handle formula errors?

It utilizes a recalculation script powered by LibreOffice to verify every formula cell, identifying and flagging errors like #REF!, #DIV/0!, and #VALUE! before the file is finalized.

Advanced Excel & Financial Modeling

Name: Advanced Excel & Financial Modeling
Author: zephyrwang6

byzephyrwang6

•

Data Science & ML

Automates professional spreadsheet creation, data analysis, and financial modeling with rigorous formula verification and industry-standard formatting.

This skill transforms Claude into a sophisticated spreadsheet engineer capable of building complex, production-grade workbooks. It provides a robust framework for creating and analyzing .xlsx and .csv files using pandas and openpyxl, with a specific focus on financial modeling standards. The skill enforces strict color-coding for inputs and formulas, ensures zero formula errors through automated recalculation via LibreOffice, and preserves the integrity of existing templates. By prioritizing dynamic formulas over hardcoded values, it ensures spreadsheets remain updateable and transparent for professional use cases.

Key Features

01Industry-standard financial model formatting and RGB color-coding conventions

02Dynamic spreadsheet generation using live Excel formulas instead of hardcoded results

03Seamless integration of pandas for data analysis and openpyxl for visual styling

04Requirement-driven documentation for hardcoded values and data sources

0537 GitHub stars

06Automated formula recalculation and error detection (#REF!, #DIV/0!) via LibreOffice

Use Cases

01Performing deep data analysis on large datasets and exporting formatted summary reports

02Building dynamic financial projection models with automated growth and scenario assumptions

03Updating legacy Excel templates while strictly maintaining existing styles and conventions

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add zephyrwang6/myskill xlsx

For use in Claude.ai and ChatGPT

Download Skill