Excel 2019 includes a number of methods for locating, displaying, and manipulating data entries. In this 8-video course, learners observe how to work with specific data using the Find and Replace tools, and manipulate data with the Group and Outline tools. Begin by learning how to find items in a worksheet, by using the Find tools to jump to locations in a worksheet and find items with basic search queries. Then learn how to use advanced Find tools to customize and refine search queries; the Selection tools to locate and select graphical objects in a worksheet; and the Replace tools to replace cell contents and formats. Next, examine how to use the Find and Replace tools when working specifically with formulas, and use the Freeze tools to change the view settings within a worksheet. Finally, observe how to group rows and columns in a worksheet and control their display, and use the Group tools to create Outlines in a worksheet.
Excel 2019: Finding & Grouping Data