Excel 2019: Configuring Options & Settings


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Get more out of Excel by customizing it to your own needs. In this 10-video course, you will learn how to manage your account, connected services, and add-ins; configure input, template, and formula options; and customize the interface, ribbon, and Quick Access Toolbar. Key concepts covered in this course include how to configure your account and services, including connecting multiple services to your account; how to install an add-in, access to manage it, and install add-ins from the Office Ribbon; and how to create a custom template and save that template for future use. Next, you will learn how to configure user and input behavior; how to change default formula and calculation settings; and how to change the workbook default settings.  Learners then observe how to customize the way in which workbooks are saved; how to customize the appearance of the Excel application; and how to customize the Quick Access Toolbar and its commands. Finally, learn how to customize the Office Ribbon and its commands.



Expected Duration (hours)
0.6

Lesson Objectives

Excel 2019: Configuring Options & Settings

  • view and configure connected account and services in Excel
  • view and configure Add-ins in Excel
  • create, save and reuse a custom template
  • configure user and input behavior in Excel
  • change default formula and calculation settings in Excel
  • change the workbook default settings in Excel
  • customize the way in which workbooks are saved in Excel
  • customize the appearance of the Excel application
  • customize the Quick Access Toolbar and its commands
  • Customize the Office Ribbon and its commands
  • Course Number:
    ds_msex2019_20_enus

    Expertise Level
    Intermediate