Finding & Grouping Data

Excel 2019 (Windows)
  • 8 Videos | 47m 2s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 41 Likes 41
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.

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

  • Playable
    1. 
    Finding items in a worksheet
    5m 26s
    UP NEXT
  • Playable
    2. 
    Using the advanced Find tools
    4m 32s
  • Locked
    3. 
    Using the Selection tools
    4m
    FREE ACCESS
  • Locked
    4. 
    Using the Replace tool
    4m 53s
    FREE ACCESS
  • Locked
    5. 
    Using the Find & Replace tools with formulas
    3m 45s
    FREE ACCESS
  • Locked
    6. 
    Freezing & unfreezing panes
    4m 3s
    FREE ACCESS
  • Locked
    7. 
    Grouping items
    3m 30s
    FREE ACCESS
  • Locked
    8. 
    Creating outlines
    4m 53s
    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 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

COURSE Analyzing & Manipulating Data Entries
Likes 6 Likes 6  
COURSE Working with Excel Tables
Likes 212 Likes 212  
COURSE Inserting & Manipulating Data
Likes 71 Likes 71  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Inserting & Manipulating Data
Likes 71 Likes 71  
COURSE Formatting Data
Likes 176 Likes 176  
COURSE Finding & Analyzing Information with Formulas
Likes 44 Likes 44