Configuring Options & Settings in Excel 2016 for Windows

Excel 2016 (Windows)    |    Intermediate
  • 8 videos | 28m 42s
  • Includes Assessment
  • Earns a Badge
Likes 60 Likes 60
Get more out of Excel 2016 by customizing it to your own needs. Learn how to manage your account, connected services, and add-ins; configure input and formula options; and customize the interface, ribbon, and Quick Access Toolbar.


  • Managing your account & connected services
    Installing & managing add-ins
    Configuring your input options
    Configuring your default formula options
  • Customizing your document default settings
    Customizing your interface
    Customizing the Quick Access toolbar
    Customizing the ribbon


  • 4m 29s
    In Excel 2016, you can connect multiple services to your account. See how to manage your connected services such as LinkedIn and OneDrive all from your Microsoft Excel account. FREE ACCESS
  • 3m 52s
    Use add-ins to maximize your use of Excel 2016. See how to download, access and remove add-ins. FREE ACCESS
  • Locked
    3.  Configuring your input options in Excel 2016 for Windows
    2m 27s
    If you use Excel 2016 a lot, you may find it useful to know how to customize Excel's user and input behavior. For example, you can activate and deactivate the live preview function, switch off the Quick Analysis tools, and even change the way in which you refer to your cells. FREE ACCESS
  • Locked
    4.  Configuring your default formula options in Excel 2016 for Windows
    3m 1s
    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, how to turn off formula autocomplete and how to see PivotTable data functions to PivotTable references. FREE ACCESS
  • Locked
    5.  Customizing your document default settings in Excel 2016 for Windows
    3m 24s
    In Excel 2016, a workbook's defaults can be adjusted to suit your preferences. You can specify how many worksheets are created in a new document, the default font applied, and even change the view mode that is active when a worksheet is first created. FREE ACCESS
  • Locked
    6.  Customizing your interface in Excel 2016 for Windows
    2m 49s
    The Excel 2016 interface can be customized to make it more visually appealing. For example, you can choose a different color scheme, change the Excel 2016 background design, and even specify the user details associated with the Excel program. FREE ACCESS
  • Locked
    7.  Customizing the Quick Access toolbar in Excel 2016 for Windows
    2m 40s
    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 2016. FREE ACCESS
  • Locked
    8.  Customizing the ribbon in Excel 2016 for Windows
    The Excel 2016 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


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.


Likes 11 Likes 11  
Likes 1 Likes 1  


Likes 200 Likes 200  
Likes 335 Likes 335