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

Ciencia de Datos y ML

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

Acerca de

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.

Características Principales

Dynamic Formula Logic: Prioritizes live Excel formulas over hardcoded results to ensure workbooks remain updateable.
0 GitHub stars
Financial Standards Compliance: Automatically applies industry-standard color coding, number formatting, and assumption documentation.
Automated Error Verification: Scans workbooks for #REF!, #DIV/0!, and #VALUE! errors using a dedicated recalculation script.
Template Preservation: Intelligently reads and matches existing formatting conventions when modifying established spreadsheet templates.
Dual-Library Integration: Leverages pandas for high-performance data analysis and openpyxl for granular formatting and styling.

Casos de Uso

Building investment-grade financial models with automated projections and scenario analysis.
Analyzing large CSV/XLSX datasets to generate summarized reports with visualizations and summary tables.
Updating legacy spreadsheets with new data while maintaining complex formula chains and existing styles.

Acerca de

Características Principales

Dynamic Formula Logic: Prioritizes live Excel formulas over hardcoded results to ensure workbooks remain updateable.
0 GitHub stars
Financial Standards Compliance: Automatically applies industry-standard color coding, number formatting, and assumption documentation.
Automated Error Verification: Scans workbooks for #REF!, #DIV/0!, and #VALUE! errors using a dedicated recalculation script.
Template Preservation: Intelligently reads and matches existing formatting conventions when modifying established spreadsheet templates.
Dual-Library Integration: Leverages pandas for high-performance data analysis and openpyxl for granular formatting and styling.

Casos de Uso

Building investment-grade financial models with automated projections and scenario analysis.
Analyzing large CSV/XLSX datasets to generate summarized reports with visualizations and summary tables.
Updating legacy spreadsheets with new data while maintaining complex formula chains and existing styles.