Finding and grouping data in 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. In order to practice what you have learned you will find practice exercises and samples in the Resources section.