📊 Excel & Spreadsheets Prompts

Guide me step by step to create a pivot table in Excel for sales analysis. My data has columns: Date, Product, Region, Salesperson, Quantity, Revenue. Show me how to: 1) Create the pivot table, 2) Set up rows as Product, columns as Region, values as Sum of Revenue, 3) Add a filter for Date (by month), 4) Sort by revenue highest to lowest, 5) Add calculated field for average revenue per unit, 6) Create a pivot chart from the results.

Create a pivot table setup for employee performance analysis. Data columns: Employee Name, Department, Quarter, KPI Score, Projects Completed, Client Satisfaction Rating. Show how to: 1) Average KPI score by department, 2) Count projects completed per employee per quarter, 3) Show top 10 performers using value filters, 4) Add slicers for Department and Quarter for interactive filtering, 5) Create a dashboard layout with multiple pivot charts.