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.
There a few handy search options within Microsoft Excel and the first one we're going to take a look at is the file search. A file search can help you locate a file that's on your local drive or a network resource. If you go up to the File menu and choose File Search, you'll see that your task pane has switched over to a Basic File Search. In the Basic File Search you can locate text within a file or the name of a file and you can select where you want to search, in this case I'm looking in My Documents, and you can specify the product you looking for to eliminate files that you know don't exist in a Word document or an Access database. If these options don't satisfy you, you can always go to the Advanced File Search, where you can include different properties. Instead of just searching for text, you could look for a number of pages or a file size. I'm going to continue searching for text. The conditions of my search right now, because it's text, only includes the text I'm looking for. If it were a numerical value, I can put greater than or less than, and here in the value I'm going to search for a name. Let's add that to our search, and in our search locations I know that my Student Files are on the Desktop, so let's look Everywhere. And the selected file should be a Microsoft Excel file, no webpages, and let's go. And after short time it's found the Annual_Track, and I believe that's the file I was looking for. Let's double-click that file.
Sure enough, the name I was searching for is Joel L. and this is the data that I wanted to find.
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.