Course details

Excel 2019 for Windows: Configuring Options & Settings

Excel 2019 for Windows: 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 for Windows: 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