Excel Office 365: Configuring Options & Settings


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

This 10-video course offers learners an in-depth exploration of how to customize Excel for Office 365 to their specific requirements. Learn how to connect to SharePoint, OneDrive and the Office Store from your Microsoft account. Then learn how to search the add-in store, install an add-in, and to manage installed add-ins from the Office ribbon. Learners will observe how to create a custom template, and make it a default template. This course demonstrates how to activate and deactivate the Live Preview function, to switch off the Quick Analysis tools, hide the mini-toolbar, and other customizations. You will learn to specify the number of worksheets in a new document, change the default font, and the View Mode. Continue by learning how to configure AutoSave, and to adjust the default Save format and location. This course demonstrates how to change the background and theme, customize your Office copy, change your window and status appearance, and language settings. Finally, you will learn how to add shortcuts with the Quick Access Toolbar, and customize the Office Ribbon.



Expected Duration (hours)
0.6

Lesson Objectives

Excel Office 365: 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_msex365_20_enus

    Expertise Level
    Intermediate