Grab Data Fast with Vertical and Horizontal LOOKUP
Data might arrive in a variety of formats and from a variety of file types. It's possible that you'll come into a data collection that has categories and subcategories under a single heading or under headings with nested subheadings at some time. Because cutting through the file structure might be time-consuming, it's vital to use VLOOKUP and HLOOKUP to get the data you need fast.
The Grab Data Fast with Vertical and Horizontal LOOKUP will teach you how to use VLOOKUP and HLOOKUP formulae to rapidly retrieve data from a part of your spreadsheet that has been designated as a lookup table. You'll be able to accomplish this while they collaborate in Google Sheets, a free spreadsheet program. By the end of this course, you'll know how to utilize vertical and horizontal lookup to extract data from data sets that include numerous levels of categories. You'll also be able to use VLOOKUP and HLOOKUP formulae to collect data in any spreadsheet software with confidence.
Note: This course is best suited to students in the North American area. They were working on bringing the same experience to other parts of the world.
THE SKILLS YOU WILL DEVELOP
- Business Analysis
- Lookup Tables
- Data Analysis
- Extracting Data
- Efficient Reporting
LEARN STEP BY STEP:
- Understand how VLOOKUP and HLOOKUP pull data from a spreadsheet and access Google Sheets.
- Identify use cases for VLOOKUP and HLOOKUP.
- Understand and visualize how VLOOKUP and HLOOKUP use a portion of a spreadsheet as a lookup table.
- Identify questions that can be answered and apply VLOOKUP and HLOOKUP.
- Understand best practices for visualizing extracted data and when to combine VLOOKUP with HLOOKUP in a formula.
Rating: 4.2/5
Enroll here: coursera.org/projects/grab-data-fast-with-vertical-and-horizontal-lookup-in-google-sheets
