|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mo-210-microsoft-excel-microsoft-365-apps/
课程评论:没有评论
**课程名称:** MO-210 备考:Microsoft Excel (从入门到进阶) **课程概述:** 本课程旨在帮助学员为 Microsoft Excel MO-210 认证考试做好准备。MO-210 是全新的 Excel 认证,通过此认证表明您已掌握利用 Excel 充分发挥其功效的技能,并可获得“Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps)”证书。 **学习内容:** * **创建和管理工作簿:** 学习如何创建、组织和管理 Excel 工作簿,以及导入数据、导航和格式化工作簿,并为协作和分发做好准备。 * **数据管理与表格:** 掌握数据单元格和区域的管理,创建和格式化表格,汇总和组织数据,管理表格样式和选项,以及对表格数据进行筛选和排序。 * **Excel 公式与函数:** 深入学习 Excel 公式和函数的使用,包括用于数据汇总、条件运算、文本格式化和修改、排序以及生成数值数据的函数。 * **图表与迷你图:** 学习创建和使用各种图表类型(如折线图、柱状图、面积图和饼图),添加图例,应用布局和样式,以及插入迷你图。 **课程特色:** * **零基础入门:** 无需任何先验知识,适合所有 Excel 初学者。 * **强化学习:** 包含 15 次练习活动、15 次小测验和 1 次模拟测试,帮助巩固知识。 * **职业发展:** 完成课程可提升 Microsoft Excel 技能,为参加 MO-210 考试并获得“Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps)”证书奠定基础,该证书可为您的简历增色,也是迈向“Microsoft Office Specialist: Associate (Microsoft 365 Apps)”认证的第一步。 **重要声明:** 本课程未获得 Microsoft 的官方认可、批准或赞助。本课程按照 Udemy 的无障碍指南创建。
The MO-210 certification is the new certification for Excel. 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 Associate (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.In this MO-210 course:We'll start with create and manage worksheets and workbooks. We'll import data into workbooks, navigate and format workbooks, and prepare them for collaboration and distribution.We'll then look at managing data cells and ranges and create tables. We'll insert data into and format workbooks, summarise and organize data, manage table styles and options, and filter and sort table data.We'll then perform operations with Excel formulas and functions. We'll use functions for summarising data, performing conditional operations, formatting and modifying text, sorting and generating numeric data.Finally, we'll look at creating charts and sparklines. We'll use different chart types, such as line, bar, area and pie charts, we'll add legends and apply layouts and styles, and insert sparklines.No prior knowledge is required. And there are 15 Practice Activities, 15 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-210 exam, which gives you the "Microsoft Office Specialist: Excel Associate (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: Associate (Microsoft 365 Apps)" certification.