Configuring Options & Settings in Excel 2016 for Windows

Excel 2016 (Windows)    |    Intermediate
  • 8 videos | 28m 42s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 106 users Rating 4.6 of 106 users (106)
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 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
    6m
    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

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

Rating 4.5 of 455 users Rating 4.5 of 455 users (455)
Rating 4.5 of 1331 users Rating 4.5 of 1331 users (1331)
Rating 4.0 of 4 users Rating 4.0 of 4 users (4)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 62 users Rating 4.4 of 62 users (62)
Rating 4.4 of 307 users Rating 4.4 of 307 users (307)
Rating 4.5 of 318 users Rating 4.5 of 318 users (318)