How does this skill handle Excel formulas?

It prioritizes standard, legible formulas and performs a recalculation check to ensure no errors like #REF! or #DIV/0! exist before providing the file.

Which spreadsheet formats are supported by this skill?

The skill supports .xlsx, .xlsm, .csv, and .tsv files for reading, editing, and creating new workbooks.

Does it support professional financial formatting?

Yes, it includes specific rules for investment banking and finance, such as blue-text for inputs, black for formulas, and specialized number formats for multiples and currencies.

Can it create charts and visualizations?

Yes, the skill can generate in-sheet charts, apply conditional formatting, and use visual elements like borders and fills to create professional dashboards.

Will it break my existing spreadsheet formatting?

No, the skill is designed to render and examine existing styles before making changes, ensuring that all modifications match the original document's aesthetic.

Spreadsheet Automation & Financial Modeling

Name: Spreadsheet Automation & Financial Modeling
Author: lawvable

bylawvable

•

Data Science & ML

Automates the creation, analysis, and professional formatting of complex spreadsheets and financial models with visual validation.

About

This skill provides a comprehensive toolkit for advanced spreadsheet manipulation within Claude Code. It enables the creation of presentation-ready workbooks, sophisticated data analysis, and the preservation of complex formula structures in .xlsx, .csv, and .tsv formats. Beyond simple data entry, it enforces industry-standard formatting—including specific conventions for investment banking and financial modeling—and utilizes visual quality control to ensure every sheet is professionally styled and mathematically accurate before delivery.

Key Features

Robust tabular data analysis including aggregation, filtering, and metric computation
Seamless modification of existing workbooks while preserving legacy formulas and styles
Professional financial modeling with standard color-coding and layout conventions
38 GitHub stars
Visual quality control using rendered images to verify formatting and style
Advanced formula management with automatic recalculation and error validation

Use Cases

Building investment banking-grade DCF or LBO models with automated formatting
Updating complex legacy spreadsheets without breaking existing cell references or styles
Converting raw datasets into structured Excel reports with in-sheet charts and pivot tables

About

Key Features

Robust tabular data analysis including aggregation, filtering, and metric computation
Seamless modification of existing workbooks while preserving legacy formulas and styles
Professional financial modeling with standard color-coding and layout conventions
38 GitHub stars
Visual quality control using rendered images to verify formatting and style
Advanced formula management with automatic recalculation and error validation

Use Cases

Building investment banking-grade DCF or LBO models with automated formatting
Updating complex legacy spreadsheets without breaking existing cell references or styles
Converting raw datasets into structured Excel reports with in-sheet charts and pivot tables