|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complex-excel-formulas-and-vba-user-defined-functions/
课程评论：没有评论
**课程名称：** 高级 Excel 公式与 VBA 用户定义函数 **课程概述：** 本课程专为有一定 Excel 基础的用户设计，旨在帮助您掌握创建、理解和维护复杂 Excel 公式。课程将深入讲解如何将多个函数组合使用，并提供易于理解的解释性图表（PDF格式）以及分行缩进的书写方式，以简化复杂公式的可读性。 课程内容涵盖： * **条件函数：** 学习最灵活的条件函数。 * **文本和数字操作公式：** 掌握处理文本和数字的强大公式。 * **复杂查找公式：** 学习执行复杂查找操作的方法。 * **数组公式：** 探索数组公式的应用。 * **XML 数据导入：** 学习从网页和本地 XML 文档导入数据的公式。 * **VBA 用户定义函数（UDF）：** 专注于创建无法通过内置函数实现的独特 VBA 函数，例如获取用户登录名、工作表名称列表或文件所在文件夹信息。 本课程将引导您构建“超级公式”，甚至几十行长的公式，并重点提供无法通过 Excel 内置功能实现的 VBA 用户定义函数的开发策略，从而极大地增强您的 Excel 解决方案能力。如果您正在寻找一门富有挑战性的课程，来提升您创建强大、复杂 Excel 公式的能力，那么这门课程将是您的理想选择。
(Please note that this course is designed for experienced Excel users. If you are still shaky on the basics of Excel formulas, have a look at the Udemy course "Essential Excel Formulas and Functions". ) The ability to write, understand and maintain complex formulas is the key to mastering Excel. Complex formulas make use of multiple functions to achieve a specific operation; and it is the need to nest one function inside another that can sometimes make Excel formulas seem so impenetrable. This course will show you how to create, comprehend and maintain complex Excel formulas; those which use multiple Excel functions in combination. A key feature of the course is the use of explanatory diagrams. The course features dozens of diagrams saved in PDF format. You will have access to all of these diagrams. You can study them at your leisure. You can print them out; make notes on them; whatever you find useful. Another key feature of the course is that we write our formulas on multiple lines and make strategic use of indentation. This makes it easier to read complex formulas, since it helps to make it clear when one function is nested inside another. We'll also encounter examples of using formulas to build formulas; mega formulas, sometimes dozens of lines long, which would be very hard to write manually. We begin the course by looking at conditional functions, since these are the most versatile of Excel's functions. Then we'll move on to look at building formulas for manipulating text; for manipulating numbers; formulas for performing complex lookup operations. And we'll also discuss the use of array formulas; as well as formulas for importing XML-based information into Excel, both from the web and from local XML documents. And finally, we'll move on to look at the creation of custom, user-defined functions using VBA. These functions can be included in any workbook and can greatly enhance your Excel solutions. Many courses which teach Excel user-defined functions will waste your time by showing you how to create VBA functions which replicate functionality which could be created by regular Excel formulas. Not on our course! We'll focus on writing VBA functions which provide results that simply can't be produced using Excel's own built-in functions: for example displaying the user's Windows login name, or the names of all the worksheet tabs; or displaying information from the folder in which a workbook is saved. So, if you're looking for a challenging course which will provide you with strategies for creating powerful and complex Excel formulas, then this course is exactly the course you need: "Complex Excel Formulas and VBA user-defined functions".
