Use pivot tables in Excel for stronger data analysis. This Excel pivot table tutorial also helps you summarize data.
Use the Company Sales workbook to complete this challenge.
- Create a PivotTable report that calculates the amount each salesperson sold.
- Filter the report by region.
- View the data for the salespeople in the North and West region.
- Who sold the greatest dollar amount in these two regions?