Setting your work preferences in Excel 365 (2023)

Excel 365 (2023)    |    Beginner
  • 9 videos | 35m 47s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
You can get more out of Excel 365 by customizing the app. This course explores different ways to tailor the Excel application and interface to your needs. First, see how to personalize elements of the interface. You will see how to change your Office account options, including the Office Theme and application background. Find out how to customize the Quick Access Toolbar and Ribbon as well. Next, you will learn how to configure other key aspects of Excel. In particular, see how to modify save settings and default workbook settings. Finally, discover other ways to customize your experience in Excel. See how to create your own custom templates and install add-ins to extend the app's functionality. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps).

WHAT YOU WILL LEARN

  • Discover the key concepts covered in the setting your work preferences in excel 365 (2023) course
    Customize the quick access toolbar's commands and appearance
    Customize the ribbon commands and appearance
    Configure office settings, including account user information, office theme, and user name
    Configure autosave, default save format, and default save location
  • Configure default workbook settings
    Configure start up options and the display of recent files
    Create and manage custom workbook templates
    Install, manage, and remove add-ins

IN THIS COURSE

  • 1m 5s
    This video outlines the key content covered in the Setting your work preferences in Excel 365 (2023) course, including installing add-ins, customizing default workbook settings, and customizing the Ribbon. FREE ACCESS
  • 5m 12s
    By default, the Quick Access Toolbar runs across the top of the Excel interface and contains commands like Save, Undo, and Redo. You can customize the Quick Access Toolbar by adding and removing commands. You can also move the toolbar to the bottom of the application interface or hide it altogether. This video aligns with MO-210 Microsoft Excel Exam objectives: Manage the Quick Access toolbar. FREE ACCESS
  • Locked
    3.  Customizing the Ribbon in Excel 365
    5m 16s
    The Ribbon is where you will find all the commands you will need in Excel. Not only can you customize the way the Ribbon displays, but you can also choose how commands are organized, and even create your own custom tab. Find out more in this video. FREE ACCESS
  • Locked
    4.  Configuring your Office account settings in Excel 365
    5m 9s
    As part of the Microsoft Office 365 suite, Excel shares features with other Office apps. In this tutorial, you will learn how to customize these features, including the Office Theme, Background, and your user name. You will also see how to find user information, account privacy settings, and information on products and updates. FREE ACCESS
  • Locked
    5.  Configuring save options in Excel 365
    3m 28s
    You can customize the way you save files to work more efficiently. In this video, see how to configure AutoSave and AutoRecover settings, choose your default save format, and change the location workbooks save to. FREE ACCESS
  • Locked
    6.  Configuring default workbook settings in Excel 365
    4m 10s
    You can modify Excel's workbook settings to suit your preferences. In this video, you will learn how to choose the default view, font, and font size of a new workbook, as well as how to customize the input and navigation defaults. FREE ACCESS
  • Locked
    7.  Configuring start up & display options in Excel 365
    3m 56s
    In Excel, you can customize the way the app opens and how you display your files. In this tutorial, you will see how to manage recent and pinned files as well as configure startup options and display settings. FREE ACCESS
  • Locked
    8.  Creating custom templates in Excel 365
    3m 18s
    Templates can save you time formatting and editing workbooks. In addition to the many built-in Office templates, you can create your own custom templates. Find out more in this tutorial. FREE ACCESS
  • Locked
    9.  Installing add-ins in Excel 365
    4m 12s
    Add-ins let you extend Excel's functionality across platforms. You can use add-ins to add custom functions, create custom Ribbon buttons, and more. In this tutorial, you will see how to find, install, and manage add-ins. 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 Exploring essential functions in Excel 365 (2023)
Rating 4.9 of 7 users Rating 4.9 of 7 users (7)
Course Getting started in Excel 365 (2023)
Rating 3.5 of 57 users Rating 3.5 of 57 users (57)
Course Collaborating safely in Excel 365 (2024)
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)