Finding and grouping data in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 7 Videos | 39m 55s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
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.

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

  • Playable
    1. 
    Course Overview: Finding and grouping data in Excel 365
    1m 2s
    UP NEXT
  • Playable
    2. 
    Searching within a worksheet
    5m 55s
  • Locked
    3. 
    Using the Find and Replace tool with formulas
    3m 25s
  • Locked
    4. 
    Using the Replace tool
    5m 54s
  • Locked
    5. 
    Using the advanced Find tools
    4m 7s
  • Locked
    6. 
    Grouping items
    5m 24s
  • Locked
    7. 
    Creating outlines to group content
    5m 9s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 67 Likes 67  
COURSE Managing Data
Likes 112 Likes 112