Finding, Sorting & Filtering Data in Excel 2016 for Windows

Excel 2016 (Windows)    |    Intermediate
  • 11 videos | 45m 50s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 214 users Rating 4.5 of 214 users (214)
Excel 2016 includes a number of methods for locating and displaying only certain entries. Learn how to work with specific data using the Find and Replace tools, sorting and filtering, hiding duplicates, and grouping.

WHAT YOU WILL LEARN

  • Using the find tool
    Using the replace tool
    Using the find & replace tools in a formula
    Sorting your data
    Filtering your data
    Sorting & filtering using colors
  • Using slicers in tables
    Using the advanced filter options
    Hiding duplicate values
    Freezing & unfreezing panes
    Grouping items & creating an outline

IN THIS COURSE

  • 5m
    If you're looking for a particular value or data entry in your spreadsheet, you can use the Find tools. In Excel 2016, you can even search for items using formatting effects that have been applied to your data entries. FREE ACCESS
  • 4m 8s
    The Replace tool makes it easy to make quick changes to your data, like replacing a repeated typo or the accidental capital or lower case letter. FREE ACCESS
  • Locked
    3.  Using the Find & Replace tools in a formula in Excel 2016 for Windows
    2m 48s
    The Find and Replace functions in Excel 2016 can be used to change the way in which a particular formula is calculated. As long as the arguments in your formula remain the same, you can quickly change one or all of your worksheet's formulas from one calculation to another, thereby modifying the way in which you analyze your data. FREE ACCESS
  • Locked
    4.  Sorting your data in Excel 2016 for Windows
    4m 59s
    The Excel 2016 sort options can be used to organize and order the data in your table. You can specify the criteria that you use: you can, for example, sort a data range using alphabetical order or from smallest to largest value. You can even apply multiple sort criteria to group your data in different ways. FREE ACCESS
  • Locked
    5.  Filtering your data in Excel 2016 for Windows
    4m 42s
    In Excel 2016, you can choose to show or hide different types of data. This is known as filtering. If you do not need a particular category of data values, or if you want to focus on a specific data group, you can use the filter tools. You can specify data ranges to exclude, or indicate the value that you want to visualize. You can use the filter tools to gradually refine your search and concentrate on the values you need. FREE ACCESS
  • Locked
    6.  Sorting & filtering using colors in Excel 2016 for Windows
    3m 9s
    If you have applied color coding to various data entries in your table, you can use these codes to sort and filter your data. You might, for example, want to visualize only the values that have been highlighted in red. This is just one more way of filtering and sorting your data in Excel 2016. FREE ACCESS
  • Locked
    7.  Using slicers in tables in Excel 2016 for Windows
    6m 8s
    Slicers can be used to filter the data in your Excel 2016 tables. You can combine different slicers to apply multiple filters to your data table. You can also customize the appearance of your slicer using text styles. FREE ACCESS
  • Locked
    8.  Using the advanced filter options in Excel 2016 for Windows
    3m 49s
    In Excel 2016, you can create advanced filter criteria using a separate table. Once you have defined your criteria, you can launch the filter by defining your data range and selecting the cells you want to use as criteria. These criteria cells can be combined as much as you want to create powerful filter operations. You are however going to need to know how to construct the criteria that you want to use. FREE ACCESS
  • Locked
    9.  Hiding duplicate values in Excel 2016 for Windows
    2m 3s
    Excel 2016 features an advanced filter tool that can be used to temporarily hide any duplicates that have been added to your data table. All you need to do is select the data range to be filtered and the location of your table. FREE ACCESS
  • Locked
    10.  Freezing & unfreezing panes in Excel 2016 for Windows
    4m 23s
    If you want to keep an eye on certain data values, columns or rows in Excel 2016, you can use the freeze function. This allows you to freeze in place a particular section of your worksheet. You can then work on a different data entry while at the same time keeping an eye on the frozen section. There are a number of different ways of freezing your spreadsheet in Excel 2016. FREE ACCESS
  • Locked
    11.  Grouping items & creating an outline in Excel 2016 for Windows
    4m 41s
    If your Excel 2016 table is particularly large, you may find it useful to know how to create groups to manage your data entries. Creating groups allows you to show or hide different data entries, leaving you free to concentrate on a particular section of your table. FREE ACCESS

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.

YOU MIGHT ALSO LIKE

Rating 4.5 of 449 users Rating 4.5 of 449 users (449)
Journey Microsoft Excel
Rating 2.8 of 4 users Rating 2.8 of 4 users (4)
Rating 4.0 of 6 users Rating 4.0 of 6 users (6)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 106 users Rating 4.6 of 106 users (106)
Rating 4.4 of 1162 users Rating 4.4 of 1162 users (1162)
Rating 4.4 of 62 users Rating 4.4 of 62 users (62)