Can this skill handle complex Excel formulas?

Yes, the skill prioritizes Excel formulas over hardcoded values and includes a mandatory recalculation step to ensure all logic is dynamic and error-free.

Does it support industry-standard financial formatting?

Absolutely. It follows strict conventions such as blue text for hardcoded inputs, black for formulas, and specific formatting for currencies, multiples, and percentages.

Can I use it to modify existing Excel templates?

Yes, the skill is designed to study and exactly match existing formats and styles, ensuring that your established template conventions are always preserved.

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

It uses a specialized recalculation script powered by LibreOffice that scans every cell for errors and returns a detailed report for automated fixing.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: kivilaid

bykivilaid

•

Data Science & ML

Automates the creation, editing, and analysis of Excel spreadsheets with a focus on dynamic formulas and financial modeling standards.

About

This skill empowers Claude to handle complex spreadsheet tasks, ranging from simple CSV processing to building sophisticated financial models. It ensures data integrity by prioritizing Excel formulas over hardcoded values and includes a dedicated verification process using LibreOffice to recalculate and validate every cell. Whether you are generating reports from data frames using pandas or applying professional formatting with openpyxl, this skill maintains industry-standard conventions for color coding, number formatting, and structural documentation, making it indispensable for data-driven workflows.

Key Features

Professional financial modeling standards for color coding and formatting
Advanced spreadsheet creation and editing using openpyxl and pandas
Comprehensive data analysis and visualization capabilities
6 GitHub stars
Automatic formula recalculation and error detection via LibreOffice
Intelligent preservation of existing workbook templates and styles

Use Cases

Building dynamic financial models with automated scenario analysis and standardized formatting
Transforming raw data sets into formatted, boardroom-ready Excel reports with charts
Updating existing complex spreadsheets while preserving original formulas and structure

About

Key Features

Professional financial modeling standards for color coding and formatting
Advanced spreadsheet creation and editing using openpyxl and pandas
Comprehensive data analysis and visualization capabilities
6 GitHub stars
Automatic formula recalculation and error detection via LibreOffice
Intelligent preservation of existing workbook templates and styles

Use Cases

Building dynamic financial models with automated scenario analysis and standardized formatting
Transforming raw data sets into formatted, boardroom-ready Excel reports with charts
Updating existing complex spreadsheets while preserving original formulas and structure