Discuss the advantages and disadvantages of using PivotTables in Microsoft Excel. You should include examples of when you would use PivotTables and when you would avoid using them. How can using a PivotTable during data validation replace numerous manual filtering operations? Why should we use the $$Add this data to the Data Model$$ checkbox to count distinct values of our fields in a PivotTable?