Since I was intent on summarizing and understanding the data from the Excel sheet, I focused on the Formulas page of the platform where your data can be input, then generated or explained.

Pivot tables in Google Sheets summarize smaller sets of data from a more extensive table ... the most out of the pivot table you've created using other facets of the feature in Google Sheets.