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.
Here we have a workbook that has more than one worksheet in it. We've copied our information from Sheet1 to Sheet2. Well, assuming that those two sheets had unique information it would be appropriate for us to identify those sheets by renaming the tabs. The default Sheet1, Sheet2, Sheet3, etc. is not very descriptive. If we go to Sheet1, we can right-click on that tab, from this quick menu we choose Rename and you'll see that the sheet title has been highlighted and is waiting for us to enter some information. So let's enter Annual Sales. I'll remind you again of the added complexity in using a sheet's external reference when you add a space to the name, but I don't think it should deter you. Let's remove the formatting here and Sheet2, select that tab, go up to Format > Sheet, and you'll see here, Rename is also an option, does exactly the same thing, just the long way around. We'll call this one Copy. You can also add color to those tabs, if it'll help identify. You can right-click on the tab and choose Tab Color. From here I think I'll choose an electric blue, there we are, and you'll notice that when the tab's selected, we only see a strip of the color that's on that tab. As soon as I select another tab, the color takes over the tab completely. Right-click, Tab Color, choose green and we'll select Sheet3 just so we can see the two colors of the tabs. Both of those options that I just mentioned, the renaming and the coloring of those tabs can be found under Format and Sheet. It really does enhance the visual appeal when you use colors appropriately. Whether it's in your tabs or on your worksheet, color is a great way to wrap up your presentation.
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.