File -> Open Before You Begin The purpose of this lesson is to investigate the PivotTable Options in Microsoft Excel. You can use a spreadsheet that you created or download a sample spreadsheet if you wish. The sample, Customer Sales 2013.xlsx, has two spreadsheet Tabs: Monthly Sales and Customer List. 1. Try This: Open a Sample Spreadsheet Open a sample spreadsheet: Customer Sales 2013.xlsx Go to the Monthly Sales sheet. What Do You See? This sheet shows the product sales for Charlotte's Website. The first row is BOLD: It is the Header Row. The data should be sorted by Column A, Month. If not, go ahead and sort the data, first. So far, so good. 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.