Grab Data Fast with Vertical and Horizontal LOOKUP
Completed by Khosrow Eghbali Shalamzari
July 27, 2021
2 hours (approximately)
Khosrow Eghbali Shalamzari'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 Import/Export
- Category: Business Analysis
- Category: Data Literacy
- Category: Google Sheets
- Category: Spreadsheet Software
- Category: Data Analysis
- Category: Data Presentation
- Category: Excel Formulas
