|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mo-211-microsoft-excel-expert-microsoft-365-apps/
课程评论：没有评论
**Coursera 课程总结：MO-211 预备：Microsoft Excel Expert (Microsoft 365 Apps)** 本课程旨在帮助学员为 Microsoft Excel Expert (MO-211) 认证考试做准备，该认证是 Excel 的新专家级认证，于 2023 年 4 月推出。成功通过此认证，将证明您已掌握充分利用 Excel 的各项技能。 **课程内容涵盖：** * **工作簿管理：** 管理工作簿选项和设置，引用其他工作簿中的数据，管理工作簿版本，以及通过保护内容和结构来为协作准备工作簿。 * **数据格式与验证：** 格式化和验证数据，包括创建自定义数字格式。 * **高级图表与表格：** 创建数据透视表，配置值字段设置，添加切片器，创建和修改数据透视图，以及创建和修改高级图表，如箱型图、漏斗图、直方图、旭日图和瀑布图。 * **高级公式与宏：** 使用函数进行逻辑运算、数据查找，使用高级日期和时间函数，执行数据分析以及排除公式故障。课程还将介绍 XLOOKUP、LET、FILTER 和 SORTBY 等新函数。 * **其他 Excel Expert 主题：** 基于现有数据填充单元格，创建自定义条件格式规则，以及创建和管理简单的 VBA 宏。 **课程特色：** * **零基础入门：** 无需任何先验知识。 * **实践导向：** 包含 10 项练习活动、10 次测验和 1 次模拟测试，以巩固学习成果。 * **能力提升：** 完成课程后，您将对 Microsoft Excel 有更深入的了解。 * **职业发展：** 掌握本课程内容，并加以练习，即可参加官方的 Microsoft MO-211 考试，获得“Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps)”证书，这将为您的简历增色，也是获得“Microsoft Office Specialist: Expert (Microsoft 365 Apps)”认证的第一步。 **重要声明：** 本课程与 Microsoft 没有任何关联、认可或赞助。本课程已根据 Udemy 的可访问性指南创建，并接续了 MO-210 Excel 认证的准备内容（该内容已在 Udemy 上发布，标题为“MO-210: Microsoft Excel (from beginner to intermediate)”）。
The MO-211 certification is the new Expert certification for Excel, launched in April 2023. Microsoft says that this certification demonstrates that you have the skills needed to get the most out of Excel by earning a Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) certification.Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.This course has been created using Udemy's Accessibility guidelines. It follows on from your preparations for the MO-210 Excel certification. This content is available in "MO-210: Microsoft Excel (from beginner to intermediate)", which is published on Udemy.In this MO-211 course:We'll start with managing workbook options and settings. We'll reference data in other workbooks, manage workbook versions, and prepare workbooks for collaboration by protecting their content and structure. We'll also format and valid data, including creating custom number formats.We'll then manage advanced charts and tables. We'll create PivotTables, configuring value field settings and adding slicers, with create and modify PivotCharts, and create and modify advanced charts, including Box & Whisker, Funnel, Histogram, Sunburst and Waterfall charts.We'll then create advanced formulas and macros. We'll use functions for performing logical operations, looking up data, use advanced date and time functions, perform data analysis and troubleshoot formulas. This will also include newer Excel functions, such as XLOOKUP, LET, FILTER and SORTBY.Finally, we'll look at other Excel Expert topics. We'll fill cells based on existing data, we'll create custom conditional formatting rules, and create and manage simple VBA macros.No prior knowledge is required. And there are 10 Practice Activities, 10 quizzes and a Practice Test to help you remember the information, so you can be sure that you are learning.Once you have completed this course, you will have an expanded knowledge of Microsoft Excel. With some practice, you could even take the official Microsoft MO-211 exam, which gives you the "Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps)" certificate. This would look good on your CV or resume. It is also the first stage to you getting the "Microsoft Office Specialist: Expert (Microsoft 365 Apps)" certification.
