excel

Build and verify Excel financial models with openpyxl and pandas.

124|12|Updated Nov 17, 2025
One-click install
npx skills add https://github.com/IgorWarzocha/Opencode-Workflows --skill excel-igorwarzocha
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: excel
Source: https://github.com/IgorWarzocha/Opencode-Workflows/tree/main/cowork/.opencode/skill/excel
Command: npx skills add https://github.com/IgorWarzocha/Opencode-Workflows --skill excel-igorwarzocha

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates complex spreadsheet operations, ensuring accuracy in financial modeling, data analysis, and professional report generation, eliminating manual errors and saving significant time.

Core Features & Use Cases

  • High-Fidelity Modeling: Build and verify complex financial models (e.g., LBO models) with banking-standard formatting and zero formula errors.
  • Data Analysis & Visualization: Analyze datasets using Pandas and Openpyxl, creating professional dashboards and verifying data integrity.
  • Formula Verification: Automatically audit spreadsheets for formula errors (#REF!, #DIV/0!, etc.) using a dedicated script.
  • Use Case: Generate a detailed LBO model for a potential acquisition, ensuring all formulas are correct, formatting adheres to industry standards, and assumptions are clearly separated.

Quick Start

Use the excel skill to build an LBO model with banking-standard formatting.

Frequently Asked Questions about excel

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build an LBO model in Excel with banking-standard formatting?

You can build an LBO model with banking-standard formatting by using this Skill to automate complex financial modeling operations. It leverages openpyxl and pandas to ensure zero formula errors, strict professional formatting, and clear separation of model assumptions.

Can I automatically audit Excel spreadsheets for formula errors like #REF! and #DIV/0!?

Yes, you can automatically audit Excel spreadsheets for formula errors like #REF! and #DIV/0! using the dedicated formula verification script. This mechanism scans your workbook to ensure zero formula errors and maintains data integrity across complex datasets.

How do I create professional data analysis dashboards in Excel using Python?

Creating professional data analysis dashboards in Excel is achieved by processing datasets with pandas and openpyxl. This Skill handles the data analysis and visualization logic, generating professional dashboards while simultaneously verifying the integrity of your underlying data.

Does this financial modeling tool work with Python libraries like pandas and openpyxl?

Yes, this financial modeling tool works directly with Python libraries like pandas and openpyxl. It relies on these dependencies to handle spreadsheet operations, execute complex data analysis, and enforce professional formatting standards without manual intervention.

What is the best way to ensure zero formula errors in complex financial spreadsheets?

The best way to ensure zero formula errors in complex financial spreadsheets is to apply automated formula verification. This Skill uses a dedicated script to audit for errors like #REF! and #DIV/0!, guaranteeing calculation accuracy and professional report generation.