What problem does it solve?
This Skill streamlines the creation, editing, analysis, and visualization of spreadsheet files, automating complex data manipulation and formatting tasks.
Core Features & Use Cases
- Workbook Creation & Editing: Build new
.xlsx files with formulas, formatting, and charts, or modify existing ones without breaking structure.
- Data Analysis: Perform filtering, aggregation, pivoting, and metric computation on tabular data using
pandas.
- Visualization: Generate charts and tables directly within Excel files.
- Use Case: Automatically generate a monthly sales report from raw data, including calculations for growth, visualizations of trends, and proper financial formatting.
Quick Start
Create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and populate it with the provided sales data.