Can I use this for professional financial models?

Absolutely. It follows strict industry standards for color-coding inputs (blue), calculations (black), and links (green/red), along with specific currency and percentage formatting.

Does this skill support complex Excel formulas?

Yes, it prioritizes dynamic Excel formulas over hardcoded values to ensure your spreadsheets remain interactive and updateable by users.

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

The skill includes a mandatory verification step using a recalculation script to identify and fix formula errors before the file is delivered.

Do I need extra software for formula recalculation?

The skill utilizes a recalc.py script that assumes LibreOffice is available to perform background formula evaluation and ensure data accuracy.

Excel & Spreadsheet Pro

Name: Excel & Spreadsheet Pro
Author: BbgnsurfTech

byBbgnsurfTech

•

Ciencia de Datos y ML

Automates the creation, editing, and analysis of professional spreadsheets with support for complex formulas and financial modeling standards.

This skill empowers Claude to interact natively with Excel files, allowing for sophisticated data manipulation and professional financial modeling. It ensures high-quality output by enforcing zero-error formula rules, preserving existing template formatting, and applying industry-standard color coding and number formats. By leveraging tools like pandas and openpyxl, alongside a dedicated recalculation engine, it bridges the gap between AI-generated data and fully functional, dynamic spreadsheet files that remain updateable for end users.

Características Principales

01Seamless preservation of existing spreadsheet templates and formatting conventions

023 GitHub stars

03Automated formula recalculation and error detection via LibreOffice-backed scripts

04Dynamic formula generation using openpyxl to ensure spreadsheets remain updateable

05Professional financial modeling with industry-standard color-coding and formatting

06Advanced data analysis and visualization capabilities using the pandas library

Casos de Uso

01Building automated financial projection models with dynamic growth rates and assumptions

02Analyzing large datasets from CSV or XLSX files and generating visual summary reports

03Updating existing corporate templates with new data while maintaining style and formula integrity

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