|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-lookup-and-reference-functions/
课程评论：没有评论
课程名称：精通Excel查找与引用 课程概述：此课程由斯坦福大学开发，现在向您开放。加入我的斯坦福学生，学习如何使您的Excel工作流程焕发活力，超越以往！立即报名，掌握Excel中最重要和最强大的查找与引用功能，超越VLOOKUP的局限，发掘Excel查找功能的全部潜力。 通过学习Excel查找与引用功能，您将能够快速提升工作效率。本课程将教授VLOOKUP、HLOOKUP、INDEX、MATCH、OFFSET和INDIRECT等多个强大功能，帮助您在数据集中创建能自动查找和展示您所需内容的公式。 课程内容包括： - 深入理解VLOOKUP及其潜力，并应用于您的工作流程。 - 学习如何利用MATCH函数与VLOOKUP结合，以获得更优雅的解决方案。 - 掌握INDEX和MATCH的灵活运用。 - 发现使用鲜为人知的INDIRECT函数高效整合数据的技巧。 - 通过OFFSET函数激发创意。 完成本课程后，您将能够： - 识别查找与引用在您特定工作流程中的价值。 - 充分利用VLOOKUP、HLOOKUP、INDEX、MATCH、TRANSPOSE和INDIRECT等Excel功能。 - 为Excel仪表板创建具有下拉列表的灵活查找。 - 将详细数据附加到大型数据集。 - 创建基于范围的查找，支持“近似匹配”。 - 使用“精确匹配”查找特定项目。 - 通过结合VLOOKUP和MATCH进行二维查找。 - 使用命名范围和Excel表格作为参考列表。 - 从“秘密”表格中查找数据。 - 通过使用INDEX和MATCH克服VLOOKUP的局限性。 - 利用OFFSET函数创建自动扩展的引用。 - 使用INDIRECT函数整合来自多个工作表的数据。 - 使用TRANSPOSE函数将数据旋转90度，并链接到原始单元格。 本课程将激发您的创意，提升您的Excel技能，报名后立即开始学习！
I've developed this course for Stanford University. Now, it's finally available to you as well. Join my Stanford students and learn, so that you too can invigorate and dominate your Excel workflow better than ever before!Enroll now and master Excel's most important and powerful lookup-and-reference functions. Propel your skills beyond VLOOKUP and discover the full power and hidden potential of Excel lookups.Few things can transform your Excel workflow faster than tapping into the true power of Excel lookup-and-reference functions. Learn VLOOKUP, HLOOKUP, INDEX, MATCH, OFFSET, INDIRECT to immediately skyrocket your skills to a higher orbit.This course will demonstrate what you need to know about these amazing Excel tools, covering how to create powerful formulas that automatically find and display exactly what you want in your datasets.First, you'll master the venerable VLOOKUP and its remarkable potential, and how you can apply it to your workflow.Then you'll move on to more elegant solutions: discover the MATCH function and the benefit of combining it with VLOOKUP.Next, you'll learn how to take advantage of INDEX and MATCH for ultimate flexibility.Plus, discover more efficient ways to consolidate data with the little-known INDIRECT function and tickle your creativity with the esoteric OFFSET function.After completing this hands-on training program, you'll be able to:Recognize the value of lookups and references to your specific workflowTake the full advantage of the following Excel functions: VLOOKUP, HLOOKUP, INDEX, MATCH, TRANSPOSE, and INDIRECTCreate flexible lookups for Excel dashboards with drop-down listsAppend detailed data to large datasetsCreate range-based lookups with the "approximate match"Find specific items using the "exact match"Create two-dimensional lookups by combining VLOOKUP and MATCHUse named ranges and Excel tables as reference listsLookup data from a "secret" tableOvercome the limitations of VLOOKUP by using INDEX and MATCHCreate automatically-expanding references with the OFFSET functionConsolidate data from multiple sheets with the INDIRECT functionUse TRANSPOSE function to flip your data 90 degrees with links to the original cellsAnd so much moreThis course will tickle your creativity and boost your Excel skills like nothing else.Enroll now, so you can begin to learn immediately!
