Finding, Sorting & Filtering Data

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

YOU MIGHT ALSO LIKE