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.
Before I share this spreadsheet, I'd like to add some comments in certain areas, were I would like someone to review the information in detail. And I'm going to do that by using the New Comment option in the Comments group, on the Review tab. Let's say I would like to identify that the cost of this particular pastry flour is quite high. It's costing us $7.00, for that particular pastry flour. So I want to send this item over to one of my suppliers and just see if there's any way that I can get this at a reduced cost.
I select the cell where I want to put the comment in, and a go up to the New Comment command in my Comments group. Clicking it once allows me to type in the information in a dialog box you see here. It identifies the person writing the comment so that we can track what comments were made by whom. In this particular case, I want to make a note of Can I get this flour at a better price? Clicking off of the comment area removes it from view and editing, but as I mouse over the indicator, the little red arrow in the top corner of the cell where I made the comment, I can then see the comment pop-up for my review.
If I'd like to edit this comment, I can go back up to the Edit Comment box in my Comments group, select it, and it'll allow me to add in additional information in that particular comment. If I'm happy with it, I just click off the comment and I now have my different comment options available to me. I can review the comments that are in a particular spreadsheet by using the Previous, Next buttons commands that I see here. If I'd like to see the next comment in the spreadsheet, I simply click on the Next command button and it pops me down to the next comment in the column that I'm working in.
If I'd like to go back to the previous comment, I simply click the Previous button and it pops me up. If I'd like to delete a particular comment, I can do so by clicking on the Delete comment button here. At any point in time, I can show all the comments in a particular document by selecting the Show All Comments command. So I can see everything in front of me. As well, once I've reviewed all of the comments, I can hide them by clicking the Show/Hide Comments.
And in this case, I can hide that one as well. By using the commenting ability in the Excel spreadsheets, you can really identify to people, your thoughts on different areas of the spreadsheet, that you can then share with them as you send off the information in your spreadsheet.
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.