Can it handle industry-standard financial formatting?

Absolutely. It follows strict conventions such as blue text for hardcoded inputs, black for formulas, and green for internal worksheet links.

How are formula errors prevented?

The skill includes a mandatory verification step using a recalculation script that identifies and flags errors like #REF! or #DIV/0! before the file is finalized.

Does this skill support existing Excel templates?

Yes, it is designed to study and match existing formats, styles, and conventions to preserve your specific template patterns during modification.

Does it use Python for calculations or Excel formulas?

It prioritizes native Excel formulas over hardcoded Python results to ensure the resulting spreadsheet remains dynamic and updateable by the end user.

Is LibreOffice required for this skill?

LibreOffice is used for the underlying formula recalculation process to ensure all cell values are accurately updated and verified.

Professional Excel & Financial Modeling

Name: Professional Excel & Financial Modeling
Author: claudiodearaujo

byclaudiodearaujo

0•

데이터 과학 및 ML

Creates, edits, and analyzes professional-grade Excel spreadsheets with advanced financial modeling standards and error-free formula calculation.

The xlsx-official skill empowers Claude to handle complex spreadsheet tasks ranging from high-level data analysis to granular financial modeling. It enforces strict industry standards for color coding, number formatting, and formula construction, ensuring that every generated workbook is audit-ready and professional. By utilizing pandas for data manipulation and openpyxl for structural formatting, the skill preserves existing templates while adding dynamic formulas that are verified through a mandatory recalculation process using LibreOffice. It is the ideal tool for users needing robust, error-free Excel outputs that go beyond simple data dumps.

주요 기능

01Zero-error formula enforcement for #REF!, #DIV/0!, and #VALUE! issues

02Industry-standard financial modeling with specific color coding and formatting rules

03Automated formula recalculation and verification via LibreOffice integration

04Comprehensive support for .xlsx, .xlsm, .csv, and .tsv file formats

05Preservation of existing spreadsheet templates and custom formatting conventions

060 GitHub stars

사용 사례

01Automating the update of complex corporate reporting templates while maintaining styles

02Building dynamic 3-statement financial models with clearly defined assumptions and drivers

03Performing deep data analysis on large datasets with formatted Excel exports for stakeholders

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claudiodearaujo/izacenter xlsx-official

For use in Claude.ai and ChatGPT

Download Skill