Finding, Sorting & Filtering Data in Google Sheets 2020

Google Sheets 2020    |    Intermediate
  • 10 Videos | 37m 32s
  • Includes Assessment
  • Earns a Badge
Likes 8 Likes 8
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

  • Playable
    1. 
    Using the Find & Replace tool in Google Sheets 2020
    4m 6s
    UP NEXT
  • Playable
    2. 
    Using the Find & Replace tools in a formula in Google Sheets 2020
    3m 14s
  • Locked
    3. 
    Sorting the data in your spreadsheet in Google Sheets 2020
    4m 17s
  • Locked
    4. 
    Filtering the data in your spreadsheet in Google Sheets 2020
    2m 51s
  • Locked
    5. 
    Using the advanced filtering options in Google Sheets 2020
    2m 58s
  • Locked
    6. 
    Sorting and filtering data with colors in Google Sheets 2020
    2m 24s
  • Locked
    7. 
    Using filtered views in Google Sheets 2020
    4m 26s
  • Locked
    8. 
    Using slicers in Google Sheets 2020
    3m 53s
  • Locked
    9. 
    Customizing slicers in Google Sheets 2020
    4m 35s
  • Locked
    10. 
    Grouping data in Google Sheets 2020
    4m 48s

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 35 Likes 35  
Likes 2025 Likes 2025