Antigravity Skills - Build and Discover AI Agent SkillsAntigravity Skills

Excel Master Skill · Data Ai

Excel Master: Professional Spreadsheet Automation with Python

Create, edit, and analyze Excel spreadsheets with Python.

Build financial models with formulas, preserve formatting on edits, and recalculate formulas with error detection.

  • Excel
  • Python
  • Spreadsheet
  • Financial Modeling
  • Data Analysis

About This Skill

Master Excel with Python—create financial models, edit files while preserving formulas, and automatically detect errors with industry-standard practices.

Start Working with Excel in Seconds

  1. 1Describe your Excel task (create, edit, or analyze)
  2. 2Get Python code using openpyxl or pandas
  3. 3Run the recalc script to update formulas
  4. 4Verify zero formula errors in output

Core Capabilities

Create Spreadsheets

Build new Excel files with formulas, formatting, color coding, and industry-standard number formats for financial models.

Edit Existing Files

Modify Excel spreadsheets while preserving existing formulas, styles, and template conventions.

Data Analysis

Use pandas to read, analyze, and visualize data from Excel files with statistical summaries.

Formula Recalculation

Run recalc.py to update all formula values using LibreOffice and detect #REF!, #DIV/0!, #VALUE! errors.

Financial Model Standards

Apply industry-standard color coding: blue for inputs, black for formulas, green for cross-sheet links.

Error Detection

Automatically scan all cells for Excel formula errors and get detailed reports with locations.

SKILL.md

---
name: excel-master
description: "Use when creating, editing, or analyzing Excel spreadsheets (.xlsx, .xlsm, .csv, .tsv). For building financial models with formulas, reading data for analysis, modifying existing files while preserving formatting, performing data visualization, and recalculating formulas with error detection."
---

# Excel Master

> Comprehensive spreadsheet creation, editing, and analysis with professional-grade formula handling.

## Overview

This skill enables you to work with Excel files (.xlsx) using Python:
- **Creating** new spreadsheets with formulas and formatting
- **Editing** existing files while preserving formulas and styles
- **Analyzing** data using pandas
- **Recalculating** formulas with LibreOffice and detecting errors

## Core Workflows

1. Choose tool: pandas for data, openpyxl for formulas/formatting
2. Create/Load workbook
3. Modify data, formulas, and formatting
4. Save and run recalc.py
5. Verify zero formula errors

## Financial Model Standards

- **Blue text**: Hardcoded inputs
- **Black text**: ALL formulas
- **Green text**: Cross-sheet links
- **Yellow background**: Key assumptions

Frequently Asked Questions

FAQ

Can I recalculate formulas without Excel installed?
Yes! The recalc.py script uses LibreOffice to recalculate all formulas and detect errors. No Microsoft Excel required.
Will editing preserve my existing formulas?
Yes, using openpyxl with load_workbook() preserves all formulas and formatting. Just avoid opening with data_only=True if you need to save formulas.
What formula errors can be detected?
The skill detects all Excel errors: #REF!, #DIV/0!, #VALUE!, #NAME?, #NULL!, #NUM!, and #N/A. It reports error types with exact cell locations.

Discussion

Discussion

0 comments
U

On This Page

Trigger Phrases

Use these phrases to activate this skill in your AI coding assistant:

Create Excel fileEdit spreadsheetAnalyze Excel dataBuild financial modelRecalculate formulasFix Excel errorsConvert CSV to ExcelAdd formulas to Excel