|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-vlookup-match-cell-referencing-if-discussion/
课程评论：没有评论
Excel基础到超级进阶培训第一部分（13小时） 本课程面向所有想学习Excel的用户，提供长达9小时以上的深度内容，全面深入讲解Excel的各个方面。 课程从Excel基础概念开始，包括单元格、行、列、地址栏、公式和常量、名称框、快捷键等。 重点讲解Excel中最常用、最强大的函数，包括： * **VLOOKUP函数**：详细介绍其用法、规则、局限性、优点，以及如何在单个工作表、跨工作表、跨工作簿中使用VLOOKUP。课程还将解决VLOOKUP中的常见问题，如查找值重复、查找值不唯一等，并展示如何结合常量、辅助列/行以及MATCH函数使用VLOOKUP。 * **MATCH函数**：讲解其独立使用方法及其重要性，并将其与VLOOKUP结合，实现“VLOOKUP with MATCH Magic”。 * **IF函数**：包含基础IF、IF AND、IF OR以及嵌套IF（超级进阶级别）。课程将演示IF与VLOOKUP、MATCH的结合使用，以及MATCH与IF的组合。还会介绍2021年推出的新IF函数，并对比其与旧版IF函数的区别。 * **XLOOKUP函数**：作为Excel 365中的新查找函数，将进行深度讲解，让您爱上这个新的查找工具。 * **错误处理函数**：深入讲解IFERROR、ISERROR、MID、LEFT、RIGHT、INDEX、MATCH等函数，并展示它们之间以及与其他函数的各种实际项目中的组合应用。 * **INDEX函数**：解释为何INDEX优于VLOOKUP，以及INDEX如何实现VLOOKUP无法达到的结果。课程会探讨INDEX的数据选择方式（全部数据或选择性数据），以及在行列参数为空时会发生什么。 * **布尔函数**：介绍布尔函数及其在解决复杂数据问题中的作用。 * **文本函数**：讲解TEXT函数的用法，以及如何结合使用以满足数据提取需求。 课程还将探讨： * **单元格锁定**：解释为何锁定和解锁单元格很重要，并通过VLOOKUP的实际案例进行演示。 * **错误处理策略**：比较ISERROR和IFERROR，以及如何在真实数据处理中克服IF和IFERROR的混淆，利用错误处理函数实现类似循环的效果，甚至运用多个VLOOKUP。 * **函数组合的无限可能**：重点演示INDEX与MATCH、IFERROR与INDEX、LEFT与INDEX以及IFERROR的各种组合，强调在掌握基础知识后，函数组合的应用没有上限。 * **FIND函数**：讲解FIND函数及其更高级的应用。 课程提供随堂练习文件和大量的进阶级别作业，帮助您巩固所学知识并显著提升Excel技能。课程内容从基础逐步深入到极其进阶的水平，带您体验真实的Excel应用场景，提出“如何”和“为什么”等关键问题，深入探索Excel的强大功能。 **温馨提示**：如果您已经学习过第一系列（Series-1）的VLOOKUP、MATCH、XLOOKUP、IFs和TRIM函数及其组合应用，可以根据需要选择跳过部分内容。
If you thinking of learning Excel - This is the perfect course for you. It has 9 hours plus long duration which means Deep dive into each aspect.We are starting the excel in this program and covering use of $ signs in formulas and also a complete discussion on most used formula in excel Know first the basic terms like Cells, rows, columns, address bar, formula and constants, name box , shortcut keys.How to use Vlookup and what are rules to be followed while using Vlookup. From its limitations to its advantages - Deep disucussionUse vlookup within sheets, across sheets and from different workbooks.Why locking the cells and unlocking is important to learn. Practical example is given using Vlookup.How to sort out issues in Vlookup if Lookup is repeated, What happens if lookup are more than one - Which one to use and Why?Vlookup using constants , using helper columns or rows and finally using Match function.How to use Match function as a standalone and why it is important to learn Match - Vlookup with Match Magic waiting for you,How to use IF Functions including nested IFs. Covering everything about IF - Basic Single IF , IF AND, IF OR and IF inside IF - Nested ones - Super advance levelHow to use IF with Vlookup and match , How to use MATCH with IFs. Practical questions you face in your office. New function IFs which is launched in 2021 - see the difference between new IF and old IFs.Learn how to use new function in Office 365 - XLOOKUP - deep discussion. It is another lookup function and you will love it.You will have assignments also to practice along-with classwork files. Discussion starts from basic level but gradually moving towards extremely advance side. Have a great learning today.Take a deep dive into learning most used and versatile functions in excel like IFERROR, ISERROR, MID LEFT RIGHT INDEX MATCH. Not only know them individually but do see their combinations with one another, i am discussing real projects also so that you can get the real feel about their use practically.How and WHY are the two questions - We keep asking ourselves in this course throughout.Why INDEX is better than VLOOKUP How INDEX helps in achieving the results which VLOOKUP cannot.How to select the data in INDEX - Is it full data or we can be selective in data selection. Which error handler is better? ISERROR or IFERROR.What happens if we leave column or row parameters empty in INDEXWhat are Boolean functions and what is their role in solving the complex dataHow to overcome the confusion of using IF or IFERROR while working with real data.How to take help from these error handlers and make your VLOOKUP work like a loop - How about using 3 or 4 or even more than 4 Vlookups.Learn the use of TEXT Functions and how to get mix them for your data extraction requirement.INDEX with MATCH or IFERROR with INDEX or LEFT function with INDEX and IFERROR - There is no limit to mix the functions if you know fundaments. We are discussing all this one by one by taking practical data points.Use FIND in FIND and even more than that.Classwork files with amazing assignments are available for you. These are mostly adance level questions to give you a great boost in excelif you have not seen SERIES-1 where we studied VLOOKUP , MATCH ,XLOOKUP, IFs and TRIM functions please do so. If you know these functions and their combinations then you may ignore it.
