How do you create a PivotTable in Excel? Preparing data, Rows and Values areas, Sum/Count, showing percentages and Refresh — based on Microsoft's guide.
