Configuring Options & Settings in Excel 2016 for Windows

IN THIS COURSE

• 1.  Managing your account & connected services in Excel 2016 for Windows
  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
• 2.  Installing & managing add-ins in Excel 2016 for Windows
  3m 52s
  Use add-ins to maximize your use of Excel 2016. See how to download, access and remove add-ins. FREE ACCESS
• 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
• 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
• 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
• 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
• 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
• 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