Excel: How to Create a Pivot Table

A Pivot Table lets you summarize, count, total, and analyze large amounts of data in seconds — without writing any formulas. Here's how to create one. What you need: - A spreadsheet with data organized in columns with header row labels (e.g. Date, Customer, Product, Amount) - No completely blank rows or columns in your data Step 1: Select your data Click anywhere inside your data range. Excel will auto-detect the full range. Step 2: Insert a Pivot Table Go to Insert tab > PivotTable A dialog box appears — confirm the data range is correct and choose where to put the pivot table (New Worksheet is easiest). Click OK. Step 3: Build your report using the Field List On the right side, you'll see all your column headers listed as "fields." Drag and drop them into four areas: - Rows: Categories you want to group by (e.g. Customer Name, Product, Month) - Columns: A second grouping shown across the top (optional) - Values: What you want to calculate (e.g. Sum of Amount, Count of Orders) - Filters: A dropdown to filter the whole table (e.g. filter by year or region) Example — Sales by Customer: Drag "Customer" to Rows. Drag "Amount" to Values. Done — you instantly see total sales per customer. Changing the calculation type: By default, Values shows "Sum." To change to Count, Average, etc.: Click the field in the Values area > Value Field Settings > choose the calculation you want. Refreshing the pivot table: If you add new data to your source spreadsheet, right-click anywhere in the pivot table and click Refresh. It pulls in all updated data. Sorting and filtering: Click the dropdown arrow next to any Row or Column label to sort or filter values. Tip: Use Recommended PivotTables (Insert > Recommended PivotTables) to let Excel suggest useful summaries based on your data — great starting point if you're unsure how to structure it.