Lab 2.06A - Report 01 - Commissions

  • The sales manager has asked you to recreate a sales commission report.  There are 4 sales teams set up in the company.  Each team is responsible for sales in one of 4 "Sales Regions".  The sales regions are: Southeast, Northeast, Midwest and West.  

    You will need to enter the total commissions for each region over the first three months of the year.  Then you will need to calculate totals by region and by month.  The manager also likes to have spark lines for each region.

    Add a new worksheet to your excel workbook and name it Lab 2.06A

    Click on the example below to see how the report should look when you are finished.