|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-365-advanced/
课程评论：没有评论
**课程名称： Microsoft Excel 365 高级** **课程概述：** 本课程旨在帮助学习者深入掌握 Microsoft Excel 365 的高级功能，全面提升数据分析和工作效率。课程包含可下载的讲师文件和练习文件，方便学习者跟随学习。 **核心内容：** * **动态数组函数：** 学习 SORT、FILTER、XLOOKUP 等函数，高效处理和分析数据，进行数据提取、计数唯一条目，并区分唯一值和不重复值。 * **复杂查找与引用：** 掌握多条件、多重复值下的复杂查找技巧，并使用 XLOOKUP 和 XMATCH 函数实现高效查找。 * **自定义函数：** 利用 LET 和 LAMBDA 函数创建自己的公式，定制个性化分析。 * **Power Pivot 和 Power Query：** 学习构建和管理数据模型，处理海量数据，并运用 Power Query 清洗和转换数据。 * **高级数据透视表与图表：** 探索数据透视表的定制化和动态标签，以及高级数据透视图表技术。 * **交互式 Excel 应用：** 使用表单控件和复选框创建交互式 Excel 工作簿。 * **宏与 VBA：** 学习使用宏和 VBA 自动化重复任务，定制 Excel 功能。 * **AI 工具的应用：** 探索 Microsoft Copilot 和 ChatGPT 等 AI 工具在 Excel 中的应用，实现数据集生成、工作流优化等。 **学习目标：** 学完本课程后，您将能够熟练运用 Microsoft Excel 365 的高级功能，自信地处理复杂的数据分析任务，并显著提升您的电子表格处理能力。 **课程包含：** * 6 小时以上的视频教程 * 73 个独立视频讲座 * 课程及练习文件 * 结业证书 **学习方式：** 课程提供配套的讲师文件和练习文件，鼓励学习者边学边练，巩固所学知识。
**This course includes downloadable course instructor files and exercise files to work with and follow along.**Welcome to the Microsoft Excel 365 Advanced course. In this course, you will delve into advanced features of Excel 365 to enhance your data analysis and productivity skills.You'll explore dynamic array formulas, unlocking the power of functions like SORT, FILTER, and XLOOKUP to manipulate data efficiently. Learn to perform complex lookups and reference functions, even with multiple criteria and duplicate values. Moreover, you'll discover how to create your own functions using LET and LAMBDA, empowering you to tailor formulas to your needs.Master Power Pivot and Power Query to manage and analyze vast datasets effortlessly. Gain insights into advanced PivotTable and Pivot Chart techniques, including customization and dynamic labels, and harness the potential of form controls and checkboxes to create interactive Excel applications.Then, delve into Excel macros and VBA to automate repetitive tasks and customize Excel functionalities. Finally, experience the future of Excel with AI tools like Microsoft Copilot and ChatGPT, enabling you to generate datasets, seek assistance, and streamline your workflow efficiently.By the end of this course, you should have the proficiency to utilize the advanced features of Microsoft Excel 365, empowering you to tackle complex data analysis tasks with confidence. Join us in this comprehensive journey and unlock new productivity levels in your spreadsheet endeavors.In the course, you will be able to:Extract and count unique entries using Dynamic Array Functions.Differentiate between unique and distinct values in Excel spreadsheets.Utilize SORT and SORTBY functions for data organization and analysis.Employ FILTER functions with logical operators for precise data filtration.Generate random arrays and values with RANDARRAY and RANDBETWEEN functions.Perform complex lookups efficiently using XLOOKUP and XMATCH functions.Develop custom formulas with LET and LAMBDA functions for tailored analysis.Create and manage data models with Power Pivot, including table relationships.Clean and manipulate data effectively using Power Query functionalities.Automate repetitive tasks and customize Excel with macros and VBA.This course includes:6+ hours of video tutorials73 individual video lecturesCourse and exercise files to follow alongCertificate of completion
