I just wanted to show you a quick example of how we might use Excel to create a sales invoice and then how you can print it as a PDF file. The PDF file then you could email to somebody. We're going to be creating this invoice, this is actually a PDF file that I made directly from Excel, and it's a simple invoice, very professional looking that you could send to somebody. This was all made in Excel. I've got this file called invoice, and it's just a hypothetical invoice here for a cookie company. We've got some date information up here. You might put in a invoice number, we have the billing address, and we've got a description of the cookies that the purchaser has decided to buy with the quantity. At the bottom we have the total, we have some information here, contact information, and I've got in column D, at the very bottom I have a total which is just the sum of all of these subtotals for the various items. The first thing we want to do is we want to fill out this amount, over here on the right I have a reference table here for the prices. You could easily just go in here and manually type in equals 4 because we have the quantity there or you can reference that cell times sneaky doodle which is four dollars, so you could do that, and it would be 16. But let me show you just a quick way you could set up your worksheet to do this automatically to save you some time in the long run. The first thing I'm going to do is I'm going to add in data validation for these cookies here, actually for all these cells. So I'm going to drag this down, I'm going to go up here to the Data tab, Data validation, and this is going to be a list. The allowable data here is going to be over here in column K, so I'm just going to select those three, and I'll click Okay. What that does is it only allows the user to select the cookies. So they couldn't put in something that your company does not sell. The next thing we're going to do is we're going to make an automatic lookup here for the amount. I'm going to go over here to the reference table and I'm going to name this up here on the left, it's just going to be called cookies. So we've got that named cookies, and I'm going to put in a formula here. I'm going to first take the quantity whatever cell is to the next of it. I'm going to multiply that by and we're going to use the VLOOKUP function. I'm going to be looking up the cookie over here in our cookies table, which we've already named, is looking through the leftmost column of that cookies table, and then we're going to put a two because we want to output the price and I will put a false. It doesn't matter in this case if we have true or false because since we did the data validation, we're only going to allow those three in that cell. So really we don't need false, we could also leave that as true. When I press Enter, it's going to automatically look up the cookie type over here on the description from our cookies referenced table over here to get a price, and then it's multiplying by the quantity, and we can easily drop this down to calculate the price. If you updated the quantity, maybe change this back to five, it automatically recalculates here. So the next time you create an invoice, you can just come over here to the drop-down menus and you can select whatever cookies have been ordered, the quantity, everything automatically updates the subtotals for each item and the total at the bottom. We've created our invoice now in Excel. Let me show you how we can print this. We can select this entire region. I can go up here to File, Print, and we've got our Microsoft Print to PDF, you could also use Adobe to PDF, there's a version that Adobe offers, and I'm going to print my selection, so make sure print selection is checked there, and you can go ahead and press Print to print this and output it as a PDF file that you can then send to somebody. So hopefully this screen cast gives you a better idea of how you can use Excel, not just for the typical uses of Excel like working with data, doing complicated calculations, but you can also create simple, professional looking invoices like this as PDF files.