Grab Data Fast with Vertical and Horizontal LOOKUP
Completed by Lahiru Ranasinghe
February 15, 2023
2 hours (approximately)
Lahiru Ranasinghe's account is verified. Coursera certifies their successful completion of Grab Data Fast with Vertical and Horizontal LOOKUP
What you will learn
Understand how VLOOKUP and HLOOKUP pull data from a spreadsheet.
Understand and visualize how VLOOKUP and HLOOKUP use a portion of a spreadsheet as a lookup table.
Understand best practices for visualizing extracted data and when to combine VLOOKUP with HLOOKUP in a formula.
Skills you will gain
- Category: Google Sheets
- Category: Data Analysis
- Category: Data Presentation
- Category: Business Analysis
- Category: Data Literacy
- Category: Spreadsheet Software
- Category: Excel Formulas
- Category: Data Import/Export
