Course details

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

Expertise Level
Intermediate