|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/lookup-functions-and-logical-functions/
课程评论：没有评论
**Excel新手教程：查找函数与逻辑函数** 本课程面向Excel初学者，旨在教授中级公式应用。通过本课程，您将学习如何利用VLOOKUP函数从大型数据表中查找和检索信息，并掌握IFERROR和IFNA函数的使用，以处理数据缺失或错误的情况，确保公式的稳定运行。 **主要学习内容：** * **VLOOKUP函数：** 高效地从Excel数据集中检索信息，包括精确匹配和近似匹配的应用。 * **错误处理函数：** 利用IFERROR和IFNA函数管理和排查数据问题。 * **逻辑函数：** 应用IF、AND和OR函数进行逻辑分析和决策。 **课程亮点：** * **实践性强：** 提供可下载的课程讲师文件和练习文件，方便学员跟随学习和动手实践。 * **视频教学：** 包含78分钟的视频教程，共10个独立视频讲座。 * **全面掌握：** 无论您是Excel新手还是希望巩固基础技能，本课程都能帮助您创建高质量的电子表格。 * **结业证书：** 完成课程后可获得结业证书。 加入我们，提升您的Excel技能！
**This course includes downloadable course instructor files and exercise files to work with and follow along.**Welcome to the Microsoft Excel Beginner course. This short course introduces intermediate formulas for new users of Excel. You will learn how to use the VLOOKUP function to look up and retrieve data from large tables. The course also covers handling errors using the IFERROR and IFNA functions, ensuring your formulas work smoothly even when data is missing or incorrect.Each lesson includes video tutorials and downloadable exercises, ensuring hands-on practice for comprehensive learning.Whether you are taking your first steps into spreadsheet management or seeking to solidify your beginner-level skills, this course will equip you with the skills to create high-quality spreadsheets that meet the needs of your audience. Join us and elevate your Excel proficiency today.In this course, you will learn how to:Efficiently use VLOOKUP to retrieve information from Excel datasets.Execute VLOOKUP with an approximate match for flexible data retrieval.Effectively use error-handling functions to manage and troubleshoot data issues.Apply IF, AND, and OR functions for logical analysis and decision-making.This course includes:78 minutes of video tutorials10 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion
