Loopskey-logo
Back to content
CourseTechnology

Finding Data in Google Sheets

By External Provider

Price

Free

Go to content

Opens coursera.org in a new tab

Level

INTERMEDIATE

Duration

15 min

About this course

This is a self-paced lab that takes place in the Google Cloud console. Finding specific content in large spreadsheets can be tricky. Learn to manipulate, search and substitute values in Google Sheets using features and functions like VLOOKUP, SUBSTITUTE and QUERY.

What you will learn

  • Manipulate data in Google Sheets using the SPLIT and TRANSPOSE functions.
  • Use the find and replace feature and the SUBSTITUTE function.
  • Use VLOOKUP and modify a QUERY statement.
  • Debug common Google Sheets function errors using IFERROR.