summarize data using pivot tables in Excel using the data file Sales_Transactions.xlsx.

This assignment is intended to test your knowledge of how to summarize data using pivot tables in Excel using the data file Sales_Transactions.xlsx.

The data file contains individual customer item purchase transactions with the following columns:

Cust ID – Unique ID for each customer
Region – Region of the country where the sale was made
Payment – Method of payment
Transaction Code – Unique transaction code
Source – How purchase was made
Amount – Amount of purchase
Product – Product purchased
Time of Day – Time of purchase
After watching the video How to Create Pivot Tables in Excel(Links to an external site.), create the following 4 pivot tables:

Amount of Purchase by Region
Amount of Purchase by Source
Amount of Purchase by Product
Amount of Purchase by Payment (row) and Region (column)
Submit a single workbook showing the 4 fully functional pivot tables.