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

Making Sense of Data
Google via Independent Introduction to Spreadsheets and Models
University of Pennsylvania via Coursera Comptabilité de gestion et pratique du tableur
Université Montpellier 2 via France Université Numerique The Power of Data in Health and Social Care
University of Strathclyde via FutureLearn Digital Media Analytics: Introduction
Purdue University via FutureLearn