Is LibreOffice required for this skill?

For full formula recalculation and verification, the skill utilizes a script that assumes LibreOffice is available to process the Excel engine's calculations automatically.

What file formats are supported?

The skill supports .xlsx, .xlsm, .csv, .tsv, and other common spreadsheet formats for both reading and writing operations.

Can it modify existing Excel templates?

Yes, it is designed to study and match existing styles, formats, and conventions to ensure seamless updates to established corporate templates.

Does it support financial modeling standards?

Yes, it follows industry-standard color coding—such as blue for inputs and black for formulas—and strict number formatting for professional models.

How does this skill handle Excel formulas?

It uses openpyxl to inject formulas as strings and a specialized recalculation script to ensure all values are correctly computed and error-free before delivery.

Excel & Spreadsheet Mastery

Name: Excel & Spreadsheet Mastery
Author: theflysurfer

bytheflysurfer

生産性とワークフロー

Manages professional Excel workbooks with advanced formulas, financial modeling standards, and automated data analysis.

概要

This skill empowers Claude to create, modify, and analyze complex Excel spreadsheets while adhering to professional financial modeling standards. It ensures spreadsheet integrity by prioritizing dynamic formulas over hardcoded values and includes a mandatory recalculation step to eliminate common errors like #REF! or #DIV/0!. Whether you are building multi-sheet financial models with industry-standard color coding, performing bulk data analysis with pandas, or updating existing corporate templates, this skill provides the precision and automation required for enterprise-grade spreadsheet management.

主な機能

Professional financial model color-coding (Blue for inputs, Black for formulas)
Strict number formatting for currencies, percentages, and valuation multiples
Advanced formula integration with automated error-free recalculation
Comprehensive data analysis and visualization using pandas and openpyxl
Template preservation and style matching for existing workbooks
0 GitHub stars

ユースケース

Automating the update of corporate reporting templates while preserving existing formulas and styles
Building dynamic, multi-sheet financial projection models with standardized formatting and assumptions
Analyzing large datasets from CSV/TSV files and exporting them into formatted, professional Excel reports

概要

主な機能

Professional financial model color-coding (Blue for inputs, Black for formulas)
Strict number formatting for currencies, percentages, and valuation multiples
Advanced formula integration with automated error-free recalculation
Comprehensive data analysis and visualization using pandas and openpyxl
Template preservation and style matching for existing workbooks
0 GitHub stars

ユースケース

Automating the update of corporate reporting templates while preserving existing formulas and styles
Building dynamic, multi-sheet financial projection models with standardized formatting and assumptions
Analyzing large datasets from CSV/TSV files and exporting them into formatted, professional Excel reports