excel_data_analysis

What problem does it solve?

Many spreadsheets contain valuable but buried insights that are time-consuming to surface manually; this Skill automates reading sheets, identifying formulas, computing summary statistics, and flagging data quality issues to accelerate analysis and reporting.

Core Features & Use Cases

• Sheet ingestion: Read single or multi-sheet .xlsx and .xls workbooks and report sheet names and shapes.
• Statistical summaries: Produce descriptive statistics for numeric columns and value counts for categorical fields.
• Formula & quality detection: Detect spreadsheet formulas, mixed-type columns, high-missingness columns, and simple outliers.
• Cross-sheet analysis: Identify shared column keys, compare metrics across sheets, and surface relationships for synthesis.
• Use Case: Generate an executive summary from a multi-sheet sales workbook that highlights top KPIs, data issues to address, and recommended charts for presentation.

Quick Start

Analyze the uploaded file 'sales_q1.xlsx' and produce a sheet-by-sheet summary with key numeric statistics, flagged data-quality issues, and suggested charts.