Before You Begin This discussion begins by creating a sample spreadsheet that shows sales data for four reps.   1. Try it: Open a Sample Spreadsheet Open the spreadsheet you created in the previous lesson: Sales 2013.xlsx Go to the Sales Subtotal by Rep spreadsheet.   What Do You See? The spreadsheet Subtotals the amount for each Sales Rep.   Keep going, please... Memo to Self: You can use the sample spreadsheet  or enter your own data on the next page if you wish.   Another Memo: We will learn how to summarize data with Subtotals and PivotTable reports in the Advanced Guide to Excel 2013.