Pivot Tables – one of the most powerful features of Excel – allow large amounts of data to be summarized…