Ten common tools in Excel 365

IN THIS COURSE

• 1.  Course Overview: Ten common tools in Excel 365
  48s
  This video outlines the key content covered in the Microsoft 365: Ten common tools in Excel 365 course, including how to switch between the view modes, check the spelling in your spreadsheet, and how to check the accessibility of your worksheet. FREE ACCESS
• 2.  Adjusting the zoom level of a spreadsheet
  3m 25s
  The zoom tools can be used to adjust the magnification at which you visualize spreadsheets in Excel 365. In this video, you will explore how to zoom in on data entries to focus on them more precisely, as well as how to zoom out of data to get an overall view of a worksheet. FREE ACCESS
• 3.  Selecting objects in a workbook
  3m 58s
  The Selections tools in Excel 365 can help you locate and select graphical objects that have been inserted into a worksheet. In this video, you will explore how to open and use the Selection Pane and how to select objects quickly in Excel 365. FREE ACCESS
• 4.  Switching between the view modes
  3m 16s
  Excel 365 features three preset view modes. Normal mode is used to enter data and work on a spreadsheet. The Page Layout view can be used to check margin settings and visualize how pages are laid out. The Page Break Preview mode is extremely useful for adjusting where the page breaks fall in a spreadsheet before you print it out. In this video, you will explore how to use the view modes in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.4.2 Display and modify workbook content in different views. FREE ACCESS
• 5.  Performing tasks with keyboard shortcuts
  4m 20s
  Excel 365 supports a wide range of keyboard alternatives, or shortcuts, which are typically faster to use and better suited to users with vision or mobility impairments than using a touchscreen or mouse. In this video, you will discover how to use keyboard shortcuts for frequently-used tasks in Excel 365. FREE ACCESS
• 6.  Navigating between worksheets
  3m 10s
  A single workbook can contain multiple worksheets, all of which can be modified and managed individually. In this video, you will explore how to navigate between worksheets to get the most out of Excel 365. FREE ACCESS
• 7.  Checking spelling in a spreadsheet
  3m 19s
  In Excel 365, you can check the spelling of a cell range, a worksheet, or an entire workbook. You can also ignore or add proper nouns to the spell check dictionary, so they don't get flagged as incorrect. In this video, you will explore how to access and use the spellcheck tool to correct spelling mistakes or typos in Excel 365. FREE ACCESS
• 8.  Fixing mistakes with AutoCorrect
  4m 31s
  Excel 365 can automatically correct mistyped words as you type, and you can even change these AutoCorrect settings to suit your proofing needs. In this video, you will explore how to use the AutoCorrect tool as well as how to customize its proofing options. FREE ACCESS
• 9.  Performing a Smart Lookup
  2m 59s
  In Excel 365, you can use the Smart Lookup tool to quickly access additional information about words used in your spreadsheets. In this video, you will explore how to use Smart Lookup to find images, definitions, and information on the Web. FREE ACCESS
• 10.  Translating text
  2m 56s
  With Excel 365, you can easily translate text you select into another language. In this video, you will explore how to use the Translate tool in Excel 365. FREE ACCESS
• 11.  Ensuring accessibility
  4m 21s
  Individuals with sight difficulties often use specialized tools such as screenreader software to identify tags and other structural information embedded in a spreadsheet. In this video, you will explore how to check and ensure accessibility of a worksheet in Excel 365. FREE ACCESS