Pivot Tables

Table of Contents Example We have Region, Product and Year wise sales in a excel sheet. Now, we need to create multiple excel sheets containing year wise and region wise sales for each product. Steps Create a pivot table: Select the data range, Go to Insert Tab –> Pivot Table –> OkKeep Region in Rows, Year in…