Finding, Sorting, & Filtering Data
Excel 2010 (Windows)
| Intermediate
- 10 Videos | 32m 24s
- Earns a Badge
In large spreadsheets, it is not always easy to locate the data you need. Discover the tools in Excel to find, replace, sort, and filter data. Also, learn how to create an outline, freeze panes, and hide duplicate values.
WHAT YOU WILL LEARN
-
Using the Find toolUsing the Replace toolUsing the Find & Replace tools in a formulaSorting data in a tableFiltering data in a table
-
Sorting & filtering using colorsUsing the advanced filter optionsHiding duplicate valuesFreezing & unfreezing panesGrouping elements & creating a plan
IN THIS COURSE
-
1.Using the Find tool3m 57sUP NEXT
-
2.Using the Replace tool3m 43s
-
3.Using the Find & Replace tools in a formula3m 18s
-
4.Sorting data in a table3m 59s
-
5.Filtering data in a table3m 29s
-
6.Sorting & filtering using colors3m 11s
-
7.Using the advanced filter options2m 44s
-
8.Hiding duplicate values2m 24s
-
9.Freezing & unfreezing panes2m 42s
-
10.Grouping elements & creating a plan2m 59s
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.