Excel Office 365: Finding & Grouping Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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.



Expected Duration (hours)
0.6

Lesson Objectives

Excel Office 365: Finding & Grouping Data

  • 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
  • Course Number:
    ds_msex365_09_enus

    Expertise Level
    Intermediate