Finding & Grouping Data in Excel 2019 for Windows
Excel 2019 (Windows)
| Intermediate
- 8 videos | 35m 2s
- Includes Assessment
- Earns a Badge
- CPE
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 queriesuse the advanced Find tools to customize and refine search queriesuse the Selection tools to locate and select graphical objects in a worksheetuse the Replace tools to replace cell contents and formats
-
use the Find and Replace tools when working specifically with formulasuse the Freeze tools to change the view settings within a worksheetgroup rows and columns in a worksheet and control their displayuse and configure the Outline tools
IN THIS COURSE
-
1.Finding items in a worksheet in Excel 2019 for Windows5m 26sUP NEXT
-
2.Using the advanced Find tools in Excel 2019 for Windows4m 32s
-
3.Using the Selection tools in Excel 2019 for Windows4m
-
4.Using the Replace tool in Excel 2019 for Windows4m 53s
-
5.Using the Find & Replace tools with formulas in Excel 2019 for Windows3m 45s
-
6.Freezing & unfreezing panes in Excel 2019 for Windows4m 3s
-
7.Grouping items in Excel 2019 for Windows3m 30s
-
8.Creating outlines in Excel 2019 for Windows4m 53s
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.