Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Another place that we can search for data for an Excel spreadsheet is on the web. Whether or not the web page we're viewing is organized in a table, that information can be imported into Excel and used within our spreadsheet. It won't come in necessarily in HTML format with all the graphics in place, but we can use the raw data. Let's go up to the Data menu and Import External Data. We have a New Web Query. This is one of the most powerful ways to import information from the web. Let's go ahead and click New Web Query and I've got an address already in memory, so I'll click to go on that, and we're taken to the Microsoft website, where we can see some preliminary information on Excel 2003. All of these yellow boxes with the arrows define segments or tables within the spreadsheet that we can choose to import. If I import this table for example, I'm going to get this information that's contained within this area of the spreadsheet. If I choose this higher level box I'm going to get this entire table worth of information. Again I'm not going to get any graphics imported into my spreadsheet, but all of the data that I see here will be moved over. So let's go ahead and click Import. Where do I want to import it? A1 is fine, and after a few moments of retrieving the data we can see that all of those pieces are in play. I'm going to close the Task pane, and I can scroll over the lists of data, and the raw information that was there about Microsoft Excel 2003 have been imported. This is possibly the most organized way to move data from the Web into a spreadsheet.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91397 Viewers
80 Video lessons · 138268 Viewers
59 Video lessons · 57101 Viewers
52 Video lessons · 70758 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.