Does this skill support complex Excel formulas?

Yes, it prioritizes dynamic Excel formulas over hardcoded values and includes a validation step using a recalculation script to ensure zero formula errors.

Can it be used for professional financial modeling?

Absolutely. It follows strict industry standards for color-coding (blue for inputs, black for formulas) and specific number formatting for currencies, multiples, and percentages.

How does it handle formula recalculation?

The skill includes a recalc.py script that uses LibreOffice to evaluate all formulas and identify any calculation errors before finalizing the file.

What Python libraries does this skill utilize?

It uses pandas for data manipulation and analysis, and openpyxl for detailed cell formatting, styling, and formula management.

Excel & Spreadsheet Expert

Name: Excel & Spreadsheet Expert
Author: billlzzz18

bybilllzzz18

•

Data Science & ML

Creates, modifies, and analyzes Excel spreadsheets with production-grade formulas, professional formatting, and financial modeling standards.

This skill empowers Claude to handle complex spreadsheet tasks, ranging from high-performance data analysis with pandas to building sophisticated financial models using openpyxl. It enforces strict industry standards for financial modeling, such as blue-text inputs and black-text formulas, while ensuring zero-error integrity through a mandatory recalculation workflow. By prioritizing dynamic cell references over hardcoded values, it ensures that every spreadsheet produced remains scalable, updateable, and professional.

Key Features

011 GitHub stars

02Industry-standard financial modeling formatting and color-coding

03Template preservation and style-matching for existing workbooks

04Dynamic formula generation with zero-error validation (#REF!, #DIV/0!)

05Comprehensive data analysis and visualization using pandas and openpyxl

06Automated formula recalculation via LibreOffice integration

Use Cases

01Generating formatted executive reports with complex cross-sheet calculations

02Processing and cleaning large datasets from CSV or XLSX files for business intelligence

03Building automated financial projection models with dynamic growth assumptions

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add billlzzz18/bl1nk-skill-platform xlsx

For use in Claude.ai and ChatGPT

Download Skill