xlsx
Create, edit, and analyze Excel spreadsheets with formulas, formatting, and data validation.
- Supports reading, creating, and modifying .xlsx, .xlsm, .csv, and .tsv files with full formula preservation and recalculation
- Includes financial modeling standards: color-coded text (blue for inputs, black for formulas, green for internal links, red for external links), currency formatting, and assumption-based formula construction
- Provides data analysis capabilities via pandas for statistics, visualization, and bulk operations
- Automatically recalculates all formulas and scans for errors (#REF!, #DIV/0!, #VALUE!, #N/A, #NAME?) using LibreOffice integration
- Enforces zero formula errors and dynamic spreadsheets using cell references instead of hardcoded values
Requirements for Outputs
All Excel files
Zero Formula Errors
- Every Excel model MUST be delivered with ZERO formula errors (#REF!, #DIV/0!, #VALUE!, #N/A, #NAME?)
Preserve Existing Templates (when updating templates)
- Study and EXACTLY match existing format, style, and conventions when modifying files
- Never impose standardized formatting on files with established patterns
- Existing template conventions ALWAYS override these guidelines
Financial models
Color Coding Standards
Unless otherwise stated by the user or existing template
More from tfriedel/claude-office-skills
docx
Comprehensive document creation, editing, and analysis with support for tracked changes, comments, formatting preservation, and text extraction. When Claude needs to work with professional documents (.docx files) for: (1) Creating new documents, (2) Modifying or editing content, (3) Working with tracked changes, (4) Adding comments, or any other document tasks
1.3Kpptx
Presentation creation, editing, and analysis. When Claude needs to work with presentations (.pptx files) for: (1) Creating new presentations, (2) Modifying or editing content, (3) Working with layouts, (4) Adding comments or speaker notes, or any other presentation tasks
1.2Kpdf
Comprehensive PDF manipulation toolkit for extracting text and tables, creating new PDFs, merging/splitting documents, and handling forms. When Claude needs to fill in a PDF form or programmatically process, generate, or analyze PDF documents at scale.
416