Excel Data Analysis using PivtoTable

This Excel file contains a table of data about the sales of different products by various companies.

The data includes the following categories: Company name, Customer ID, Product name, Unit price, Quantity, Extended price, Discount, Order date, and Ship date.

To analyze this data and find patterns, trends, and relationships, the file uses a PivotTable.

A PivotTable is a tool that summarizes, groups, and filters the data in a table format.

The PivotTable shows the total extended price for each product and company, as well as the average unit price and quantity. The PivotTable also allows you to change the layout, format, and style of the data, and to use slicers, timelines, or charts to add interactivity and visualization.