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