Description

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. Workbooks, worksheets, and specific data within worksheets, can be protected, 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.