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
|
