5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Collections     Essentials     Microsoft Excel     Microsoft Office 2019: Intermediate Excel

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.



Objectives

Excel 2019 for Windows: Configuring Options & Settings

  • 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
  • Knowledge Check: Configuring Options & Settings