Does this skill support complex Excel formulas?

Yes, it supports full Excel formula syntax and includes a recalculation script (recalc.py) to ensure all values are updated and verified without needing to open Excel manually.

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

The skill includes a mandatory verification step that scans the entire workbook for errors after recalculation, providing a detailed summary of any issues that need fixing.

Can I use this for professional financial modeling?

Absolutely. The skill follows industry standards, such as using blue text for hardcoded inputs, black for formulas, and specific formatting for currency, percentages, and multiples.

Will it ruin the formatting of my existing Excel templates?

No. A core requirement of this skill is to study and exactly match existing formats, styles, and conventions when modifying your files to ensure your templates remain consistent.

Excel & Spreadsheet Mastery

Name: Excel & Spreadsheet Mastery
Author: boku-miyaji

byboku-miyaji

0•

データサイエンスとML

Automates the creation, editing, and analysis of professional Excel workbooks with formula persistence and financial modeling standards.

This skill empowers Claude to handle complex spreadsheet tasks, ranging from simple CSV data manipulation to building sophisticated financial models. It ensures data integrity by enforcing zero-error formula policies and adhering to industry-standard formatting for financial documents, such as blue-text for hardcoded inputs and black-text for formulas. By leveraging powerful Python libraries like pandas and openpyxl alongside a dedicated recalculation engine, the skill allows for the generation of dynamic, updateable workbooks that preserve templates and styles while performing deep data analysis.

主な機能

01Dynamic formula creation using native Excel syntax to ensure spreadsheets remain updateable

02Template preservation that matches existing styles and conventions when modifying files

03Automated formula recalculation and error verification (detects #REF!, #DIV/0!, etc.)

040 GitHub stars

05Professional financial modeling with standardized industry color-coding and number formatting

06Seamless integration of pandas for data analysis and openpyxl for complex cell formatting

ユースケース

01Performing deep data analysis on large datasets and exporting the results into formatted Excel workbooks

02Generating automated monthly business reports from raw data with styled summaries and charts

03Building complex financial projection models with automated growth rates and assumption cells

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add boku-miyaji/claude_dev xlsx

For use in Claude.ai and ChatGPT

Download Skill