Configuring Options & Settings in Excel Microsoft 365 for Windows

Excel Microsoft 365 (Windows)    |    Intermediate
  • 10 videos | 35m 40s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 2 users Rating 4.5 of 2 users (2)
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 3m 13s
    In Excel, you can connect multiple services to your account and view the details associated with your Office installation. See how to manage your connected services, such as SharePoint, OneDrive, and the Office Store, all from your Microsoft account. FREE ACCESS
  • 3m 51s
    Use Add-ins to maximize your use of Excel. You can browse or search the Add-in Store, install an Add-in once you've found what you're looking for, and access and manage your Add-ins from the Office ribbon. FREE ACCESS
  • Locked
    3.  Creating & managing custom templates in Excel Microsoft 365 for Windows
    3m 45s
    In Excel, you can create your own custom templates. Once you have a base workbook ready, you can save it using the Excel Template format to your default template location. This will ensure that the template is available in the Templates area when you use Excel. FREE ACCESS
  • Locked
    4.  Configuring user & input behavior in Excel Microsoft 365 for Windows
    3m 15s
    If you use Excel a lot, you may find it useful to know how to customize its user and input behavior. You can, for example, activate and deactivate the Live Preview function, switch off the Quick Analysis tools, and hide the Mini Toolbar. FREE ACCESS
  • Locked
    5.  Configuring your default formula options in Excel Microsoft 365 for Windows
    3m 8s
    You may also like to configure your default formula options so that they're customized to your use. See how to adjust your default cell reference format and how to turn off formula AutoComplete. FREE ACCESS
  • Locked
    6.  Customizing your document default settings in Excel Microsoft 365 for Windows
    4m
    Excel's document defaults can be adjusted to suit your preferences. You can specify how many worksheets are created in a new document, the default font that is applied, and even the view mode that is active when the workbook is first opened. FREE ACCESS
  • Locked
    7.  Customizing your save options in Excel Microsoft 365 for Windows
    2m 35s
    It is extremely important to know how to save your document. In Excel, you can adjust the default settings relating to your file format and save location. FREE ACCESS
  • Locked
    8.  Customizing your interface in Excel Microsoft 365 for Windows
    5m 32s
    The Excel interface can be customized to make it more visually appealing. For example, you can choose a different color scheme, change the Excel background design, and even specify the user details associated with the Excel program. FREE ACCESS
  • Locked
    9.  Customizing the Quick Access Toolbar in Excel Microsoft 365 for Windows
    2m 26s
    Add shortcuts to your Quick Access toolbar to make it easier to find the tools that you use the most frequently. The Quick Access toolbar is accessible from just about every screen in Excel. FREE ACCESS
  • Locked
    10.  Customizing the ribbon in Excel Microsoft 365 for Windows
    3m 55s
    The Excel ribbon is where you will find the tools for creating and editing your spreadsheets. You can customize the ribbon by creating your own tab regrouping the tools that you use most. You can also hide any tabs that you don't typically use and prefer to keep from view. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Collaborating & customizing PowerPoint 365
Rating 4.4 of 101 users Rating 4.4 of 101 users (101)
Course Creating Presentations in PowerPoint 365
Rating 4.5 of 475 users Rating 4.5 of 475 users (475)
Course Using macros in Excel 365
Rating 4.2 of 123 users Rating 4.2 of 123 users (123)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Referencing data in Excel 365
Rating 4.6 of 416 users Rating 4.6 of 416 users (416)
Course Key Accounting Concepts and Principles
Rating 4.4 of 2088 users Rating 4.4 of 2088 users (2088)
Course Extracting Information with Formulas in Excel 2016 for Windows
Rating 4.6 of 299 users Rating 4.6 of 299 users (299)