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

0•

Data Science & 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.

Key Features

01Seamless support for .xlsx, .xlsm, .csv, and .tsv formats

02Advanced data analysis and visualization capabilities using pandas

030 GitHub stars

04Dynamic formula generation with automated error checking and recalculation

05Automated template preservation and style matching for existing files

06Industry-standard financial modeling standards including color-coded inputs

Use Cases

01Automating recurring data analysis and executive summary report generation

02Updating legacy enterprise spreadsheet templates while preserving complex styles

03Building investment-grade financial models from raw data or text prompts

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add krishagel/geoffrey xlsx

For use in Claude.ai and ChatGPT

Download Skill