Finding & filtering data in Google Sheets 2022

IN THIS COURSE

• 1.  Overview: Finding & filtering data in Sheets 2022
  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
• 2.  Using the Find & Replace tools
  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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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