BP 11122023 129pm - Flipbook - Page 134
6. Once your file is open in Excel, please save the file as a Microsoft Excel workbook
format (either .xls or .xlsx). Saving the file as an Excel workbook will enable the Pivot
Table functions needed to compile your data.
7. The cursor on the Excel sheet should remain in the first row and column 3 cell A1.
8. Next, from the top menu bar in Excel select Insert/Pivot Table.
9. Use the default recommendations for data range and opening the pivot table on a new
worksheet, by choosing OK.
134
