Does this skill support complex Excel formulas?

Yes. It specifically avoids hardcoding values, instead generating dynamic Excel formulas and using a LibreOffice-based script to recalculate and verify results.

Can it follow professional financial modeling standards?

Absolutely. It follows industry-standard conventions such as blue text for inputs, black for formulas, and specific formatting for currencies, multiples, and percentages.

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 JSON summary of any issues found.

Is it possible to edit existing Excel templates?

Yes. The skill is designed to study existing templates and exactly match their format, style, and conventions without imposing unwanted standardized formatting.

Excel & Spreadsheet Mastery

Name: Excel & Spreadsheet Mastery
Author: michaelboeding

bymichaelboeding

•

Ciencia de Datos y ML

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

This skill transforms Claude into a high-level data analyst and financial modeler capable of managing complex .xlsx and .xlsm files with precision. It enforces rigorous standards for spreadsheet integrity, such as prioritizing dynamic Excel formulas over hardcoded values and implementing industry-standard color coding for financial models (e.g., blue for inputs, black for calculations). By leveraging pandas for data manipulation and openpyxl for formatting, alongside a specialized LibreOffice-based recalculation workflow, the skill ensures that every spreadsheet produced is accurate, professionally formatted, and free of formula errors like #REF! or #DIV/0!.

Características Principales

019 GitHub stars

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

03Dynamic Excel formula generation and automated recalculation via LibreOffice

04Industry-standard financial model formatting including specific color-coding and number styles

05Robust data analysis, visualization, and manipulation using pandas

06Comprehensive error detection and validation for common spreadsheet issues

Casos de Uso

01Generating complex financial projection models with dynamic assumptions and professional documentation

02Updating legacy spreadsheets while maintaining intricate formatting and cross-sheet formula logic

03Performing bulk data transformations and summary reporting from large Excel or CSV datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add michaelboeding/skills xlsx

For use in Claude.ai and ChatGPT

Download Skill