/excel-work

Excel Skill

Financial models and spreadsheets with zero formula errors

B2B TierUtility & Infrastructure

Overview

Creates, edits, and analyzes Excel files using openpyxl with industry-standard financial modeling conventions. Blue text for inputs, black for formulas, named ranges, scenario toggles. Every deliverable is validated for zero Excel errors.

What It Does

  • Builds multi-sheet financial models (pipeline, ARR waterfall, sales capacity, P&L)
  • Applies industry-standard color coding and number formatting
  • Constructs formulas with cell references and named ranges instead of hardcoded calculations
  • Validates all formulas for errors (#REF!, #DIV/0!, etc.) before delivery

Inputs

  • Model requirements
  • Assumptions
  • Data sources
  • Existing Excel files

Outputs

  • .xlsx files with formulas, formatting, named ranges, and multi-sheet structure

Example

/excel-work

Need a board-ready annual planning model. The skill builds an ASSUMPTIONS tab with blue-text inputs, a PIPELINE_MODEL with conversion funnels, an ARR_WATERFALL with corkscrew logic, and a SCENARIOS tab with Base/Target/Downside toggle.

Related Skills

/finance

Finance Suite

Budgets, portfolio, stock research, brokerage sync

Deep Dives

Claude Code for GTM

Ready to use /excel-work?

This skill ships with every Knowledge OS installation. Set up your system in 90 minutes.

View PricingAll 42 Skills

Built and maintained by Victor Sowers at STEEPWORKS