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.
You may find yourself wanting to add special characters into your document. You can do that quite easily with the Insert Special Characters dialog. For example, let me go into this cell and add a registered trademark symbol after the word Microsoft. I can go Insert > Symbol, and from the list of special characters, choose the registered trademark, here it is, and click Insert, or I could click and drag that into place. If you change your font set you're going to change the characters that are available, and while we're on this page, let me close this dialog, this text has been imported earlier. You may remember we imported it from the web, from the Microsoft web site. It's a small segment of text that was brought in from the overview of Microsoft Office, particularly Excel 2003. Now when we imported it from the Microsoft web site, it was nearly perfect. I went ahead and made this mess just so I could show you the next function. Sometimes when you're importing data from various data sources, you'll end up with a less than perfect text layout. As you can see here, there are far too many spaces in this text and it's probably because it came from a very dirty data source. One of the functions that we have at our disposal that is intended to work with text, is the Trim function. You'll say =TRIM, and we'll tell it to look at A2. The result is all of the extra spaces being trimmed out of that statement and now it's a nice complete sentence again.
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.