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: Data Presentation
- Category: Data Literacy
- Category: Data Analysis
- Category: Google Sheets
- Category: Spreadsheet Software
- Category: Business Analysis
- Category: Excel Formulas
- Category: Data Import/Export
