Before You Begin
This
discussion begins by creating a sample spreadsheet that
analyzes 9 months of data-technically the first 3 quarters of sales.
1. Try This: Open a Sample Spreadsheet
Open a sample spreadsheet: Sales2010.xlsx
Go to the Sales Subtotal by Month sheet.
What Do You See? This sheet shows the product sales for
Charlotte' Website. There are two Columns showing: Month and Amount.
(The other Columns are hidden.) There is an Outline on the left side
next to the names of the Months.
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.
Another Memo: We will learn
how to summarize data with Subtotals and PivotTable reports in the
Advanced Guide to Excel 2010.
