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.
Microsoft Excel 2007 supports numerous types of charts to help you display information in a much more meaningful way, to your audience. Charts can convey much more than numbers alone, because Charts present data in a visual way that makes it easier to see the meaning behind the numbers. And with the new charting capabilities in Excel 2007, it's easier than ever to turn the data into meaningful information. Every chart starts with data.
In Excel 2007, you can select your worksheet, and choose a chart type that best suits your purpose and click. And if you want to choose a different type, you just click again. So you can see various options just by pointing at some in the dialog box. So you don't have to spend time applying and reapplying different chart formats and changes and making adjustments to your data. This is one area that Microsoft Excel 2007 has really improved upon.
Let's take a really quick look at how to create a chart with the data that we have here. Right now, I've got the EatCake Sales results for the quarters of last year. If I wanted to quickly see what this would look like as in a chart, I could go to my Insert tab, which is where my charting functions are stored, and I'm just going to quickly click on the Column chart, and I'm going to select this 2-D column stacked chart. And you'll see here that the information that we have in behind this chart is now nicely presented and is much easier to see that the WADE is my top performer, because it's now visually presented in a chart format.
Rather than having to search through and investigate all of the different information here in the table, I can easily see my high performers and my low performers, based on the information that's included here. Let's take a look at how we actually create this and in more detail.
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.