|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-ultimate-guide-to-excel-vlookup/
课程评论：没有评论
**课程名称：Excel 2019：VLOOKUP 函数终极指南** **课程概述：** 本课程将带您从基础到高级，全面掌握 Microsoft Excel 的 VLOOKUP 函数。您不仅能深入理解 VLOOKUP 的各项功能，还将清晰地认识到它的局限性。除了 VLOOKUP，课程还将介绍其他重要的查找函数，如 HLOOKUP、LOOKUP 以及 INDEX MATCH 等。 本课程使用最新的 Excel 2019 版本录制，所有讲解都配有实际案例，并提供可下载的 Excel 文件供您练习。课程还将分享一系列实用的 Excel 技巧，帮助您轻松解决与查找函数相关的种种难题，包括： * 在 VLOOKUP 中使用通配符 * 实现 VLOOKUP 向左查找 * 嵌套 VLOOKUP 技巧 * VLOOKUP 多条件查找 * VLOOKUP 自动更新列号 * 使用 VLOOKUP 替代嵌套 IF 公式 * 实现 VLOOKUP 图片查找而非数据 * 跨相同公式的不同工作表使用 VLOOKUP * 使用 VLOOKUP 实现二维查找 * 使用 VLOOKUP 实现三维查找 * VLOOKUP 多表格查找 * 加速 VLOOKUP 公式性能 * 实现 VLOOKUP 精确匹配的区分大小写查找 * 在 VBA 中使用 VLOOKUP * 处理 VLOOKUP 错误 本课程采用循序渐进的教学方式，即使您仅具备基础的 Excel 和 VLOOKUP 知识，也能轻松掌握所有高级应用。 **立即报名，成为 Excel 查找函数大师！**
Learn Basics to Advanced use of excel VLOOKUP function. This course is on MS Excel VLOOKUP function. In this course, you will learn from basics to advance use of VLOOKUP. Alongwith this you will also understand what you can do and what you can't do with the VLOOKUP function. In addition to VLOOKUP function, you will also learn how to use other LOOKUP functions like, HLOOKUP, LOOKUP, INDEX MATCH, etc.This course is recorded with the latest version of Excel 2019. All the lectures are explained with the examples and you can download all these excel files and practice the formulas. You will also learn below mentioned most important excel tricks which will help you to give easy solutions to problems you face in applying LOOKUP formulas.Use of wildcard in VLOOKUPVLOOKUP to the LeftNested VLOOKUP TrickVLOOKUP Multiple CriteriaVLOOKUP Auto Update Column NumberVLOOKUP to Replace Nested IF FormulaLOOKUP Picture instead of DataVLOOKUP Different Sheets with Same Formula2D LOOKUP with VLOOKUP3D LOOKUP with VLOOKUPVLOOKUP Multiple TablesSpeedup Your VLOOKUP FormulaCase Sensitive LOOKUP for Exact MatchHow to Use VLOOKUP in VBAHandle VLOOKUP ErrorsThe course is presented in an easy to follow step by step approach. Any one with basic excel knowledge and vlookup function can learn all these tricks with the help of this course.Enroll now and take the action to become master in excel LOOKUP!
