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.
As we begin talking about modifying your worksheets, it's important to know how to open existing files. Now you've already seen me do it a few times if you've been watching the earlier lessons, but let's do it formally. To open an existing file that's on your local drive or on the CD-ROM or network resource, you can use the Open command found here in the Standard toolbar, File > Open down here in the File menu, you'll also notice that the most recent documents appear here in the File menu, as well, more conveniently, they appear here in the Task pane. As part of the office developments team's efforts to give you more flexibility and a faster working environment, here in the Task pane by default, not only can you access help right away, but you can also access any of the recently opened files, right here. I believe if you click the More feature, then it takes you to the Open command, just as if you'd gone up to the Standard toolbar or the File > Open menu. So to start with, let's browse over to the place where you've stored your Student Files, and we'll go to Section 3, Modifying Worksheets, and you'll see we have Quarterly_Sales, and here again I want to warn you, although I'm opening Quarterly_Sales again, the Quarterly_Sales document is going to change and grow as you work through the various lessons in this series on Microsoft Excel. When you're being asked to open a file please don't simply open the last version of the file, or else you're not going to find necessarily the components that you want to work with for the next chapter, unless of course you've been working along with each lesson like a good student and you've got your own version of that file saved separately. So here I am in the section 3, and Quarterly_Sales, I'm going to open that up, and as you can see this document is the same right now, but as I said, it's going to change and grow as we go.
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.