Viewers: in countries Watching now:
Excel 2003 Essential Training with Mark Swift is a movie-based workshop for users who are new to working with spreadsheets, or those wanting to improve their skills. This workshop begins with a basic overview of the application and quickly advances to cover useful formulas, functions, techniques for enhancing spreadsheets, charts, and much more. Exercise files accompany the training, allowing you to follow along and learn at your own pace.
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.
There are currently no FAQs about Excel 2003 Essential Training.
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.