Grab Data Fast with Vertical and Horizontal LOOKUP
Completed by Kgotla Ketshabile Ditlhabi
January 21, 2025
2 hours (approximately)
Kgotla Ketshabile Ditlhabi'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: Business Analysis
- Category: Data Import/Export
- Category: Excel Formulas
- Category: Data Analysis
- Category: Data Literacy
- Category: Google Sheets
- Category: Spreadsheet Software
