Your Sales Data worksheet will look something like this . STEP 3 : Sort Data and Create Summary Report and Chart
A . Before analyzing data , it is a good idea to copy the data to a new worksheet so that you have a back-up copy of the original data . Right click on the Sales Data sheet tab and select Move or Copy . Create a copy of the current spreadsheet and move it to the end . Name the sheet Sorted Data .
B . In order to sort the data , you may want to convert them to a data table . Format the data table to look attractive .
C . Sort the data by selling agent ( A to Z ) and then by asking price ( largest to smallest ).
D . Convert the sorted data back into a range , and create a summary report showing the total asking price and total selling price by selling agent .
E . Create a column chart that shows the difference by agent between asking price and selling price .
STEP 4 : Filter the Data
A . Create another copy of the original sales data . Rename the sheet Filtered Data .
B . Convert the range to a table , and then filter to show only those properties sold in Miami by agent Carey .
STEP 5 : Apply Conditional Formatting