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.
One of the most useful and just downright fun things to do inside of Microsoft Excel is create charts. Before we begin creating charts, we should take a look at the chart terminology and understand the components of a chart. If you'll browse to your Student Files, you'll find in section 10 Charts, a spreadsheet called Quarterly_Sales; yet another version. There we go. Now there's a quick and easy way to make a chart from any spreadsheet. Select the applicable data, in this case I only want the titles and the values within my chart and press the F 11 key, and voila, we have a chart. Now that was fast and easy. Let's go over the terminology in this chart. The first thing you need to know is the Category Axis. The Category Axis describes the main categories that we're comparing within this chart. Next we have the Value Axis. The Value Axis can have labels or various scales that describe how we're comparing this chart.
Here we have the scale values, so you know exactly what the differences are, what's being measured. In this case it's dollars and the units are incremented by 10,000. Over here we have our legend. This describes the color scheme for the bar chart that we're looking at and you can follow exactly which color bar describes which division. A chart may also have a title; this one doesn't. We can add that later. Gridlines. Gridlines can be horizontal and vertical. By default, this one came up as horizontal only. The Chart Area. The Chart Area is this entire window that appears on this chart tab. And you should also note that the Chart tab has been added to our workbook and is sitting on top of the various sheets that we have in this workbook. And the Plot Area, which is represented by this gray box. Everything you see inside the Plot Area is your actual chart. Those are the basic components of any chart regardless of the style, and be aware there are many, many different styles of charts that you can use. Based on the data that you're trying to present, different charts may be applicable.
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.