graphic2
graphic1

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 2013 PivotChart.xlsx.
Go to the Original Data sheet.

What Do You See? This sheet shows the product sales for Charlotte's 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 D, Service.

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

 

pic1