How does this skill handle formula errors?

It uses a mandatory verification workflow and the recalc.py script to scan for and eliminate common Excel errors like #REF!, #VALUE!, and #DIV/0! before delivery.

Does it support financial modeling standards?

Absolutely. It follows industry-standard color coding (blue for inputs, black for formulas) and professional number formatting for currencies, multiples, and percentages.

Can it preserve my existing spreadsheet's formatting?

Yes, the skill is designed to study and match your existing templates' styles, conventions, and patterns when modifying files to ensure consistency.

What libraries does it use for Excel operations?

It utilizes pandas for data-heavy analysis and openpyxl for tasks requiring precise formatting, styles, and complex formula preservation.

Excel & Spreadsheet Mastery

Name: Excel & Spreadsheet Mastery
Author: BA-CalderonMorales

byBA-CalderonMorales

数据科学与机器学习

Automates the creation, editing, and sophisticated analysis of Excel spreadsheets with a focus on financial modeling standards and formula integrity.

关于

This skill empowers Claude to handle complex spreadsheet tasks by combining the data manipulation power of pandas with the formatting and formula capabilities of openpyxl. It enforces high-standard financial modeling practices, including industry-standard color coding and rigorous formula error prevention. Whether building dynamic financial models from scratch, analyzing large datasets, or updating existing templates, it ensures all outputs are professional, accurate, and fully recalculated using integrated LibreOffice tools. It prioritizes dynamic formulas over hardcoded values, ensuring your spreadsheets remain functional and updateable.

主要功能

Industry-standard financial modeling color coding and professional number formatting
Dynamic formula generation and validation to eliminate #REF! and #DIV/0! errors
Seamless integration with pandas for data analysis and openpyxl for complex styling
Template preservation that respects existing styles and conventions during updates
Automated formula recalculation using LibreOffice to ensure data consistency
0 GitHub stars

使用场景

Building automated financial models with dynamic projections and professional formatting
Batch updating existing spreadsheet templates while preserving complex formulas and styling
Analyzing and visualizing large datasets within Excel workbooks for business reporting

关于

主要功能

Industry-standard financial modeling color coding and professional number formatting
Dynamic formula generation and validation to eliminate #REF! and #DIV/0! errors
Seamless integration with pandas for data analysis and openpyxl for complex styling
Template preservation that respects existing styles and conventions during updates
Automated formula recalculation using LibreOffice to ensure data consistency
0 GitHub stars

使用场景

Building automated financial models with dynamic projections and professional formatting
Batch updating existing spreadsheet templates while preserving complex formulas and styling
Analyzing and visualizing large datasets within Excel workbooks for business reporting