Can I use it to analyze large datasets?

Absolutely. It utilizes the pandas library for efficient data manipulation and analysis, making it suitable for processing large CSV or Excel files before formatting them.

Does it support industry-standard financial modeling?

Yes, it follows strict conventions such as blue text for hardcoded inputs, black for formulas, and green for internal worksheet links, along with specific currency and percentage formatting.

How does this skill handle Excel formula errors?

The skill uses a mandatory recalculation script (recalc.py) integrated with LibreOffice to verify every cell for errors like #REF!, #DIV/0!, and #VALUE!, ensuring zero-error delivery.

Why does it use formulas instead of hardcoded values?

Using formulas ensures the spreadsheet remains dynamic and functional. If you change a source value, the rest of the spreadsheet will update automatically.

Will it overwrite my existing spreadsheet formatting?

No, the skill is designed to study and match existing styles and conventions when modifying a file, ensuring your templates remain consistent.

Excel & Spreadsheet Mastery

Name: Excel & Spreadsheet Mastery
Author: kyh0703

bykyh0703

0•

Data Science & ML

Automates professional spreadsheet creation, data analysis, and financial modeling with robust formula verification and formatting.

This skill transforms Claude into an advanced Excel expert capable of generating complex workbooks with dynamic formulas, industry-standard financial formatting, and automated error checking. It seamlessly integrates powerful libraries like pandas for data manipulation and openpyxl for precision formatting, ensuring that all spreadsheets are functionally sound and visually professional. The skill is uniquely designed to prioritize dynamic formulas over hardcoded values and includes a specialized recalculation workflow using LibreOffice to guarantee zero-error delivery for financial models and data reports.

Key Features

01Dynamic Formula Logic: Prioritizes live Excel formulas over hardcoded results to ensure workbooks remain updateable.

020 GitHub stars

03Financial Standards Compliance: Automatically applies industry-standard color coding, number formatting, and assumption documentation.

04Automated Error Verification: Scans workbooks for #REF!, #DIV/0!, and #VALUE! errors using a dedicated recalculation script.

05Template Preservation: Intelligently reads and matches existing formatting conventions when modifying established spreadsheet templates.

06Dual-Library Integration: Leverages pandas for high-performance data analysis and openpyxl for granular formatting and styling.

Use Cases

01Building investment-grade financial models with automated projections and scenario analysis.

02Analyzing large CSV/XLSX datasets to generate summarized reports with visualizations and summary tables.

03Updating legacy spreadsheets with new data while maintaining complex formula chains and existing styles.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add kyh0703/claude-plugins xlsx

For use in Claude.ai and ChatGPT

Download Skill