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

It utilizes a mandatory recalculation script (recalc.py) that scans every cell for errors, providing a detailed JSON summary to identify and fix issues automatically.

Can I use this for professional financial modeling?

Absolutely. The skill follows strict industry standards, including specific color-coding for inputs and calculations, and professional number formatting for currencies and multiples.

Which Python libraries are used for spreadsheet processing?

The skill intelligently switches between pandas for data-heavy analysis and openpyxl for tasks requiring complex formatting, styles, and formula preservation.

Does this skill support complex Excel formulas?

Yes, it supports full Excel formula syntax and includes a recalculation engine to ensure all formulas are active and error-free upon delivery.

Can it modify my existing corporate templates?

Yes, the skill is designed to study existing formatting and styles to ensure any modifications match your established template conventions exactly.

Advanced Excel & Data Analysis

Name: Advanced Excel & Data Analysis
Author: XD3an

byXD3an

•

数据科学与机器学习

Automates the creation, editing, and analysis of professional Excel spreadsheets with advanced formula support and financial modeling standards.

This skill empowers Claude to handle complex spreadsheet tasks, ranging from automated data entry to building sophisticated, production-grade financial models. It leverages the power of pandas for high-performance data manipulation and openpyxl for precision formatting and formula preservation. By enforcing industry-standard color coding (blue for inputs, black for formulas) and strict number formatting, it ensures that generated workbooks are professional and error-free. The integration of a recalculation engine allows Claude to validate formulas and resolve errors like #REF! or #DIV/0! before final delivery, ensuring all spreadsheets are dynamic and functional.

主要功能

01Automated formula validation and recalculation using integrated LibreOffice support

02High-performance data analysis and visualization via pandas integration

03Comprehensive support for .xlsx, .xlsm, .csv, and .tsv file formats

048 GitHub stars

05Industry-standard financial modeling with automated color-coding and formatting

06Precision editing of existing Excel templates while preserving original styles

使用场景

01Cleaning, merging, and analyzing large datasets from multiple spreadsheet sources

02Generating dynamic financial models with automated projections and scenario inputs

03Creating executive-ready reports with custom styling, charts, and zero formula errors

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xd3an/awesome-ai-coding-all-in-one xlsx

For use in Claude.ai and ChatGPT

Download Skill