5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Productivity & Collaboration Tools     Office 365     Excel 365

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.



Objectives

Excel 365: Finding and grouping data

  • 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
  • Knowledge Check: Finding and grouping data in Excel 365