|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dynamic-array-per-microsoft-excel-365-le-nuove-funzioni/
课程评论：没有评论
**课程名称:** Excel专业人士：Microsoft Excel 365 的动态数组 **课程概述:** 本课程专为已具备Excel基础，并希望深入了解Microsoft 365最新创新功能的学员设计。课程重点介绍动态数组公式，以及LET和LAMBDA函数等高级编程功能。通过视频和指导性练习，学员将掌握Excel 2021和365版本中的主要高级特性，从而更高效地处理电子表格。 **先修要求:** * peserta yang menghadiri kursus ini mesti mempunyai Excel versi 365 atau 2021. Versi sebelum ini tidak menyokong ciri-ciri inovatif yang dibincangkan dalam kursus ini. **主要学习内容:** * 动态数组的理论与实践 * 表格的重要性 * UNIQUE、SORT（排序）及 “#” 引用（ Spill Range Operator） * 动态下拉菜单 * FILTER (筛选) 函数 * XLOOKUP (跨工作表查询) 函数及其进阶应用 * TRANSPOSE (转置) 函数 * CHOOSC0L (选择列) 函数及反斜杠 (\) 用法 * 排序范围内的数字 * SEQUENCE (序列) 和 RANDMATR (随机矩阵) 函数 * STACK.VERT（垂直堆叠）和 STACK.HORIZ（水平堆叠）函数 * TEXTSPLIT （文本拆分）函数 * READ （读取）函数 * LAMBDA 函数 **课程目标:** 学员将能够熟练运用Excel 365的最新功能，提升数据处理和分析的效率与灵活性。
Do you already have an excellent level of Excel but would like to learn more?Maybe discovering all the great innovations brought by Microsoft 365 including the new Dynamic Array formulas and the let and lambda programming ones? Then this is the course for you! Sign up now to start your learning journey!Excel has revolutionized the way you work on your spreadsheets, making the experience much more efficient in the latest versions (2021 and 365). I will guide you to discover the main advanced features of Excel through videos and guided exercises.So, what are we waiting for? I am waiting for you!NB: to follow this course you must have Excel version 365 or 2021. Versions prior to these do not support the innovative features covered by this course.Subjects:Thanks and some information before startingDynamic Array practical demonstrationThe world of Dynamic ArraysThe importance of tablesUnique Function, DataSort and "#"Dynamic drop-down menusFilter functionXLookupTransposed MatrXLookup: further information2nd Example3rd ExampleXLookupFilter function in-depth analysisChoose Col - BackslashFilter ranges of numbersExample with TransposeUniqueSortSort bySequenceRandom matrA ColStack Vert - Stack OrizSplit textRead functionLambda function
