how to summarize data using pivot tables in Excel using the data file

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.