Finding, Sorting & Filtering Data in Google Sheets 2020

Google Sheets 2020    |    Intermediate
  • 10 videos | 37m 32s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 15 users Rating 4.4 of 15 users (15)
There are times you may only want to work with particular data in a spreadsheet. Discover how to use the Google Sheets tools to easily find and replace data. You will also learn how to sort your data and use filters to display only the data you need. Google Sheets includes other advanced options for sorting and filtering data with colors and conditions. In this course, you will discover other tools for filtering your data, such as filter views and slicers. Finally, learn how to group and ungroup your data to choose the information you want to display.

WHAT YOU WILL LEARN

  • Find and replace data in a spreadsheet
    Find and replace functions in formulas
    Sort data in a spreadsheet
    Apply filters in a spreadsheet
    Use advanced filter options in a spreadsheet
  • Sort and filter data using colors
    Create and manage filter views
    Add slicers to filter your data
    Customize slicers colors and formats
    Group and ungroup data in a spreadsheet

IN THIS COURSE

  • 4m 6s
    The Find and Replace tools are extremely useful for locating specific data entries in your spreadsheet. They can also be used to automatically replace certain occurrences, including dates, names, or figures. FREE ACCESS
  • 3m 14s
    In Google Sheets, you can find and replace contextual data, but you can also use the find and replace feature to modify formulas. Once you locate and replace a function, the corresponding formula will be updated and the value in the cell will also be modified. FREE ACCESS
  • Locked
    3.  Sorting the data in your spreadsheet in Google Sheets 2020
    4m 17s
    The sort function in Google Sheets allows you to reorganize, but not hide, the data contained in your columns. Using Google Sheets, you can sort your data alphabetically, both in descending and ascending order. You can also combine multiple sort criteria. FREE ACCESS
  • Locked
    4.  Filtering the data in your spreadsheet in Google Sheets 2020
    2m 51s
    Filters allow you to display only the data you want to see in a spreadsheet. By choosing different filter criteria, you can streamline the data in your spreadsheet and ensure that you only have the information you really need. FREE ACCESS
  • Locked
    5.  Using the advanced filtering options in Google Sheets 2020
    2m 58s
    With the newest version of Google Sheets, it is possible to filter your data according to certain conditions that can be configured to ensure that you see only the data you need. FREE ACCESS
  • Locked
    6.  Sorting and filtering data with colors in Google Sheets 2020
    2m 24s
    If you have applied color-coding to various data entries in your spreadsheet, you can use these codes to sort and filter your data in Google Sheets. You might, for example, only want to visualize the values that have been highlighted in red or any other color applied to data or cells. FREE ACCESS
  • Locked
    7.  Using filtered views in Google Sheets 2020
    4m 26s
    Using the filter views option in Google Sheets, you can create and save different filters that can be applied to your document. If you are working alongside a collaborator, you can each view the document with different filter views applied at the same time. FREE ACCESS
  • Locked
    8.  Using slicers in Google Sheets 2020
    3m 53s
    Slicers in Google Sheets can be used to filter and manipulate the data stored in a sheet. They are a good alternative to filters as they give users a clear visual guide as to the contents being displayed in a table and their qualifying criteria. FREE ACCESS
  • Locked
    9.  Customizing slicers in Google Sheets 2020
    4m 35s
    Slicers are highly visual and a great way for visually communicating how data in a sheet is being manipulated or filtered in Google Sheets. You can customize the appearance of your slicer by selecting different font options, applying colors and modifying text alignment options. FREE ACCESS
  • Locked
    10.  Grouping data in Google Sheets 2020
    4m 48s
    Grouping rows and columns in Google Sheets is a great way of summarizing data and adding structure to your sheets. You can create multiple groups, across rows and columns, and collapse and hide them to control the amount of data you see. 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 27 users Rating 4.5 of 27 users (27)
Rating 4.6 of 50 users Rating 4.6 of 50 users (50)
Rating 4.4 of 22 users Rating 4.4 of 22 users (22)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 167 users Rating 4.4 of 167 users (167)
Rating 4.1 of 37 users Rating 4.1 of 37 users (37)
Rating 4.5 of 24 users Rating 4.5 of 24 users (24)