br A Pivot Table in Excel is one of the most powerful tools available for analysis of large sets of data.