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.
We're now ready to review our work. We've opened up the EatCake Inventory list3 that's included in the Reviewing your Worksheet Folder, on your Exercise Files, to play around with the options that you can see when you want to review the information before you're ready to present it to other people. So if we take a look at the summary report that I've just created, and I collapsed each of my subtotals, so Flour Total, Icing Total, Mix Total, Sprinkle Totals and Grand Toppings, I notice that I have one thing that's not showing up very clearly, and that's my Grand Total. I have a bunch of number signs in that particular final column, where as if I mouse over top of it, I would see that there's actually a value in there of the sum of all of the costs.
One of the things that you want to make sure you're doing when you are proofing your work is that you're not sending out information that is hidden, like this. This is easily rectified by using something that we learned in a previous movie, and that's to adjust the column width. Easiest way to do that is to go up to the top of your columns, making sure you're looking for the crosshairs, clicking and dragging the information out so that you expand the size of the column, and you're now able to see your Grand Total.
We now want to take another look at the expanded list, so let's highlight all of the table, go back up to our outlined group, and use the Expand or Show Detail command, by clicking on the little button. You'll see that it's expanded the toppings option here. If I would like to do the rest, I can simply click on the plus signs in each individual category to expand the whole screen.
Next, I want to go to the Review tab to see some of the other options that I can use when I'm reviewing my work, before sharing it with people. One of the things that I always do before I send out any information is check my spelling. So by clicking on the check spelling option, it will go through all the information in the selected area and identify some spellings that may not be used in the dictionaries for the different languages that you're looking at. In this case, Buttercream is suggested to be two words rather then one.
In my case, Buttercream's going to be one word, and I'm going to ignore all instances where that suggestion may come up. Here it's found an actual valid spelling mistake where I've switched the letters in Dutch. I'm going to take its suggestion, and change the spelling. It's checked all the selling in all of the cells that were selected, and now my spell check is finished. Now I'm sure that the information that is going to be presented in my worksheets are clear and free of spelling errors.
I could also use the Research options which allows me to reference materials such as dictionaries and encyclopedias or translation services if I was going to be using multilingual spreadsheets. I could look up thesaurus information for words that may have similar meanings so that I'm not repeating myself, and I can also use the translating options in Excel spreadsheets.
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.