|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mo-201-mos-expert-excel-2019-exam/
课程评论：没有评论
**课程名称：MO-201 MOS 专家级 Excel 2019 认证考试** **课程概述：** 本课程由 MOS 认证大师级讲师 Michael Carter 主讲，旨在帮助学员为 Microsoft Office Specialist (MOS) 专家级 Excel 2019 和 Office 365 (MO-201) 认证考试做好准备。课程内容涵盖了考试的四大核心领域：管理工作簿选项和设置、管理和格式化数据、创建高级公式和宏、以及管理高级图表和表格。课程还包括了新的 Office 365 和 Office 2019 Microsoft Office Specialist 计划的介绍、考试费用以及所有考试目标。学员可以通过下载的示例文件进行练习，并在课程结束时参加完整的模拟考试，以评估自己的技能和速度。 **学习目标：** * 学习如何复制工作簿间的宏。 * 掌握如何保护工作表和单元格区域。 * 学会配置公式计算选项。 * 了解并运用高级填充选项。 * 掌握数据验证的配置。 * 创建自定义条件格式规则。 * 利用函数进行数据查找。 * 学习如何排查公式错误。 * 创建高级图表。 * 学习创建和修改数据透视表及数据透视图。 **培训成果：** 完成本课程后，学员将能够熟练运用高级公式和函数，设计自定义视觉效果和格式，通过数据透视表探索数据，使用宏自动化手动任务，进行团队协作，并取得更多进阶的 Excel 技能。课程特别包含了一系列定制的模拟练习题，旨在模仿真实的 Excel MO-201 考试结构，帮助学员充分准备。
Demonstrate your mastery of Excel by becoming a Microsoft Office Specialist (MOS) Expert. Get training to prepare for the MOS Excel Expert certification exam for Office 2019 and Office 365 (MO-201). This course, created by Certified MOS Master Instructor Michael Carter, helps you prepare for the four main areas of the exam: managing workbook options and settings, managing and formatting data, creating advanced formulas and macros, and managing advanced charts and tables. The course includes an overview of the new Office 365 and Office 2019 Microsoft Office Specialist Program, its costs, and all the exam objectives. Follow along with the downloadable sample files. Then take the full-length practice test at the end of the course to test your skills and speed.Learning objectivesCopying macros between workbooksProtect worksheets and cell rangesConfiguring formula calculation optionsUsing advanced fill optionsConfiguring Data ValidationCreating custom conditional formatting rulesLooking up data using functionsTroubleshooting formulasCreating advanced chartsCreating and modifying PivotTables and PivotChartsTaking the sample examBy the end of the course, you'll be able to apply advanced formulas and functions, design custom visuals and formats, explore data with PivotTables, automate manual tasks with macros, collaborate with other users, and much more. We've even included several custom-built practice tests, designed to replicate the actual Excel MO-201 exam structure and prepare you for the real deal.
