Does it work with existing Excel templates?

Yes, it is designed to study and match existing formatting, styles, and conventions when modifying established files to ensure consistency.

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

The skill utilizes a mandatory recalculation and verification step via a dedicated script to identify, report, and fix formula errors before the file is finalized.

Can it follow specific financial modeling standards?

Absolutely. It follows industry conventions such as blue text for hardcoded inputs, black for formulas, and specific rules for currency, multiples, and negative numbers.

Does this skill support complex Excel formulas?

Yes, it prioritizes dynamic Excel formulas over hardcoded Python calculations, ensuring the workbook remains fully functional and updateable by end-users.

What Python libraries are used for these operations?

The skill intelligently switches between pandas for data-heavy analysis and openpyxl for tasks requiring precise formatting and formula management.

Professional Excel & Spreadsheet Suite

Name: Professional Excel & Spreadsheet Suite
Author: BbgnsurfTech

byBbgnsurfTech

•

Productivity & Workflow

Automates professional-grade spreadsheet creation, data analysis, and financial modeling with strict formula integrity and industry-standard formatting.

This skill empowers Claude to function as an expert Excel analyst, capable of creating, editing, and analyzing complex workbooks while maintaining absolute formula dynamicism. It specializes in high-stakes financial modeling, implementing industry-standard color coding (blue for inputs, black for formulas) and rigorous documentation of data sources. By combining pandas for efficient data manipulation with openpyxl for precise formatting and formula preservation, the skill ensures that spreadsheets remain updateable and error-free. It includes a built-in recalculation workflow to validate formulas and eliminate common errors like #REF! or #DIV/0!, making it the ideal tool for generating production-ready business reports and analytical models.

Key Features

01Dynamic formula generation to avoid hardcoded calculation values

023 GitHub stars

03Automated formula recalculation and multi-sheet error validation

04Detailed source documentation and cell-level auditing for transparency

05Industry-standard financial modeling formatting and color-coding conventions

06Hybrid pandas and openpyxl workflows for optimal data processing

Use Cases

01Auditing and fixing formula errors in existing complex workbooks

02Building dynamic financial projection models with automated scenario inputs

03Converting and formatting raw CSV data into professional, multi-sheet Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection xlsx

For use in Claude.ai and ChatGPT

Download Skill