Finding & filtering data in Google Sheets 2022

Google Sheets    |    Intermediate
  • 11 videos | 42m 29s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 22 users Rating 4.5 of 22 users (22)
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

  • Discover the key concepts covered in the finding & filtering data in sheets 2022 course
    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

  • 52s
    This video outlines the key content covered in Finding & Filtering Data in Sheets 2022 course including using the Find and Replace tool, using the advanced filtering options, and grouping data. FREE ACCESS
  • 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
  • Locked
    3.  Using the Find & Replace tools in a formula
    3m 32s
    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
    4.  Sorting the data in your spreadsheet
    4m 45s
    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
    5.  Filtering the data in your spreadsheet
    3m 21s
    Filters allow you to display only the data you want visible 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
    6.  Using the advanced filtering options
    4m 4s
    In Google Sheets, it is possible to filter your data according to certain conditions that can be configured to ensure that only the data you need is displayed. For example, you can filter the data with dates. You can also remove filters to display all of the data in the spreadsheet. FREE ACCESS
  • Locked
    7.  Sorting and filtering data with colors
    3m 32s
    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
    8.  Using filtered views
    5m 5s
    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
    9.  Using slicers
    4m 2s
    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
    10.  Customizing slicers
    3m 43s
    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
    11.  Grouping data
    5m 27s
    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.4 of 37 users Rating 4.4 of 37 users (37)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 4.4 of 167 users Rating 4.4 of 167 users (167)