Does this skill support complex Excel formulas?

Yes, it supports full formula implementation and uses a dedicated recalculation script to ensure all calculated values are updated and verified for accuracy.

Can it handle financial modeling standards?

Absolutely. The skill follows industry-standard conventions such as blue text for hardcoded inputs, black for formulas, and specific currency formatting.

How does it prevent common Excel errors like #REF! or #DIV/0!?

It includes a mandatory verification step using a recalc script that scans all cells for errors and provides a detailed JSON summary of any issues found.

Does it preserve existing spreadsheet formatting?

Yes, the skill is designed to study and exactly match existing formats, styles, and conventions when modifying your specific templates.

What libraries are used for these operations?

The skill utilizes pandas for high-performance data manipulation and openpyxl for detailed formatting and formula-heavy spreadsheet creation.

Excel & Spreadsheet Management

Name: Excel & Spreadsheet Management
Author: nerver111

bynerver111

0•

데이터 과학 및 ML

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 data analysis with pandas to generating high-fidelity financial models using openpyxl. It ensures formula integrity by using a dedicated recalculation script and adheres to industry-standard formatting for professional outputs. Whether you need to audit existing workbooks, visualize data, or build dynamic templates from scratch, this skill provides the necessary tools and best practices to maintain accuracy, professional aesthetics, and dynamic functionality.

주요 기능

01Comprehensive data analysis and visualization capabilities

02Industry-standard financial modeling color coding and formatting

03Preservation of existing workbook templates and style conventions

04Automated spreadsheet creation and editing with openpyxl and pandas

050 GitHub stars

06Mandatory formula recalculation and error verification via LibreOffice

사용 사례

01Building dynamic financial models with automated projections and assumption cells

02Analyzing large datasets to generate summarized Excel reports with charts

03Auditing and repairing formula errors in complex legacy spreadsheets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nerver111/git-skill-test xlsx

For use in Claude.ai and ChatGPT