Can it handle professional financial modeling standards?

Yes, it follows industry-standard conventions such as blue text for hardcoded inputs, black for formulas, and specific currency/multiple formatting.

Will it overwrite my existing Excel template styles?

No, the skill is instructed to study and exactly match existing formats and conventions when modifying files, ensuring your templates remain consistent.

Does it support formats other than .xlsx?

Absolutely, it handles .xlsm, .csv, and .tsv files using Python's robust data processing libraries like pandas.

Can it perform data visualization within the spreadsheet?

Yes, it leverages pandas for analysis and openpyxl to create formatted tables and visual representations of data directly within the workbook.

How does this skill ensure Excel formulas actually work?

It uses a specialized recalculation script via LibreOffice to verify all formulas and catch common errors like #REF!, #VALUE!, or #DIV/0! before delivery.

Excel & Data Spreadsheet Specialist

Name: Excel & Data Spreadsheet Specialist
Author: wollfoo

bywollfoo

•

데이터 과학 및 ML

Automates complex spreadsheet creation, data analysis, and financial modeling with professional-grade formatting and formula integrity.

소개

This skill empowers Claude to handle comprehensive Excel tasks, ranging from simple data entry and CSV manipulation to building sophisticated financial models. It enforces industry-standard formatting, ensures zero formula errors through automated recalculation scripts, and utilizes powerful Python libraries like pandas and openpyxl. Whether you are generating dynamic reports, analyzing large datasets, or maintaining complex templates, this tool provides the structural and logical guidelines necessary for production-ready spreadsheet deliverables.

주요 기능

Automated Excel formula recalculation and error verification using LibreOffice integration
1 GitHub stars
Industry-standard financial model color coding and number formatting rules
Data analysis and visualization using pandas and openpyxl integration
Comprehensive support for .xlsx, .xlsm, .csv, and .tsv file formats
Template preservation and custom style matching for modifying existing workbooks

사용 사례

Analyzing large CSV/Excel datasets and generating summarized report workbooks with charts
Building automated financial models with dynamic growth assumptions and professional formatting
Updating existing corporate Excel templates while preserving legacy formulas and styling

소개

주요 기능

Automated Excel formula recalculation and error verification using LibreOffice integration
1 GitHub stars
Industry-standard financial model color coding and number formatting rules
Data analysis and visualization using pandas and openpyxl integration
Comprehensive support for .xlsx, .xlsm, .csv, and .tsv file formats
Template preservation and custom style matching for modifying existing workbooks

사용 사례

Analyzing large CSV/Excel datasets and generating summarized report workbooks with charts
Building automated financial models with dynamic growth assumptions and professional formatting
Updating existing corporate Excel templates while preserving legacy formulas and styling