Finding & Grouping Data in Excel 2019 for Windows

Excel 2019 (Windows)    |    Intermediate
  • 8 videos | 35m 2s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 482 users Rating 4.5 of 482 users (482)
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. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Finding & Grouping Data Exercise as well as the associated materials in the Resources section.

WHAT YOU WILL LEARN

  • Use the find tools to jump to locations in a worksheet and find items with basic search queries
    Use the advanced find tools to customize and refine search queries
    Use the selection tools to locate and select graphical objects in a worksheet
    Use the replace tools to replace cell contents and formats
  • Use the find and replace tools when working specifically with formulas
    Use the freeze tools to change the view settings within a worksheet
    Group rows and columns in a worksheet and control their display
    Use and configure the outline tools

IN THIS COURSE

  • 5m 26s
    Excel offers a variety of different tools for finding different types of data in your worksheet. You can use the Name Box and Go To tools to jump quickly to locations and specific elements, and the Find tool to perform basic search queries on your data. FREE ACCESS
  • 4m 32s
    The Find tools in Excel can be customized to make your search queries more precise. See how to activate the advanced options, search for specific data formats, and customize the search behavior and range. FREE ACCESS
  • Locked
    3.  Using the Selection tools in Excel 2019 for Windows
    4m
    The Selections tools in Excel can help you find and select objects that have been inserted into your worksheet. See how to open and use the Selection Pane and how to select objects quickly in Excel. FREE ACCESS
  • Locked
    4.  Using the Replace tool in Excel 2019 for Windows
    4m 53s
    The Replace tools are a great way of finding and replacing specific terms in your worksheet. See how to create a search query, customize your replacement parameters, and replace cell formats. FREE ACCESS
  • Locked
    5.  Using the Find & Replace tools with formulas in Excel 2019 for Windows
    3m 45s
    Your search queries can be customized to look at values or formulas. This can have a big impact on how successful your query is, and whether you find the result that you are looking for. FREE ACCESS
  • Locked
    6.  Freezing & unfreezing panes in Excel 2019 for Windows
    4m 3s
    Freeze panes and ranges in your Excel worksheet to keep an eye on data and track more easily what you are viewing, without opening multiple windows. You'll see how to use the preset Freeze tools, how to create your own Freeze panes, and how to use the Split view. FREE ACCESS
  • Locked
    7.  Grouping items in Excel 2019 for Windows
    3m 30s
    Grouping rows and columns in Excel is a great way of summarizing data and adding structure to your data tables. You can create multiple groups, across rows and columns, and collapse and hide them at will to control the amount of data you see at any one time. FREE ACCESS
  • Locked
    8.  Creating outlines in Excel 2019 for Windows
    4m 53s
    The Group tools in Excel can be used to create Outlines of your data. Excel can analyze your data tables and, if they are clearly structured, automatically create outlines and groups. See how to use and configure the Outline tools in Excel. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.6 of 416 users Rating 4.6 of 416 users (416)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 4.5 of 449 users Rating 4.5 of 449 users (449)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 327 users Rating 4.5 of 327 users (327)
Rating 4.6 of 336 users Rating 4.6 of 336 users (336)
Rating 4.6 of 785 users Rating 4.6 of 785 users (785)