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

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

Prerequisite
None

Expected Duration
62 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.