|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/how-to-use-vlookup-in-excel-a-simplest-tutorial/
课程评论:没有评论
**课程名称:** Excel VLOOKUP 函数终极教程——最简单的入门方法 **课程概述:** 本门由 Nurture Tech Academy 推出的 Excel 查找函数视频课程,将以最简洁易懂的方式,带您深入理解 VLOOKUP 函数及其它查找类函数。在本 Excel 训练课程中,您将通过观察讲师实际捛作演示,并跟随其分步讲解,轻松掌握各项功能。课程从理解引用及 Excel 的响应机制入手,随后详细讲解 VLOOKUP 的使用方法,并逐步进阶至 VLOOKUP(精确匹配)、VLOOKUP(近似匹配)、VLOOKUP 与 IF 函数组合、HLOOKUP、LOOKUP 函数,最终整合 INDEX 与 MATCH 函数的应用。学完本在线训练课程后,您将全面掌握 Microsoft Excel 2007/2010/2013 中的所有查找函数,并能在实际商业环境中熟练运用。
In this lookup functionality video course, Nurture Tech Academy introduces you to the most simplest way to understand Vlookup and other lookup functions. In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training starts with understanding references and how excel reacts on the same. Then it will show you how to use Vlookup and then gradually moves to the next level in lookup functionality like Vlookup with False, Vlookup with True, Vlookup with if function, Hlookup, Lookup and ultimately combines Index & Match. By the completion of this online training course, you will be fully versed, and capable of using any function in lookup functionality in Microsoft Excel 2007/2010/2013 in a commercial Environment.