Before You Begin
This
lesson uses a sample spreadsheet which is available online. You can
create your own spreadsheet if you wish. When you are ready, please
start Microsoft Excel.
1. Try This: Open a Sample Spreadsheet
Open a sample spreadsheet:
Customer Sales 2010 PivotChart.xlsx
Go to the Monthly Sales sheet.
What Do You See? This sheet shows the product sales for
Charlotte' Website. The first row is BOLD: It is the Header Row.
There are many rows of data. The example on this page has been
sorted by Column C, Category.
Please
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.