Grab Data Fast with Vertical and Horizontal LOOKUP

4.2

37 個評分

提供方

3,192 人已註冊

在此免費指導項目中,您將:
2 hours
面向初學者
無需下載
分屏視頻
英語(English)
僅限桌面

Data can come our way in multiple forms and from multiple file types. It’s likely that at some point you will be faced with a data set that includes categories and subcategories under one heading or under headings with nested subheadings. Cutting through the file structure can seem like a time-consuming task, so it is critical to leverage VLOOKUP and HLOOKUP to pull out the needed data quickly. In this course you will understand how lookup tables work and apply VLOOKUP and HLOOKUP formulas to quickly extract data by treating a section of your spreadsheet as a lookup table. You will do this as we work side-by-side in the free-to-use software Google Sheets. By the end of this course, you will understand use cases for using vertical and horizontal lookup to extract data when data sets have categories configured with multiple levels. You will also be able to confidently apply VLOOKUP and HLOOKUP formulas to grab data in any spreadsheet software. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

必備條件

您要培養的技能

  • Business Analysis

  • Lookup Tables

  • Data Analysis

  • Extracting Data

  • Efficient Reporting

分步進行學習

在與您的工作區一起在分屏中播放的視頻中,您的授課教師將指導您完成每個步驟:

指導項目工作原理

您的工作空間就是瀏覽器中的雲桌面,無需下載

在分屏視頻中,您的授課教師會為您提供分步指導

授課教師

審閱

來自GRAB DATA FAST WITH VERTICAL AND HORIZONTAL LOOKUP 的熱門評論

查看所有評論

常見問題