Course Details

Previous Page


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


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



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