MOS 2016 Study Guide for Microsoft Excel Expert

Objective group 1. Manage workbook options and settings

The skills tested in this section of the Microsoft Office Specialist Expert exam for Microsoft Excel 2016 relate to managing workbook options and settings. Specifically, the following objectives are associated with this set of skills:

1.1 Manage workbooks

1.2 Manage workbook review

Every Excel workbook exists within a larger ecosystem of objects, including templates, macros, and other workbooks. Mastering workbook management requires knowing not only how to connect workbooks with these other objects, but also how to share a workbook’s data with other users.

This chapter guides you in studying methods for creating workbooks from templates and saving workbooks as templates, enabling macros ...