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.
To unshare your workbook, you simply reverse the commands we did in the previous movie. We go up to the Share Workbook command, click on it, and deselect the check box that allows changes to be made by more than one user at a time. click on OK. And you get this warning. It says that the actions going to remove the workbook from shared use. Any change history is going to be erased, and any other users who are editing the workbook, will not be able to save their changes.
Even if you save the workbook again. So once it's been shared and you remove the sharing you can't return it to a shared mode. That's fine, I'm ready to un-share this workbook now so I'm going to click Yes, to make the workbook exclusive to me. And you'll notice that the shared option in the top title bar of my workbook is now removed. Let's just save that for good measure, by clicking on the Save smart icon in my Quick Access toolbar.
To track changes that are made to my worksheets, I can activate the track changes command, by clicking on the button and selecting highlight changes. This opens up a highlight changes dialog box, and it identifies for me, or it gives me the option, to track the changes while I'm editing. How am I going to see that those changes are made? Well, I going to highlight any change that happens in the workbook, I'm going to also track the changes made by everyone who touches this workbook, I can also have the choice to just highlight anything that everyone else has done, other than myself.
And I can identify a particular area in the workbook that I'm interested in tracking the changes on. I'm not all that interested in if someone changes the item category, but I may be interested if someone changes the final costs. So I'm going to select where, and I'm going to identify the different range that I'm interested in and seeing who make changes too. As I make those changes I want them highlighted on the screen. So let's see how this changes our worksheet.
If I click OK, the actions going to save the worksheet, and I'm going to say, "Yes, I want to continue." And it moves it back into a shared mode. As I go in and track the changes, if I change the final cost to be $200, it identifies that something has changed in there by placing a little tag on that cell. As you mouse over the cell, it identifies who changed the cell. It gives the name, the date, and timestamp for the person who did the change, and it also identifies what change was done.
As the owner of the worksheet, I can determine whether or not I like that change and I want to included it in the information. I go back up to the Track Changes area, I select the Accept/Reject Changes command, now I can save my worksheet. I identify what changes I'm going to accept or reject. If I select them all, I'm going to accept them, click OK. It identifies what change was made.
I'm going to accept that particular change. And the changes are now part of my overall worksheet.
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.