10 common tools in Excel 365

Excel 365 (2023)    |    Beginner
  • 11 videos | 43m 12s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 3.0 of 2 users Rating 3.0 of 2 users (2)
To make the most out of Excel 365, you need to be familiar with some of its most frequently-used features. This course highlights ten tools to help take your Excel proficiency to the next level. In this course, you will see how to use the Selection Pane and related tools to select objects in a worksheet. Find out how to quickly apply commands with keyboard shortcuts, search, and KeyTips. Discover a number of features designed to help you review your worksheet, including spell check, AutoCorrect, Smart Lookup, and Translate. In addition, the course explores different ways to find and resolve issues in your workbooks. See how to check for issues related to compatibility with older versions of Excel, accessibility to users with different needs, as well as privacy and confidentiality. Finally, find out how to recover unsaved workbooks. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in the 10 common tools in excel 365 (2023) course
    Use the selection pane, select objects tool, and go to special tool to select objects in a worksheet
    Apply commands using the search bar, keytips, and keyboard shortcuts
    Check spelling in a worksheet
    Use autocorrect to automatically correct spelling and grammar mistakes
    Search words and phrases using smart lookup
  • Use the translation tool
    Use the document inspector to find and remove sensitive information
    Check for compatibility issues with different workbook formats and save files to an older format
    Use the accessibility checker to resolve accessibility issues and access accessibility options
    Recover and remove unsaved workbooks in excel

IN THIS COURSE

  • 1m 1s
    This video outlines the key content covered in the 10 Common Tools in Excel 365 (2023) course, including quickly applying commands, checking spelling, and improving accessibility. FREE ACCESS
  • 4m 48s
    You can select objects, like shapes, charts, and images, if you need to manage or format them. In this video, you will see how to quickly select all objects using Go To Special, select individual objects using the cursor, and hide and show objects with the Selection Pane. FREE ACCESS
  • Locked
    3.  Quickly applying commands in Excel 365
    4m 20s
    Besides manually navigating the Ribbon and the right-click context menu, Excel offers other ways to quickly access the dozens of commands available in the app. You can search for a command by name using the search bar, navigate the Ribbon with the keyboard thanks to KeyTips, and instantly apply commands using keyboard shortcuts. See how in this tutorial. FREE ACCESS
  • Locked
    4.  Checking spelling in Excel 365
    5m 4s
    Before sharing your workbook, it is a good idea to check it for spelling mistakes. In this video, you will see how to run spell check and respond to suggested changes. You will also see how to configure proofing options and access the custom dictionaries. FREE ACCESS
  • Locked
    5.  Using AutoCorrect in Excel 365
    4m 37s
    AutoCorrect can save you time and improve accuracy while editing workbooks. In this video, you will see how to use AutoCorrect to automatically fix common spelling mistakes. You will also see how to add words to AutoCorrect and configure other AutoCorrect options. FREE ACCESS
  • Locked
    6.  Using Smart Lookup in Excel 365
    3m 57s
    You can use the Smart Lookup tool to quickly find additional information about key words and phrases used in your spreadsheets. In this video, you will discover how to use Smart Lookup to find images, definitions, and information on the Web. FREE ACCESS
  • Locked
    7.  Translating text in Excel 365
    3m 14s
    If you ever need to work in multiple languages, the Translate tool can come in handy. In this video, you will see how to translate between different languages in Excel. FREE ACCESS
  • Locked
    8.  Using the Document Inspector in Excel 365
    3m 11s
    Before sharing a workbook, it is a good idea to check for any hidden data or personal information that might have been added. Using the Document Inspector, you can find and remove comments, hidden rows and columns, and other elements that might contain sensitive information. Find out more in this tutorial. This video aligns with MO-210 Excel Exam objective: Inspect workbooks for issues. FREE ACCESS
  • Locked
    9.  Checking for compatibility issues in Excel 365
    4m 17s
    If you plan on sharing workbooks with users who own earlier versions of Excel, it is important to check for potential compatibility issues. In this video, you will see how to use the Compatibility Checker tool, as well as how to save your workbook to older file formats. This video aligns with MO-210 Excel Exam objective: Inspect workbooks for issues. FREE ACCESS
  • Locked
    10.  Improving accessibility in Excel 365
    5m 12s
    It is important to check accessibility to ensure that all users, including those with disabilities, can access and interact with the content. This includes making sure the document is screen reader-friendly and has appropriate color contrast. In this video, you will see how to find and resolve accessibility issues in Excel. This video aligns with MO-210 Excel Exam objective: Inspect workbooks for issues. FREE ACCESS
  • Locked
    11.  Recovering unsaved changes in Excel 365
    3m 31s
    AutoRecover in Excel 365 automatically saves a copy of your work every few minutes. So, if your device crashes, you can restore the last automatically saved version of the workbook. In this tutorial, you will see how AutoRecover works, as well as how to configure AutoRecover options. 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

Rating 4.6 of 416 users Rating 4.6 of 416 users (416)
Rating 4.2 of 123 users Rating 4.2 of 123 users (123)
Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)