Finding, Sorting, & Filtering Data in Excel 2010 for Windows
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 tool in Excel 2010 for Windows3m 57sUP NEXT
-
2.Using the Replace tool in Excel 2010 for Windows3m 43s
-
3.Using the Find & Replace tools in a formula in Excel 2010 for Windows3m 18s
-
4.Sorting data in a table in Excel 2010 for Windows3m 59s
-
5.Filtering data in a table in Excel 2010 for Windows3m 29s
-
6.Sorting & filtering using colors in Excel 2010 (Windows)3m 11s
-
7.Using the advanced filter options in Excel 2010 for Windows2m 44s
-
8.Hiding duplicate values in Excel 2010 for Windows2m 24s
-
9.Freezing & unfreezing panes in Excel 2010 for Windows2m 42s
-
10.Grouping elements & creating a plan in Excel 2010 for Windows2m 59s
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.