File -> Open A Different Subtotal The Intermediate Guide to Microsoft Excel 2010 demonstrated a series of formulas that calculated and formatted the sales subtotals.   This lesson demonstrates how the sales subtotals were created. 1. Try This: Open a Sample Spreadsheet Open a sample spreadsheet: Customer Sales 2010.xlsx Go to the sheet called: Monthly Sales. What Do You See? This is the Monthly Sales for Charlotte's Website. The first row is BOLD: it is the Header Row. There are many rows of data including the Category, Service, Product, Date, Sales Rep and Amount. Keep going... Memo to Self: You do not have to MATCH the numbers shown on these pages. It is more important that you begin with some data and understand the options.