|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/essential-excel-formulas-and-functions/
课程评论：没有评论
Coursera 上的 "Essential Excel Formulas and Functions" 课程是一门专注于讲解 Microsoft Excel 公式和函数的核心课程。通过本课程，学员将学习如何高效运用公式和函数，这是提升 Excel 熟练度的关键一步。 课程内容涵盖了构建公式所需的所有不同组件，并提供清晰的演示，讲解相对、混合和绝对引用、美元符号的使用以及如何命名单元格区域以增加公式的清晰度。 此外，课程还将深入探讨 Excel 函数，并通过大量示例展示如何运用函数进行数据分析。入门级函数如 SUM, AVERAGE, MIN 和 MAX 都会被讲解。 接着，课程将重点介绍文本函数，如 TRIM, UPPER, LOWER, PROPER, LEFT, RIGHT, MID 和 CONCATENATE，用于在创建报告前清理数据。 随后，课程将转向条件函数，包括 IF, IFERROR, AND 和 OR，这些函数允许根据逻辑测试的结果来确定单元格的显示值。 之后，学员将学习如何将条件函数与数学函数相结合，例如使用 COUNTIF 和 SUMIF 来执行仅包含符合特定条件的单元格的计算。 最后，课程还将讲解查找函数，包括 VLOOKUP，以及 INDEX 和 MATCH 函数在 VLOOKUP 无法适用的数据格式下的应用。 完成本课程后，学员将能更自信地创建自己的 Excel 公式，并充分利用 Excel 强大的函数功能。该课程最后一次更新于 2017 年 3 月 25 日，并增加了创建发票模型的新项目。
Formulas and functions are at the core Microsoft Excel and learning to use them effectively is an essential step in becoming proficient in Excel. This course provides clear and easy-to-follow instructions on how to build formulas for analysis, projection and data cleansing. The course starts by discussing all of the different components that can be used to create a formula. You will be given clear demonstrations of the use of relative, mixed and absolute references, the use of dollar signs and how to name cell ranges to add clarity to your formulas.Naturally, Excel functions are discussed in depth and many examples of using functions to analyze your data, beginning with every day functions like SUM, AVERAGE, MIN and MAX.We then examine the use of text functions to clean up data prior to creating reports; functions like TRIM, UPPER, LOWER, PROPER, LEFT, RIGHT, MID and CONCATENATE.Next, we turn our attention to conditional functions like IF, IFERROR, AND and OR. These functions allow you to make the value displayed in a cell dependent on the results of logical tests.We then see how conditional functions can be combined with mathematical functions; using COUNTIF and SUMIF to produce calculations which only include those cells which match certain criteria. And, naturally, no discussion of Excel functions would be complete without lookup functions. We discuss the use of VLOOKUP and, also, how the INDEX and MATCH functions can be used to lookup up data whose format makes the use of VLOOKUP impossible. When you have completed this course, you will feel more confident about creating your own Excel formulas and taking advantage of Excel's wide variety of powerful functions. This course was last updated on 25th March 2017, with the addition of a new project: the creation of an invoicing model.
