Step 3: Sort and Create Summary Report and Chart

1. To create the Sorted Data worksheet, begin by creating a copy of the Condo Sales Data. Once a copy has been made of the Condo Sales Data and moved to a new sheet, name the new worksheet Sorted Data. We will not need the Address column, so please delete that column of data from the Sorted Data worksheet.
2. Convert the data in the Sorted Data worksheet into a table. Select the rectangular block of cells contained in the Sorted Data worksheet. Click the Insert tab and select Tables from the Tables group. Remember to check that your table has headers.
3. Sort the data by selling agent and then by asking price. Once the data has been sorted, you can convert it back into a range. You must convert to range before you can provide a summary report.
4. Create a summary report showing total asking and total selling price by agent. Using subtotals, you will select the criteria for your subtotal. Each time the agent name changes, you want the total (sum) of both the Asking Price and Selling Price. Make sure the outline level of your subtotal is set to two on the left top area of your screen. Make sure you format your worksheet professionally.

5. Create a Column Chart to compare asking price versus selling price by agent. Make certain you provide a professional chart title and formatting for your chart. Include a legend to show what each color represents. Move this chart to a new worksheet and name it Ask vs. Sell Price Chart.

The Condos at Summit Ridge Mountain Customer Type of Unit City % of Asking Listing Date Sale Date Selling Agent Asking Price Selling Price Gonzales Total $ 2,004,500.00 $ 1,821,685.00 Goodrich Total $ 395,000.00 $ 382,450.00 Haley Total $ 573,600.00 $ 556,169.00 Kloster Total $ 571,500.00 $ 554,900.00 Langston Total $ 2,294,900.00 $ 2,189,409.00 Minkus Total $ 1,113,900.00 $ 1,077,931.00 Pinkston Total $ 921,000.00 892,100.00 Pinter Total $ 639,900.00 $ 564,804.00 Singleton Total $ 741,400.00 $ 704,005.00 Grand Total $ 9,255,700.00 $8,743,453.00 Asking Price vs Selling Price by Selling Agent $2,500,000.00 $2,000,000.00 $1,500,000.00 Asking Price Selling Price $1,000,000.00 $500,000.00 0 Gonzales Total Goodrich Haley Total Kloster Total Minkus Total Pinter Total Langston Total Total Pinkston Total Singleton Total