Finding & filtering data in Google Sheets 2022

Google Sheets 2022    |    Intermediate
  • 11 Videos | 42m 29s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
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

  • Playable
    1. 
    Overview: Finding & filtering data in Sheets 2022
    52s
    UP NEXT
  • Playable
    2. 
    Using the Find & Replace tools
    4m 6s
  • Locked
    3. 
    Using the Find & Replace tools in a formula
    3m 32s
  • Locked
    4. 
    Sorting the data in your spreadsheet
    4m 45s
  • Locked
    5. 
    Filtering the data in your spreadsheet
    3m 21s
  • Locked
    6. 
    Using the advanced filtering options
    4m 4s
  • Locked
    7. 
    Sorting and filtering data with colors
    3m 32s
  • Locked
    8. 
    Using filtered views
    5m 5s
  • Locked
    9. 
    Using slicers
    4m 2s
  • Locked
    10. 
    Customizing slicers
    3m 43s
  • Locked
    11. 
    Grouping data
    5m 27s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 35 Likes 35  
Likes 8 Likes 8