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 2010,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 2010.
|
|
| |
