Before You Begin

The purpose of this lesson is to investigate the Data Options in Microsoft Excel 2010. You can use a spreadsheet that you created or download a sample spreadsheet if you wish.

1. Try This: Open a Sample Spreadsheet
Open a sample spreadsheet:

Customer Sales 2010.xlsx
Go to the sheet called: Customer List.

2. What Do You See? This is the Customer List for Charlotte's Website. The first row is BOLD: it is the Header Row. There are many rows of data including Name, Address, Phone. This data came from a database, so Column A includes the unique CustomerID number.

 

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