What it does
A skill for creating, editing and analysing spreadsheets. It uses openpyxl for formulas and formatting and pandas for bulk data, and it expects live formulas rather than hardcoded results, with no formula errors in the final file.
Use cases
- 01Build a budget sheet with working formulas
- 02Clean and reshape exported data into a workbook
- 03Read an existing model to review its formulas