Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
And last but not least how do you convert a traditional list into a designated list? Or you can use the same technique to simply create a designated list from a group of data. This enhanced feature of Microsoft Excel 2003 makes it easier to visualize your list and it provides you a lot of options right up front without having to turn on various features of your list. Let's start by selecting the range of cells that contain your list. Going up to the Data menu, and you may need to expand your menu in order to see the list functionality, and here under the List menu we have Create List. Let's go ahead and select that or you can see you can use Control+ L, and it verifies the range of my list and again we have a choice of adding headers or not. Because I have titles I do want headers. I'll say OK, and you can see all of the various functions that we have inside of our list. We have the AutoFilter drop downs available to us. If I just deselect that range you'll see a border that's been applied. Now the blue indicates a border that is currently not active. If I click anywhere inside of my list, that border thickens up again drawing our eye to the fact that this is a list of information and you'll also notice that when we use the Form feature, the Form feature allowed us to enter data in a very structured way, and it placed the new record at the bottom of our list. Well when you create a designated list you'll see we have an empty row automatically inserted at the end with an asterisk indicating to us that we're going to enter new data here. If I click inside of that row I can begin entering another record, let's say Big Fish, and this is primarily a Drama, Fantasy element, and Comedy, 2003.
When I hit Enter, it goes back to the beginning of the next new row and allows me to enter data again. So instead opening up the Form dialog box, we can go ahead and enter right into our list in still a very structured way. Designated lists is a good addition to the list functionality within Excel, and overall lists are extremely useful, again inside or outside of the office.
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.