What problem does it solve?
This Skill eliminates the tedious, error-prone manual work of creating, editing, and analyzing spreadsheets, ensuring formulas function correctly and formatting adheres to industry standards for professional deliverables.
Core Features & Use Cases
- Spreadsheet Creation & Editing: Build new .xlsx/.xlsm files or modify existing spreadsheets while preserving existing formulas and formatting, with support for industry-standard financial model color coding and number formatting rules.
- Data Analysis & Visualization: Use pandas to read, analyze, and export spreadsheet data, plus generate visualizations directly from spreadsheet datasets for quick insights.
- Formula Error Prevention: Automatically recalculate all Excel formulas using LibreOffice, scan for errors like #REF! or #DIV/0!, and provide detailed error reports to ensure zero-error deliverables.
Use Case: If you have a CSV of quarterly sales data, you can use this Skill to build a formatted financial projection model with linked growth rate formulas, then recalculate it to confirm all values are accurate.
Quick Start
Use the xlsx skill to create a formatted sales forecast spreadsheet with linked growth rate formulas from the provided quarterly sales data, and recalculate it to confirm there are no formula errors.