Course details

Excel Office 365: Finding & Grouping Data

Excel Office 365: Finding & Grouping Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Excel for Office 365 includes a number of methods for locating, displaying and manipulating data entries. Learn how to work with specific data using the Find and Replace tools, and manipulate data with the Group and Outline tools.



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