Finding, Sorting & Filtering Data in Google Sheets 2020

IN THIS COURSE

• 1.  Using the Find & Replace tool in Google Sheets 2020
  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
• 2.  Using the Find & Replace tools in a formula in Google Sheets 2020
  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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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