Desktop Certifications     Microsoft     Microsoft Office Specialist (MOS) on Microsoft Office 2016     77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation

---

Making the Microsoft Excel 2016 environment look exactly the way you want it to is easy. In this course, you will learn how to configure how you want a workbook and the work area itself to appear. You will also learn how to add and customize templates and styles to really make Excel 2016 work for you.

---

---

Objectives

Customizing Views start the course modify default display options in Excel 2016 select workbook view options in Excel 2016 select window view options in Excel 2016 modify the Quick Access Toolbar layout in Excel 2016 modify the ribbon layout in Excel 2016 modify default column and row settings in Excel 2016 Applying Custom Styles and Templates create and modify custom templates in Excel 2016 create custom color formats in Excel 2016 create and modify cell styles in Excel 2016 create custom form fields in Excel 2016 Practice: Visual Elements and Views configure appropriate views, layout, and visual elements in Excel 2016