Finding and grouping data in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 7 videos | 23m 4s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.6 of 385 users Rating 4.6 of 385 users (385)
Excel 365 includes several methods for locating and arranging data entries into groupings. In this course, you will learn how to use the Find and Replace tools when working with specific-data, and use the Group and Outline tools to manipulate data. To start, you will explore how to jump to specific locations in a worksheet and find items with basic search queries using the Find tools. Then you will learn how to use the advanced Find tools to customize and refine search queries, including how to use the Find and Replace tools when working specifically with formulas. Finally, you will explore how to replace cell contents and formats using the Replace tools, observe how to group rows and columns in a worksheet, control their display, and use the Group tools to create outlines. 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: finding and grouping data in excel 365 course
    Search within an excel 365 worksheet
    Use the find and replace tool with formulas in excel 365
    Use the replace tool in excel 365
  • Use the advanced find tools in excel 365
    Group items in excel 365
    Create outlines to group content in excel 365

IN THIS COURSE

  • 56s
    This video outlines the key content covered in the Microsoft 365: Finding and grouping data in Excel 365 course, including how to search within a worksheet, use the Find and Replace tools and how to create outlines to group content. FREE ACCESS
  • 4m 19s
    Excel 365 has a variety of different tools to easily navigate a worksheet, such as the Name Box, Go To, and Go To Special tools. The Find and Replace tool can also be used to search for keywords. In this video, you will explore how to search within an Excel 365 worksheet. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.2.1 Search for data within a workbook as well as MOS MO-200 / Excel Associate Certification exam objective: 1.2.2 Navigate to named cells, ranges, or workbook elements. FREE ACCESS
  • Locked
    3.  Using the Find and Replace tool with formulas
    2m 33s
    Excel 365 search queries can be customized to find values or formulas. Using the advanced options, these formulas can then be substituted. In this video, you will explore how to use the Find and Replace tool with formulas in Excel 365. FREE ACCESS
  • Locked
    4.  Using the Replace tool
    4m 23s
    If data values are entered incorrectly in Excel 365, they can easily be substituted. Each entry can be replaced individually or you change them all at once. In this video, you will discover how to use the Replace tool in Excel 365. FREE ACCESS
  • Locked
    5.  Using the advanced Find tools
    3m 3s
    The Excel 365 Find tools can be customized to improve your search queries. In this video, you will explore how to use the advanced Find tools in Excel 365 to narrow down the search criteria and search for a specific format. FREE ACCESS
  • Locked
    6.  Grouping items
    4m 3s
    Grouping rows and columns in Excel 365 is a great way to summarize data and add structure to data tables. You can even create groups according to subtotals. In this video, you will discover how to group and ungroup items, create subgroups, and hide and expand groups in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 2.2.3 Group and ungroup data. FREE ACCESS
  • Locked
    7.  Creating outlines to group content
    3m 48s
    Auto Outline in Excel 365 helps with the analysis of data by allowing you to group content. The appearance of the outline can even be adjusted to suit your preferences. In this video, you will explore how to create outlines to group content 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 4.9 of 7 users Rating 4.9 of 7 users (7)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 4.5 of 319 users Rating 4.5 of 319 users (319)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 449 users Rating 4.5 of 449 users (449)
Rating 4.4 of 201 users Rating 4.4 of 201 users (201)
Rating 4.4 of 282 users Rating 4.4 of 282 users (282)