Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Sometimes you need to analyze large amounts of data from other sources in Excel. The easy part is doing the analysis, the hard part is getting the information into Excel. Luckily, 2007 has made that part much easier. Using import commands, you can populate worksheets with lots of data from other sources. We're going to take a look at some ways that you can do that in this chapter. Open up a new worksheet to follow along. Click on the Data tab to find the commands that allow you to get external data. In this movie, we're going to see how we can import from an Access database.
Simply click on the From Access command, and find your access database. Now this may take a little bit of looking, but what we're going to look for is the Exercise Files, that came with the application, and we're going to look for the Importing_Exporting_Data file folder. Once you've opened that, you'll see the EatCake database. Highlight it, and click open. You then get a dialog box asking you which table of data you would like to select and import.
We're going to choose the address list, and click OK. Next you're asked how you would like to import the information, how would you like to view it when it's in your workbook. You have three choices; Table, PivotTable Report, PivotChart and PivotTable Report. We're going to keep it simple, and do just a table. Next we have to tell Excel where to put the information, and it's going to default to the cell that I had already selected when I opened up the Import command, cell A1.
You also have the ability to place it in a different cell, by clicking on the pop-up box and selecting the cell where you'd the information to go. Or, you can put it into a brand new worksheet. This is a good option if you already have information in the worksheet that you're working in and you don't want to overwrite it. I'm just going to remove this indicator here, and go back and identify that I want the information in cell A1. I click OK, and the information is imported very quickly. It's also imported as a table and you can use all the regular table tool commands that we've learned about previously to manage this data.
That's a much better approach than typing all this information in, line by line.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74614 Viewers
80 Video lessons · 129787 Viewers
52 Video lessons · 64002 Viewers
59 Video lessons · 49780 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.