Can it follow professional financial modeling standards?

Absolutely. It follows industry conventions like blue text for inputs, black for formulas, and specific formatting for currency, multiples, and percentages.

How does it handle formula errors like #REF! or #DIV/0!?

The skill includes a mandatory verification step using a recalculation script that identifies and prompts for fixes to any formula errors before finalizing the file.

Will it overwrite my existing spreadsheet formatting?

No, the skill is designed to study and exactly match existing template conventions, styles, and patterns when modifying your files.

Does this skill support complex Excel formulas?

Yes, it specifically prioritizes generating dynamic Excel formulas instead of hardcoding values, ensuring the spreadsheet remains interactive and functional.

Do I need any external software for this to work?

For full formula recalculation and error verification, the skill requires LibreOffice to be installed on the host system.

Advanced Excel & Data Analysis

Name: Advanced Excel & Data Analysis
Author: krishagel

bykrishagel

데이터 과학 및 ML

Manages complex spreadsheet creation, modification, and financial modeling with a focus on dynamic formulas and industry-standard formatting.

소개

This skill empowers Claude to perform sophisticated spreadsheet tasks, ranging from simple CSV processing to building complex investment-grade financial models. It leverages pandas for high-performance data manipulation and openpyxl for granular cell formatting, ensuring that all workbooks remain dynamic by prioritizing live Excel formulas over hardcoded values. The skill includes a dedicated verification layer that uses LibreOffice to recalculate formulas and eliminate common errors like #REF! or #DIV/0!, making it an essential tool for analysts and developers who need reliable, production-ready spreadsheet automation.

주요 기능

Seamless support for .xlsx, .xlsm, .csv, and .tsv formats
Advanced data analysis and visualization capabilities using pandas
0 GitHub stars
Dynamic formula generation with automated error checking and recalculation
Automated template preservation and style matching for existing files
Industry-standard financial modeling standards including color-coded inputs

사용 사례

Automating recurring data analysis and executive summary report generation
Updating legacy enterprise spreadsheet templates while preserving complex styles
Building investment-grade financial models from raw data or text prompts

소개

주요 기능

Seamless support for .xlsx, .xlsm, .csv, and .tsv formats
Advanced data analysis and visualization capabilities using pandas
0 GitHub stars
Dynamic formula generation with automated error checking and recalculation
Automated template preservation and style matching for existing files
Industry-standard financial modeling standards including color-coded inputs

사용 사례

Automating recurring data analysis and executive summary report generation
Updating legacy enterprise spreadsheet templates while preserving complex styles
Building investment-grade financial models from raw data or text prompts