Configuring Options & Settings in Excel 2019 for Windows

Excel 2019 (Windows)    |    Intermediate
  • 10 videos | 32m 59s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 455 users Rating 4.5 of 455 users (455)
Get more out of Excel by customizing it to your own needs. In this 10-video course, you will learn how to manage your account, connected services, and add-ins; configure input, template, and formula options; and customize the interface, ribbon, and Quick Access Toolbar. Key concepts covered in this course include how to configure your account and services, including connecting multiple services to your account; how to install an add-in, access to manage it, and install add-ins from the Office Ribbon; and how to create a custom template and save that template for future use. Next, you will learn how to configure user and input behavior; how to change default formula and calculation settings; and how to change the workbook default settings. Learners then observe how to customize the way in which workbooks are saved; how to customize the appearance of the Excel application; and how to customize the Quick Access Toolbar and its commands. Finally, learn how to customize the Office Ribbon and its commands. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Configuring Options & Settings Exercise as well as the associated materials in the Resources section.

WHAT YOU WILL LEARN

  • Manage account and connected services
    Install and manage add-ins
    Create and manage custom templates
    Configure user and input behavior
    Configure default formula options
  • Change a workbook's default settings
    Customize the save options
    Customize the excel interface
    Customize the quick access toolbar
    Customize the ribbon

IN THIS COURSE

  • 3m 1s
    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 47s
    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 2019 for Windows
    3m 31s
    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 2019 for Windows
    3m 20s
    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 2019 for Windows
    2m 57s
    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 2019 for Windows
    3m 40s
    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 2019 for Windows
    2m 14s
    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 2019 for Windows
    4m 28s
    The Excel 2019 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 2019 for Windows
    2m 18s
    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 2019. FREE ACCESS
  • Locked
    10.  Customizing the ribbon in Excel 2019 for Windows
    3m 42s
    The Excel 2019 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 Ten common tools in Excel 365
Rating 4.5 of 1331 users Rating 4.5 of 1331 users (1331)
Course Using Basic Formulas in Excel 2019 for Windows
Rating 4.5 of 1052 users Rating 4.5 of 1052 users (1052)
Course Creating & Saving Workbooks in Excel 2019 for Windows
Rating 4.4 of 855 users Rating 4.4 of 855 users (855)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Creating & Editing Macros in Excel 2019 for Windows
Rating 4.4 of 250 users Rating 4.4 of 250 users (250)
Course Developing a Mindset of Growth and Learning
Rating 4.7 of 3339 users Rating 4.7 of 3339 users (3339)
Course Working with Data in PivotTables in Excel 2019 for Windows
Rating 4.3 of 206 users Rating 4.3 of 206 users (206)