What are the financial modeling standards used?

The skill defaults to industry standards: blue text for hardcoded inputs, black for formulas, green for internal sheet links, and red for external references.

Does this skill support existing Excel templates?

Yes, the skill is designed to study and match existing formats, styles, and conventions, ensuring that updates to your files preserve established patterns.

How does the skill handle formula errors?

It includes a mandatory recalculation step using a recalc script that identifies errors like #REF! or #DIV/0!, providing a detailed report to ensure every deliverable is error-free.

Do I need any external software to use this skill?

For full formula recalculation and verification, the skill assumes LibreOffice is installed, which it uses to headlessly process and validate workbook values.

Advanced Excel & Spreadsheet Toolkit

Name: Advanced Excel & Spreadsheet Toolkit
Author: henkisdabro

byhenkisdabro

•

Data Science & ML

Automates professional spreadsheet creation, complex financial modeling, and data analysis with formula-driven accuracy.

The xlsx skill enables Claude to function as a professional data analyst and financial modeler by providing a structured framework for creating, editing, and analyzing Excel files. It prioritizes dynamic formulas over hardcoded values and includes a mandatory recalculation engine to ensure zero formula errors. Designed for high-stakes environments, it follows industry-standard financial formatting—such as color-coded inputs and specific number formats—while maintaining the integrity of existing templates. By leveraging pandas for analysis and openpyxl for precision formatting, this skill allows for the automated generation of production-grade workbooks and reports directly from the Claude Code interface.

Key Features

01Smart template preservation that matches existing file conventions and styles

02Industry-standard financial formatting including RGB color-coding for inputs and formulas

03Automated workbook recalculation via LibreOffice-powered execution scripts

04Comprehensive data manipulation using pandas and openpyxl for complex workbooks

058 GitHub stars

06Dynamic formula injection with automated error verification for #REF! and #DIV/0!

Use Cases

01Building automated financial projection models with standardized color-coded assumptions and links.

02Auditing large workbooks to identify, document, and fix broken cell references and formula errors.

03Transforming raw CSV/TSV data into formatted Excel dashboards with charts and summary tables.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add henkisdabro/wookstar-claude-code-plugins xlsx

For use in Claude.ai and ChatGPT

Download Skill