Still Before You Begin...

Try it: Open the Sample Spreadsheet

Open the spreadsheet you downloaded:

Legs Eggs Pigs 2010.xlsx
Go to the Legs spreadsheet.

 

The Developer Ribbon is shown In the example on this page.

 

What Do You See? The fields in the Header Row are Date, Product, Net, Quantity and Revenue. The Columns are formatted for number: Column A is formatted for Date, Column C is formatted for currency.

 

What Else Do You See? The dates in Column A are a series. This series shows the workdays and skips the weekends.

 

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