Ten common tools in Excel 365

Excel Microsoft 365 (2021)    |    Beginner
  • 11 videos | 37m 3s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 1331 users Rating 4.5 of 1331 users (1331)
To make the most out of working in Excel 365, you need to know your way around the interface as well as understand some of its frequently-used features. This course will explore how to use the Zoom tools, make selections in your worksheet, and use the various view modes. You will also explore how to navigate between worksheets. In addition, you'll learn how to use the spellcheck tool, and learn more about the AutoCorrect and Smart Lookup features. Finally, you will explore how to translate text and create an accessible document. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this microsoft 365: ten common tools in excel 365 course
    Use the zoom tools in excel 365
    Use the selection tools in excel 365
    Use the view modes in excel 365
    Use various keyboard shortcuts in excel 365
    Navigate between worksheets in excel 365
  • Use the spellcheck tool in excel 365
    Use autocorrect in excel 365
    Use smart lookup in excel 365
    Use the translate tool in excel 365
    Check accessibility in excel 365

IN THIS COURSE

  • 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
  • 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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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

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 3.5 of 57 users Rating 3.5 of 57 users (57)
Rating 4.9 of 7 users Rating 4.9 of 7 users (7)
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)
Rating 4.5 of 310 users Rating 4.5 of 310 users (310)
Rating 4.7 of 3339 users Rating 4.7 of 3339 users (3339)