YoVDO

Finding Data in Google Sheets

Offered By: Google via Google Cloud Skills Boost

Tags

Google Sheets Courses Data Analysis Courses Data Manipulation Courses VLOOKUP Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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.

Syllabus

  • GSP1063
  • Overview
  • Setup and requirements
  • Task 1. Manipulate data
  • Task 2. Find and replace data
  • Task 3. Retrieve data using VLOOKUP and QUERY
  • Task 4. Use VLOOKUP with IF and ISERROR
  • Congratulations!

Tags

Related Courses

Análisis de datos: Llévalo al MAX()
Delft University of Technology via edX Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Data Processing and Analysis with Excel
Rochester Institute of Technology via edX Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera