What problem does it solve? Building professional Excel deliverables programmatically is error-prone: formulas get hardcoded as dead values, formatting is inconsistent, pivot tables are impossible with openpyxl alone, and formula errors like #REF! slip through undetected. This Skill provides a complete workflow for producing polished, recalculated .xlsx files with zero formula errors. ## Core Features & Use Cases - Live Formula Generation: Writes real Excel formulas (never Python-computed constants) so spreadsheets recalculate when inputs change, with enforced number formatting and layout conventions. - Pivot Tables & Recalculation: Ships scripts that drive LibreOffice headless to create genuine interactive pivot tables and recalculate all formulas while scanning every cell for errors. - Financial Modeling Standards: Reference guides cover industry color coding, number formats, data validation dropdowns, conditional formatting, charts, print setup, and sheet protection. - Use Case: Ask for a quarterly revenue report with a summary dashboard, a sortable data table, a pivot table by region, and YoY growth formulas — the output is a formatted workbook whose totals update automatically when you edit the source data. ## Quick Start Create an Excel workbook named sales-report.xlsx with a summary sheet, a formatted data table, live total formulas, and a pivot table summarizing revenue by region.
