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.
Almost every aspect of a chart can be edited after its creation. If you access the Chart menu, which is visible when the chart is selected, the chart type, source data, and many other chart options can be affected. Let's select a new chart type. This takes you back to that dialog box that allows you to select the kind of chart we're representing. Let's scroll down and look at a cylindrical chart. It's very similar to the bar chart we just had; it's just a little flashier in 3-D. Let's go ahead and select that type. We can also reposition our chart within our page. I can resize it, move it, and enlarge it.
We can position and size it anywhere in our sheet to give it the best presentation possible. To edit individual elements within the chart. Simply select the element, usually double- clicking. By double-clicking on the title I've gotten into the Format Chart Title dialog box which allows you to control the coloring, the font, and alignment of your chart title. In this case, I'm going to select the title and correct a spelling error. And I'll click away to finish editing and now we have a brand -new corrected title. I can edit the legend by simply clicking on the legend. This allows me to move it, resize it, and I can work with each individual series title within the legend by simply selecting that. Now I can control the font, the font size, and many other aspects for that legend. If I want to affect a data series, I simply need to select one bar of the data series. You'll notice that by selecting one of the bars for the fourth quarter, all of the data series for the fourth quarter were selected. Now I can go in and change their color. With a double-click I get into the Format Data Series dialog box and I have a ton of different options that I can apply to that single data series. Let's go ahead and change the color. Because we're working with a three-dimensional chart, we can also alter the three-dimensional view. You do that in one of two ways. First we can go up to the Chart menu and select 3-D View. That brings up a dialog box that allows us to incrementally move the view that we have currently keep double-clicking any of the controls, and they began an animated move. I can rotate, and I can adjust the levels of my view in a very precise way using these dialog boxes.
Let's say OK to this. You can see it moved my view, just a little bit. If I select the Plot Area behind my bars, I get these corner handles and when I grab one of them I can rotate the chart freely, and when I release you can see I have a brand-new perspective on this chart.
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.