Subtitles of the Movie

Excel 2007 offers many file formats for exporting data to be used in other applications. You do this by saving the file in a different file format. So if you come up to your Office button and select that, and then pull down to Save As and simply choose the Save As menu option without choosing any of the sub-menus, this will open up the Save As dialog box and notice you can come down here to your Save As type and when you select this you get a whole list of file formats that you can save your workbooks in. The some of the more popular ones are the Tab Delimited or text file format, as well as comma delimited, which is the dot csv format. You can also save it as xml data or as the data interchange format, or dif format which are all very popular and allow you to then pull your data into many other types of applications and you do that all through the Save As dialog box. I'm going to cancel out of here. Now let's open up your Product List which we were working on in the previous movie, or you can open up 0912 Start file which you'll find in the Excel 2007 course directory in the Chapter 9 folder. Notice that we have 1 column here that we need to complete and then we can go ahead and export this data in tab delimited, or text, format. Let's go ahead and calculate what our current inventory is. So what we're going to do is choose our starting inventory here and subtract Week 1, Week 2, Week 3, and Week 4 from that. So set your cursor in H4 and then start this off as a formula by typing in an equal sign and then select cell C4 for our starting inventory for our first row of data. Then let's go ahead and subtract the sum, and go ahead and type in sum parenthesis, and then set your range here to go from Week 1 to Week 4 in row 4, so you click at D4 and drag all the way across to G4, and then type in your closing parenthesis for your sum, and enter that. And notice immediately Excel calculates what all of your remaining product number, or quantities are, by subtracting the range of Week 1 through Week 4 from our starting inventory. Well, now we have our product list complete, let's export it in tab delimited format. So come up here to your Office button, select that. Pull down to Save As and select that. In the Save As dialog box come down to the Save As Type drop-down menu, select that, and go ahead and choose the tab delimited format, or dot txt. When you select that notice that down here your file name has changed to have the dot txt file extension. Go ahead and make sure you're saving in your Chapter 9 folder in your Excel 2007 course directory and choose Save. This will convert this into text format, but due to the fact that we have multiple worksheets in this workbook, Excel is now asking you if it's OK to save only the active sheet, because the dot txt format, or tab delimited format doesn't support multiple workbooks. Well, this is exactly what we want. Go ahead and click OK and then you'll get another message saying that, by saving this in text format we are going to lose some of the features that are present in our workbook, which is fine. We're looking to just export our data, not worrying about having all the formatting or the table feature, or any of those other features, that we've applied to our workbook or in our worksheet here. So go ahead and just say OK, and Excel will save that in tab delimited format in your Chapter 9 Directory. Go ahead and check it out by exploring or navigating to that directory and taking a look at what is there in the text format. This has been quite a full chapter of working with the various data management handling tools. We've covered quite a bit on tables, as well as how to use tables to manage your data, to validating data, to exporting our data, and we looked at also how to link worksheets and workbooks together through Links and External References. You are now equipped with quite a few Excel skills to move on in your Excel and Workbook and Worksheet development. Let's move on to the next Chapter.