| name | xlsx |
| description | Advanced Excel document creation, editing, and technical data analysis. |
LORE Advanced Excel Skill
Use this skill for generating complex reports that involve budgeting, technical metrics, or financial modeling.
Core Requirements
- Use Formulas: NEVER hardcode values that can be calculated.
- Data Integrity: Use
pandas for large dataset analysis before writing to Excel.
- Formatting: Apply professional formatting (headers, borders, number formats) for all outputs.
Analysis Patterns
- Summary Sheets: Create high-level dashboards at the beginning of the workbook.
- Validation: Include formula testing strategies to ensure zero erroneous calculations.
- Documentation: Comment complex formulas or data sources within the sheet.