Today, in the absence of so many people because of the blood drive and Track, we did a little more work in Excel.
First off, we built a sales force spreadsheet. One sheet had three divisions of sales with a quota and a commission.
Divisions were Small, Key and Major
Quotas were $10,000, $100,000, and $1,000,000 respectively
Commissions were 5%, 7%, and 8% respectively.
Then we built a sheet of data with the following columns
Name, division, sales this month (made up numbers), quota, commission rate, sales abovequota, and commission earned. We used an if statement to make sure that last one did not come out below zero (for those that did not meet their quota yet this month).
Then we started looking at print in Excel.
First thing to do is highlight the area you want to print, then go to File Menu, Print Area, and select ‘set print area’.
That gets you started. In page setup, you can select what rows and columns to repeat, what orientation to have the page, and you can manage margins, headers, and footers.