https://youtube.com/watch?v=1NaimbSyo0EA pivot table is a quick and easy way to summarize data in Excel. In Excel use the Recommended PivotTables tool, to see how easy it is to get started.…