Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.
Charts start with data. And in Excel 2007, you select the data in your work sheet, choose the chart type that best suits your purpose and click. And that's how easy it is to create a chart. Let's first take a look at the different kinds of charts that you can create by looking at the Insert tab and the Charting group. If you'd like to open up the EatCake Sales worksheet to follow along, please do. There are different chart types that we can work with in Excel. The first is a column.
And column charts are used to compare values across categories. This is often the most commonly used type of charting that novice Users will work with. In column charts, categories are typically organized along horizontal accesses and just as we see here. In the Line charting type, these are used to display trends over time. And in order to create one of these, you want to arrange your data in columns or rows on a worksheet that can be plotted in a Line chart.
You can work with a pie chart, and pie charts display the contribution of each value to a total. So use this when values can be added together, or when you have only one data series and all values are positive. So this would be a type of chart that we would use to describe our inventory in our eat cake environment. Bar charts are best suited when you are comparing multiple values. Especially if the text is quite long, in terms of your category names.
And then you have your other, more sophisticated types of charting, that we're not going to take a look at in these movies. We are going to concentrate on these ones here. So, in order to create a chart as I mentioned, it's a very simple thing to do. You make sure that you are sitting in the table that you want to chart, you go up to the type of chart you want to create, an click. And then you are presented with additional types of presentations of that particular column type. And I can do a two-dimensional column, I can do a three-dimensional column, and I can get quite sophisticated in how I present it. We're going to keep it simple again, and we're going to do a two-dimensional column.
And this one that I've selected is called a cluster column. I'm going to select it, and it's going embed my chart right in my spreadsheet here. So I can take a look at the values immediately above my table. And I can see very quickly that WADE is the highest performer in this organization because his value point is quite high; higher than anyone else's. And that wasn't quite as visible, if I just move my chart over, just to the right a little bit, you'll see that that wasn't quite as easy to determine by just looking at my table here.
So if I just move my chart right off, it would take me a little bit longer to see that WADE is indeed my highest performer, because it gets lost in the numbers. But if I pull it over here and show you the table, it's quite easy to work with. And it shows it very, very easily. What we're going to take a look at next, is the different ways that we can manage this chart so that we can really enhance it even further. And, obviously I don't want it sitting right in the middle of my sheet. So how do I move that? That's what we're going to learn about in our next movie.
Find answers to the most frequently asked questions about Excel 2007 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.