|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-for-mac-beginner-to-specialist-certificate/
课程评论：没有评论
Coursera 上的 "Microsoft Excel for Mac 1: Beginner-Specialist Certificate" 课程是一项为期约 11.5 小时的综合性培训，旨在帮助学习者掌握 Microsoft Excel 的基础到专家级别技能。本课程涵盖创建和管理工作表/工作簿、数据处理、表格操作、公式与函数运用、图表和对象创建等核心内容。 课程内容丰富，包括： * **工作表与工作簿管理**：学习创建、导航、格式化、自定义选项和视图，以及配置工作簿以供分发。 * **数据单元格与区域管理**：掌握数据的插入、格式化，以及如何汇总和整理数据。 * **表格创建与管理**：学习创建、管理表格样式和选项，以及进行表格的筛选和排序。 * **公式与函数操作**：重点教授数据汇总、条件操作和文本格式化，尤其是 COUNTIF、SUMIF、MIN 等常用公式，并提供 15 种语言的翻译。 * **图表与对象创建**：学习创建图表、格式化图形元素，以及在 Excel 中插入和格式化对象。 本课程内容与 Microsoft Excel 2016 核心认证考试 (77-727) 所需技能高度一致，无论您使用的是 Excel 2011、2016 还是 365 版本，都能从中受益。课程采用小模块（5-7 分钟/讲座）教学，确保学习效率。高评价显示，该课程讲解清晰、节奏适宜，内容深入且练习实用，能有效弥补知识盲区，并帮助学员在实际应用甚至专业考试中取得优异成绩。 本课程适合希望深入了解 Excel 功能或目标是成为 Microsoft Office 专家认证 (MOS) 的用户。
By the end of this course, you will have the skills needed for the official Microsoft Excel Specialist exam. How would that look on your resume?Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.Reviews:"The teacher explains very well and at a good pace. Has real in-depth knowledge. The exercises are precise and well put together for the course. And the language sheets are invaluable to those that use other language than English version. I highly recommend this course. It goes thru most of the basic knowledge needed for Excel. Once again The teacher is excellent" - Daniel Sandberg"This is super helpful to me. I'm learning things I didn't know existed in Excel." - Jimmy Thrower"I had to take an Excel proficiency test as a job interview requirement , and scored top 10% percentile (they called me immediately to schedule a face-to-face) , thanks to your great course for which I studied for two days straight to re-enforce my knowledge in Excel, and more importantly fill those gaps of knowledge on all its functionality capabilities. You really get the MOST out of Phillip's courses." - Rick RomeroMost people who use Excel are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 5?In this 11.5 hour course, learn how to:Create and manage worksheets and workbooksCreate and navigate in Excel worksheets and workbooks,Format worksheets and workbooks,Customize options and views, andConfigure Excel worksheets and workbooks for distribution.Manage data cells and rangesInsert data into and format cells and ranges, andSummarise and organize data in Excel.Create tablesCreate and manage tables,Manage table styles and options, andFilter and sort a table.Perform operations with Excel formulas and functionsSummarize data,Perform conditional operations, andFormat and modify text.Excel Formulas such as COUNTIF, SUMIF, MIN etc. are translated into 15 different languages.Create charts and objectsCreate charts,Format graphic elements, andInsert and format objects in Excel.This course teaches all the skills that Microsoft want you to know. Specifically, they are the skills required to undertake the Microsoft Certificate 77-727 (for Excel 2016 Core) and will be useful if you wish to take the exam, or which to learn more about Microsoft ExcelThe core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Excel, and this course teaches you all of them.Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.The course will take about 11 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.You should take this course if:you want to learn more about Microsoft Excel, oryou want to learn the skills you need to become a certified Microsoft Office Specialist.Regardless whether you have Excel 2011, Excel 2016 or Excel 365, this course will help you get to a good level, and maybe even want you to get more!
