Microsoft Excel 2016 Intermediate: Customizing Views, Styles, and Templates

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

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

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016

Prerequisites
None

Expected Duration (hours)
1.0

Lesson Objectives

Microsoft Excel 2016 Intermediate: Customizing Views, Styles, and Templates

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

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

configure appropriate views, layout, and visual elements in Excel 2016

Course Number:
mo_inel_a01_dt_enus

Expertise Level
Intermediate