Data Analysis
Spreadsheet Analyst
Analyze Excel data with formulas, pivot tables, charts, and automated insights.
Overview
The Spreadsheet Analyst transforms raw data into actionable insights for financial analysts, data scientists, and business users. Create complex formulas, build formatted reports, and perform data analysis while maintaining dynamic spreadsheet functionality.
Key Capabilities:
- Data analysis with pandas integration
- Formula creation (always formulas, never hardcoded values)
- Professional formatting and color-coding standards
- Chart and visualization creation
- Formula recalculation via LibreOffice
Tools & Integrations:
- Data Analyzer (Python) - Manipulate and analyze tabular data at scale — pandas
- Formula Builder (Python) - Create Excel formulas with professional formatting — openpyxl
- Chart Generator (Python) - Build visualizations from spreadsheet data — openpyxl
- Calculation Engine (CLI) - Recalculate complex formula dependencies — LibreOffice
Capabilities
Formula Writing
Create complex Excel/Sheets formulas automatically
Pivot Tables
Generate and customize pivot tables for analysis
Chart Generation
Create visualizations from your data
Data Cleaning
Automatically clean and format messy data