Before you Begin
This
example uses the same spreadsheet that was created in the previous
lesson. You can continue with the one you saved or download a new
sample if you wish.
Try
This:
Open a Sample Spreadsheet
Open a sample spreadsheet:
Using Named
Ranges.xlsx
Go to the Original Data sheet.
What Do
You See? This sheet shows the net product sales for three
products: Legs, Eggs, and Pigs. The data includes:
Date
(Number, formatted as Medium Date)
Product (Text)
Net (Number, formatted as Accounting)
Quantity (Number)
Revenue (Number, formatted as Accounting)
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.