Ch.15--"Importing and Exporting"

In chapter 15 of advanced Excel it talks about how to import and export data from Microsoft Excel. If you want to import something from another program you go into Excel click the Open button and from files of type select what kind of file you wish to import. If you are importing from Word then you would select Text files. That is most likely the kind of import I will use. Then the text import wizard appears and you fill in the options you wish to have, just like any other wizard. Another way to import you go to data menu then import external data then new database query. All you do is select the type of file you wish and then select the database. To export Microsoft Excel information you can simply copy and paste it or you can save it as a Text (Tab delimited) format and then open it in Word.

The first project wants you to import a text file into Excel. I went to open and chose text (tab delimited) in order to see where it is on the drive. Then I just followed the wizard and changed things in the data like the column widths and format. I changed the column widths to see all the data at once and I changed the format to make it more appealing. The activity was to import a text file into Excel. I did the same process as what I used for the first project. To know more about the data I calculated the totals from each month.


The second project wants you to export a file from Excel and to put it into Microsoft Word. I did it the simple way by just copying the data while it was in Excel and just copied it into Microsoft Word. I applied an autoformat to the table so it also looks more appealing. The column widths were fine and I didn’t need to change them.