Finding & Grouping Data

Excel Microsoft 365 (Windows)
  • 8 Videos | 40m 50s
  • Includes Assessment
  • Earns a Badge
Likes 129 Likes 129
Learners can explore several methods for locating, displaying, and manipulating data entries in Excel for Office 365, in this 8-video course. First, learn how to use the name box in the Go To tool and Find tool to perform basic search queries in your data. Then learn how to customize the Find tool to make queries more precise. You will learn to use the Selection tools to find and select objects that have been inserted into your worksheet. This course demonstrates how to use the Selection pane to visualize multiple objects. Learners will observe how to use the Replace tool to replace specific items, and how to create a search query, customize replacement parameters, and replace cell formats. You will learn to use the Find & Replace tool, how to use the Freeze pane to check data without opening multiple panes, how to create your own Freeze panes, and how to use the Split view. Finally, you will learn how grouping rows and columns in Excel to summarize data.

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 the Group tools to create Outlines in a worksheet

IN THIS COURSE

  • Playable
    1. 
    Finding items in a worksheet
    5m 52s
    UP NEXT
  • Playable
    2. 
    Using the advanced Find tools
    3m 54s
  • Locked
    3. 
    Using the Selection tools
    3m 50s
  • Locked
    4. 
    Using the Replace tool
    4m 29s
  • Locked
    5. 
    Using the Find & Replace tools with formulas
    4m 9s
  • Locked
    6. 
    Freezing & unfreezing panes
    4m 48s
  • Locked
    7. 
    Grouping items
    5m 40s
  • Locked
    8. 
    Creating outlines
    4m 9s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 704 Likes 704  
Likes 212 Likes 212  
Likes 532 Likes 532  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 71 Likes 71  
Likes 206 Likes 206  
Likes 238 Likes 238