Excel Lookup Functions in Depth (2020)
Excel Lookup Functions in Depth (2020)
Electronic Video - 2020
Master some of the most powerful lookup functions in Microsoft Excel, including VLOOKUP, INDEX, XMATCH, and XLOOKUP.
Guardado en:
Holdings -
| Autor Corporativo: | |
|---|---|
| Otros Autores: | |
| Formato: | Electrónico Video |
| Lenguaje: | English |
| Publicado: |
Carpenteria, CA
linkedin.com,
2020.
|
| Materias: | |
| Acceso en línea: | View course details on linkedin.com/learning |
MARC
| LEADER | 00000ngm a22000003i 4500 | ||
|---|---|---|---|
| 001 | LDC2841518 | ||
| 003 | LDC | ||
| 005 | 20241219214934.1 | ||
| 006 | m c | ||
| 007 | cr cna a | ||
| 008 | 241219s2020 cau068 o vleng d | ||
| 040 | |a linkedin.com |b eng | ||
| 050 | 4 | |a LDC2841518 | |
| 100 | 1 | |a Taylor, Dennis |e speaker. | |
| 245 | 1 | 0 | |a Excel: Lookup Functions in Depth (2020). |c with Dennis Taylor |
| 264 | 1 | |a Carpenteria, CA |b linkedin.com, |c 2020. | |
| 306 | |a 01h:08m:47s | ||
| 337 | |a computer |2 rdamedia | ||
| 338 | |a online resource |2 rdacarrier | ||
| 500 | |a 9/11/202012:00:00AM | ||
| 520 | |a Master some of the most powerful lookup functions in Microsoft Excel, including VLOOKUP, INDEX, XMATCH, and XLOOKUP. | ||
| 511 | 1 | |a Presenter: Dennis Taylor | |
| 520 | |a Microsoft Excel offers a variety of powerful lookup functions that allow you to easily retrieve information across spreadsheets. In this course, Excel expert Dennis Taylor demystifies some of the most significant lookup functions. Tune in to learn how to use the new XLOOKUP function, which can handle all the capabilities of the widely used VLOOKUP and HLOOKUP functions, in addition to providing more power and flexibility. Explore uses of the MATCH function and the newer, more robust XMATCH function to match up data, and learn how to extract data using the INDEX function. Discover how to restructure the lists being searched to ensure that you're using each function efficiently, and learn about dynamic array lookup functions like UNIQUE, SORT, SORTBY, and FILTER. Along the way, Dennis shares practical examples that help you grasp how to implement these functions in your workflow. | ||
| 538 | |a Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection. | ||
| 655 | 4 | |a Instructional films. |2 lcgft | |
| 655 | 4 | |a Educational films. |2 lcgft | |
| 710 | 2 | |a linkedin.com (Firm) | |
| 856 | 4 | 0 | |u https://www.linkedin.com/learning/excel-lookup-functions-in-depth-2020?u=95224889&auth=true |z View course details on linkedin.com/learning |
| 092 | |a ONLINE CLASS | ||