Does it support financial industry formatting standards?

Absolutely. It follows standard conventions such as blue text for hardcoded inputs, black for formulas, and specific currency, percentage, and multiple formatting.

Can this skill handle existing Excel templates?

Yes, it is designed to load existing workbooks, preserve their formatting and conventions, and modify them without breaking underlying structures or styles.

Can I use Python libraries like pandas with this skill?

Yes, the skill integrates with pandas for data-heavy operations and uses openpyxl for precise cell-level formatting and formula management.

How does the skill ensure formulas are correct?

It uses a specialized recalculation script powered by LibreOffice to verify all cell values and identify common errors like #REF!, #DIV/0!, or #NAME? automatically.

Advanced Excel & Data Analysis

Name: Advanced Excel & Data Analysis
Author: arthur0824hao

byarthur0824hao

데이터 과학 및 ML

Automates the creation, modification, and analysis of professional-grade spreadsheets with precise formula management and financial industry standards.

소개

The xlsx skill empowers Claude to interact deeply with spreadsheet files (.xlsx, .csv, .tsv), moving beyond simple data export to full-featured model building. It supports advanced financial modeling standards—including specific color-coding and cell formatting—and ensures data integrity through automated formula recalculation via LibreOffice. Whether generating complex financial projections, performing large-scale data analysis with pandas, or updating existing templates while preserving styles, this skill provides a robust framework for professional spreadsheet management and error-free reporting.

주요 기능

Industry-standard financial model formatting including specific color-coding for inputs and formulas
Strict preservation of existing styles, templates, and workbook conventions
0 GitHub stars
Comprehensive validation to prevent common Excel errors like #REF!, #DIV/0!, and #VALUE!
High-performance data manipulation and visualization using the pandas library
Dynamic formula insertion with automated recalculation and error checking via LibreOffice

사용 사례

Building automated financial models with dynamic growth assumptions and professional formatting
Analyzing large datasets to generate summarized reports and visualizations in Excel format
Updating legacy corporate reporting templates while maintaining existing styles and logic

소개

주요 기능

Industry-standard financial model formatting including specific color-coding for inputs and formulas
Strict preservation of existing styles, templates, and workbook conventions
0 GitHub stars
Comprehensive validation to prevent common Excel errors like #REF!, #DIV/0!, and #VALUE!
High-performance data manipulation and visualization using the pandas library
Dynamic formula insertion with automated recalculation and error checking via LibreOffice

사용 사례

Building automated financial models with dynamic growth assumptions and professional formatting
Analyzing large datasets to generate summarized reports and visualizations in Excel format
Updating legacy corporate reporting templates while maintaining existing styles and logic