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.