Excel Analysis

What problem does it solve?

Manually analyzing large Excel spreadsheets, creating pivot tables, and generating charts is a repetitive and error-prone process. This Skill automates complex Excel data manipulation and visualization tasks, saving significant time and reducing manual errors.

Core Features & Use Cases

• Comprehensive Data Analysis: Perform grouping, filtering, aggregation, and metric calculation on tabular data.
• Automated Report Generation: Create pivot tables and generate various charts (bar, pie) directly from your Excel data.
• Data Cleaning & Transformation: Efficiently handle duplicates, missing values, data type conversions, and merge multiple spreadsheets.
• Use Case: If you have monthly sales data spread across multiple Excel sheets, use this skill to automatically combine them, clean the data, generate a pivot table summarizing sales by region and product, and create a bar chart for a quick visual overview.

Quick Start

Analyze the 'sales_data.xlsx' file, create a pivot table showing total sales by region and product, and save it as 'pivot_report.xlsx'.