Overview/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...

Overview/Description Excel 2007 simplifies the reviewing and printing processes by centralizing all related features within the various tabs of the Ribbon. The Review tab enables you to quickly access tools for proofing content and adding comments. Using the Page Layout view, you can preview how your worksheets will look when they are printed, and adjust them as needed to achieve professional results. This course explores Excel 2007 reviewing features, such as spellchecking, translating, and using comments. Configuring entire workbooks, spreadsheets, and spreadsheet selections for printing,...

Overview/Description To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test. Target Audience Individuals seeking practice in a structured testing environment,...

Overview/Description To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test. Target Audience Individuals seeking practice in a structured testing environment,...