10 common tools in Excel 365 (2023)

Excel 365 (2023)    |    Beginner
  • 11 videos | 42m 6s
  • 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.


  • 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


  • 58s
    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 44s
    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 17s
    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
    4m 52s
    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 22s
    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 51s
    You can use the Smart Lookup tool to quickly find additional information about keywords 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 12s
    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 3s
    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 16s
    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 2s
    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 30s
    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


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.


Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)