|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mo-201-microsoft-excel-expert-office-2019-practice-test/
课程评论：没有评论
Coursera 上的“MO-201/Microsoft Excel Expert (Office 2019) 练习测试”课程旨在帮助学员掌握 Microsoft Excel 专家（Office 2019）认证考试 MO-201 所涵盖的全部内容。 该练习测试共包含四个部分，每个部分都专注于特定的主题领域： 1. **管理工作簿选项和设置**：涵盖自定义功能区和 Excel 选项、管理工作表和工作簿、使用 Excel 的审核工具、应用工作表和工作簿保护、使用视图工具展示数据以及自定义快速访问工具栏。 2. **管理和格式化数据**：深入学习高级数据格式化技术，如条件格式、自定义数字格式和数据验证。此外，还将学习如何使用 Excel 的数据分析工具，包括方案分析和单变量求解，以及如何利用迷你图和数据条创建可视化效果。 3. **创建高级公式和宏**：学习如何使用嵌套函数和数组公式等技术创建复杂的公式和函数，同时探索使用 Excel 的审核工具和数据分析工具来排查公式和函数中的错误。本部分还包括使用宏记录器和 Visual Basic 编辑器创建宏以自动化重复任务。 4. **管理高级图表和表格**：重点讲解创建组合图和瀑布图等高级图表，以及使用数据透视表、数据透视图和 Power Query 来分析和可视化数据。此外，还将学习如何使用 Excel 的数据建模功能，包括关系、层次结构和 DAX 公式，来高效管理大型数据集。 完成此练习测试后，学员将对高级 Excel 工具和技术有深入的了解，并为通过 MO-201 认证考试做好充分准备，从而提高其在工作中的生产力和效率。
This practice test is designed to help students master the material covered in the MO-201: Microsoft Excel Expert (Office 2019) certification exam. The test consists of four sections, each focusing on a specific topic: managing workbook options and settings, managing and formatting data, creating advanced formulas and macros, and managing advanced charts and tables. The first section covers how to customize the Ribbon and Excel Options, manage worksheets and workbooks, and use Excel's auditing tools. Students will also learn how to apply protection to worksheets and workbooks, use the Views tools to display data in different ways, and customize the Quick Access Toolbar. In the second section, students will learn how to format data using advanced techniques such as conditional formatting, custom number formats, and data validation. They will also learn how to use Excel's data analysis tools, including scenarios and goal seeking, and how to work with Sparklines and Data Bars to create impactful visualizations. In the third section, students will learn how to create complex formulas and functions using techniques such as nested functions and array formulas. They will also explore how to use Excel's auditing tools and data analysis tools to troubleshoot errors in formulas and functions. Students will also learn how to create macros using the Macro Recorder and the Visual Basic Editor to automate repetitive tasks and increase productivity. In the fourth section, students will learn how to create advanced charts such as combo charts and waterfall charts, and how to use PivotTables, PivotCharts, and Power Query to analyze and visualize data. They will also learn how to manage large datasets efficiently using Excel's data modeling features, including relationships, hierarchies, and DAX formulas. By the end of this practice test, students will be well-prepared to take and pass the MO-201: Microsoft Excel Expert (Office 2019) certification exam. They will have gained a deep understanding of advanced Excel tools and techniques, and be able to use them to increase their productivity and efficiency in the workplace.
