|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-advanced-formulas-and-functions/
课程评论：没有评论
Coursera 上的 Microsoft Excel 高级公式和函数课程摘要 本课程专为已具备 Excel 基本操作知识的用户设计，旨在帮助您掌握 Microsoft Excel 的高级公式和函数。我们将从审查基础操作入手，包括 SUM 和 COUNT 函数的语法、函数处理顺序以及故障排除工具。 课程内容将深入探讨扩展公式的使用，涵盖 3D 引用、命名单元格和绝对引用。您将学习如何使用 VLOOKUP 和 HLOOKUP 等查找和引用函数。此外，课程还将介绍生成随机数和值、使用文本函数定位数据，以及学习使用数组公式计算唯一条目。 完成本课程后，您将能够熟练运用 Microsoft Excel 提供的众多高级公式和函数。课程包含配套的工作文件，方便您跟随讲师进行实践学习。
This Microsoft Excel Advanced Formulas and Functions training course from Infinite Skills takes you beyond the basics of Excel, and teaches you how to use the advanced formulas and functions in this spreadsheet program by Microsoft. This course is designed for users that already have a basic working knowledge of Excel. You will begin by reviewing the basic operations, such as sum and count syntax, function processing order, and knowing the troubleshooting tools. You will explore extended formula usage with 3D referencing, naming cells and absolute referencing. Guy proceeds to instruct you on how to look up and reference type functions using VLookup and HLookup. Other features that are covered in this computer based training include; generating random numbers and values, locating data using text functions, and learning to use an array formula to count unique entries. By the completion of this training course, you will be comfortable with using many of the advanced formulas and functions that this powerful spreadsheet software from Microsoft offers. Working files are included, allowing you to follow along with the author throughout the lessons.
