Sean is about to face his biggest challenge yet. He has been given the Shipping Data which is a large set of data downloaded from the company database containing more than a thousand records. His boss has asked him to complete all the calculations. Let's see if we can help him do this. The first thing we need to do is see the rest of the data. So we're going to come down to the bottom of the spreadsheet, click on our horizontal scroll bar and scroll to the right. And where we see the blank columns, that is where we have to complete the calculations. The first calculation Sean has to do is Profit Margin. Profit Margin is calculated by subtracting Cost Price from Retail Price to work out our Profit. So this is going to be a simple subtraction. Click in Q4 and start with your equals. Click onto Retail Price, type minus, click Cost Price and press Enter. Nice and easy. Let's do it one more time, so equals, click Retail Price, minus Cost Price and Enter. Now we still have more than a thousand records to go, so we're going to be here a while. Or are we? Remember the Fill Handle that we learned about in week one? Well, the great news is we can use that for calculations as well. So, click back on to Q5, which is the last calculation you did, come to the Fill Handle, that little green box at the bottom right-hand corner, and double-click. How easy was that? All right, next calculation is our Sub Total. The Sub Total is how much the customer is going to pay before Discount and Shipping. So we're going to need to take the Retail Price and multiply it by the Order Quantity. Again, start with your equals, click Retail Price and now we need to multiply, so remember that's our asterisk, click on Order Quantity and press Enter. And once again, we can copy that down. So back on to S4 and double-click your fill handle. Now we need to work on our Discount. Discount is worked out as a percentage of the Sub Total. Percentages can make people a little nervous though. The good news is in Excel, they are really easy. All you need to do is take the percentage amount and multiply it by the value you want to get a percentage of. Remember that six percent is not the same as six. It's the same as six divided by 100 or if you prefer, 0.06. So let's see how this works. We're going to start with our equals, click our Sub Total, click our asterisks to multiply, click on our six percent and we're expecting an answer of roughly five dollars. Click Enter and there we go. Let's copy that down. So back onto U4 and double-click your fill handle. Finally, we need to calculate our Order Total. This means taking our Sub Total, subtracting the Discount, and adding in the Shipping. So this is a slightly more complex formula, but only slightly. Start with your equals, click on your Sub Total, type your minus, click on your Discount amount, type your plus and click on your Shipping Cost. Now click Enter. There's our Order Total and again we can copy that down. So, in under five minutes, we have easily helped Sean complete his shipping spreadsheet. Why don't you give it a try on your own?