Setting your work preferences in Excel 365
Excel Microsoft 365 (2021)
| Beginner
- 9 videos | 42m 57s
- Includes Assessment
- Earns a Badge
- CPE
Get the most out of Excel 365 by customizing it to your own needs. In this course, you will learn how to customize the interface, ribbon, and Quick Access Toolbar; manage your account add-ins; configure user input and template options, and customize default document settings. Key concepts covered in this course include how to customize the appearance of the Excel 365 interface, including options to customize the Quick Access Toolbar and its commands as well as the Office ribbon and its commands. You will also discover how to install an add-in and manage it, install add-ins from the Office ribbon, and create custom templates and save those templates for future use. Next, you will learn how to configure user and input behavior, customize how workbooks are saved; and change the workbook default settings. In order to practice what you have learned, you will find practice exercises in the Course Contents pane or in the Resources section.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this microsoft 365: setting your work preferences in excel 365 course
Customize the excel 365 quick access toolbar
Customize the excel 365 interface
Install and manage add-ins in excel 365
Create and manage custom templates in excel 365 -
Configure user and input behavior in excel 365
Customize the excel 365 save options
Customize default document settings in excel 365
Customize the excel 365 ribbon
IN THIS COURSE
-
48sThis video outlines the key content covered in the Microsoft 365: Setting your work preferences in Excel 365 course, including how to customize the interface, create and manage custom templates, and how to configure user and input behaviour. FREE ACCESS
-
5m 4sIn Excel 365, you can add shortcuts to your Quick Access Toolbar to make it easier to find the tools you frequently use. In this video, you will discover how to customize the Quick Access Toolbar by adding, reordering, and removing shortcuts. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.4.1 Customize the Quick Access toolbar. FREE ACCESS
-
3. Customizing the interface5m 31sThe Excel 365 interface can be personalized to be more appealing, like changing the color scheme or the background design or to suit your work practices. In this video, you will explore how to change the Microsoft Office background and theme, customize the Startup options, and personalize the Status bar. FREE ACCESS
-
4. Installing and managing add-ins5m 15sAdd-ins are additionally installed features that increase or enhance the functionality of Excel 365, providing optional commands and features. In this video, you will discover how to search for, install, manage, and delete add-ins. FREE ACCESS
-
5. Creating and managing custom templates5m 36sExcel 365 allows you to create custom templates for frequently-used workbook layouts to save time. In this video, you will learn how to search for the templates folder. You will also explore how to create, manage, and delete custom templates. FREE ACCESS
-
6. Configuring user and input behavior4m 36sIf you use Excel 365 often, it may be useful to customize the user and input behavior to suit your needs. In this video, you will explore how to activate and deactivate the Mini Toolbar, Live Preview, Quick Analysis, and ScreenTips. FREE ACCESS
-
7. Customizing the save options4m 37sSaving your Excel 365 workbooks is essential, and you can change the default settings according to your preferences. In this video, you will explore how to activate AutoSave to save changes to OneDrive. As well as configure other save options, such as Auto Recover and changing the format a file saves as. FREE ACCESS
-
8. Customizing default document settings5m 44sExcel 365's document settings can be changed to suit your preferences. In this video, you will explore how to choose the default view, font, and font size of a new workbook. As well as customize the input and navigation defaults. FREE ACCESS
-
9. Customizing the Ribbon5m 47sThe Excel 365 Ribbon is where you find the tools to create and edit your workbook. In this video, you will explore how to customize the Ribbon by changing the display options and adding custom tabs. 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.
