This online self-study course teaches you how to share Excel 2007 Workbooks.

In many organizations, teams and individuals require frequent and possibly simultaneous access to common spreadsheets and workbooks. To meet these demands without affecting efficiency, a number of review, security, and collaboration features are available in Excel 2007 to allow you to share workbooks. Workbooks, worksheets, and specific data within worksheets, can be protected and shared, enabling only those with access to view or make changes to them.

Workbooks can be shared so that multiple people can access required data, and changes made to workbooks can be tracked, accepted or rejected, and merged. The use of Excel Services and Microsoft Windows SharePoint Services adds an additional level of collaboration and security features. This courses covers range, worksheet, and workbook protection, as well as tracking changes and merging workbooks in Excel 2007. Sharing workbooks, using Excel Services for collaboration, and publishing workbooks to SharePoint are also covered.

Target Audience

End users seeking proficiency in the use of Microsoft Excel 2007 at a power user level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at an Expert level or an equivalent.

Prerequisites

Some knowledge of word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality

Lesson Objectives

1. Excel 2007 Workbook and Worksheet Protection
   • protect an Excel 2007 workbook in a given example
   • apply worksheet protection in a given example
2. Authenticate an Excel 2007 Workbook
   • identify the features of digital signatures in Excel 2007
3. Protecting an Excel 2007 Workbook
4. Share an Excel 2007 Workbook
   • share an Excel 2007 workbook on a network location
   • merge shared workbooks
5. Publish an Excel 2007 Workbook to SharePoint 
   • publish an Excel 2007 workbook to a SharePoint library
   • perform basic actions using SharePoint
6. Share an Excel 2007 Workbook Among Multiple Users