Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.
In a previous movie, we looked at some of the options for protecting workbooks and setting permissions. In this movie, we'll make use of that in sharing a workbook with other users. What if you're working on this workbook and you want other people to be able to modify the same workbook at the same time? Well, click the Review tab and choose Share Workbook. And this dialog box that comes up says do you want to allow more than one user to share at the same time? And it should show that you have it open. Click the checkbox. Click OK.
It's going to save the workbook. Click OK to confirm. Now, not much has changed, except you can see up here that the workbook is now in Shared Mode. So, if I were using this right now with other people in the company modifying this workbook, I might see some of the information changing. Well, when we're done with that, when we want to take control back for ourselves and disallow other people from making changes, just click on this Share Workbook again, deselect that, click OK, click Yes to confirm.
And now we have exclusive use. So, when you share a workbook the way we did in this movie, any changes that you or your coworkers make just simply get done and that's it. But what if you want to be able to approve changes before they are committed, kind of like moderating the workbook? Then you'll want to watch the movie about tracking changes, because that is exactly what we're going to do.
There are currently no FAQs about Excel 2010 Essential Training.
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.