|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dynamic-arrays-in-excel/
课程评论：没有评论
**动态数组在Excel中的应用** 本课程专为具备高级Excel知识的用户设计，旨在教授Excel 365中的动态数组功能，帮助您简化工作流程并节省大量时间。 **课程亮点：** * **核心功能介绍：** 深入学习Excel 365中强大的动态数组函数，包括XLOOKUP、FILTER、UNIQUE、SORT、SORTBY、SEQUENCE和RANDARRAY。 * **实际应用解析：** 理解这些新函数如何解决实际问题，提升数据处理效率。 * **循序渐进的学习：** 通过详细的步骤讲解，您可以随时暂停或回放视频，确保完全掌握各个概念和函数。 * **内容概览：** 课程共包含5个教学视频，总时长约55分钟，所有视频均提供英文字幕。 **为什么选择本课程？** 如果您已经是Excel高级用户，并希望利用Excel的进阶功能提升工作效率，那么本课程将是您的理想选择。通过掌握动态数组，您将能够更轻松地处理复杂的数据任务。 **先修要求：** * 具备扎实的Excel基础知识。 * 确保您使用的是Microsoft Excel 365或Excel 2021版本，因为动态数组功能仅在此版本及其后续版本中可用。
COURSE DESCRIPTIONIn this course you will discover helpful dynamic array formulas in Excel 365. Learn about the exciting new functions XLOOKUP, FILTER, UNIQUE, SORT, SORTBY, SEQUENCE and RANDARRAY. Understand which problems you can easily solve thanks to the new functions.THIS COURSE IS SUITABLE FOR YOU, IF· you already have advanced knowledge in Excel· you wish to take advantage of some of the higher-level functionality in ExcelPREREQUISITES· This training has been designed and built for advanced Excel users. In order to complete this training successfully, you should have sufficient knowledge of Excel.· Dynamic arrays are only available in Microsoft Excel 365 (and Excel 2021). Please make sure you have an appropriate subscription model or license.METHOD· Your trainer will guide you through the various concepts and functions in an easy-to-understand, step-by-step manner. If necessary, you can pause videos or even rewind and watch them again.COURSE OBJECTIVESUpon successful completion of this course, you will be able to leverage the power of dynamic arrays in order to simplify your work and save a lot of time. The following functions are covered in this course:· XLOOKUP· FILTER· UNIQUE· SORT· SORT BY· SEQUENCE· RANDARRAYTRAINING SCOPE5 Training Videos (Run time: 55 minutes)The trainer will introduce you to the topics and then explain the functions in Excel step by step. All training videos have English subtitles.
