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.
Overview
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!