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.
Another fun addition to any chart is replacing your fill color with a piece of clip art. For example, we modified the fourth quarter data series by double-clicking on the data series and changing the light blue to a dark blue. Let's double-click on that data series again, and instead of simply modifying the color, let's access the Fill Effects. And here we can apply a gradient, that would look very good. You can see that gives it an almost 3-D effect without even being a 3-D chart. Or we'll double-click again, go into Fill Effects and you'll see the last tab is Picture. Well here you can select any bitmap or JPEG or you can select a clipart graphic. If you click Select Picture, you can browse to your Student Folders, and in Charts I've placed a money sign. Insert that and we'll say OK, OK, and there we go. Now you have a dollar sign instead of a fill color. You can adjust that further by double-clicking, Fill Effects, and here you can adjust the Stack scale. Let's take that down to... It's at 10,000 right now, let's take it down to 5000, say OK, and there you go. Now you have dollar signs representing your values instead of a solid bar.
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.