Finding Data in Google Sheets
Offered By: Google via Google Cloud Skills Boost
Course Description
Overview
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
Excel 2010Miríadax Intro to Data Science
Udacity Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera Statistical Computing with R - a gentle introduction
University College London via Independent Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera