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.

File->Open