|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-for-mac-2-intermediate-to-expert-advanced/
课程评论：没有评论
**课程名称：** Microsoft Excel for Mac 2: Intermediate to Expert Advanced **课程概述：** 本课程是“Microsoft Excel for Mac 1”的进阶篇，涵盖了Excel技能的6至9级。完成本课程后，您将掌握参加微软官方Excel专家认证考试所需的全部技能。本课程旨在帮助您从Excel的常规使用者（大部分人处于2级或3级水平）提升至9级专家水平。 **学习目标：** * **工作簿管理与设置：** * 管理工作簿选项和设置 * 管理Excel工作簿 * 管理工作簿审阅 * 应用工作簿设置、属性和数据选项 * **函数与公式：** * 应用逻辑和统计函数 * 准备高级公式 * 排查Excel公式错误 * 管理和引用已定义的名称 * 数组公式 * 利用函数（VLOOKUP, HLOOKUP, MATCH, INDEX, TRANSPOSE, INDIRECT）查找数据 * **数据可视化与分析：** * 创建高级图表和Excel表 * 创建和管理数据透视表 * 创建和管理数据透视表图 * 应用高级日期和时间函数 * 高级格式设置 * **自动化与自定义：** * 自动化和高级公式 * 创建和修改自定义工作簿元素 * **国际化与可访问性：** * 准备工作簿以实现国际化和可访问性 **课程特点：** * **专家级内容：** 涵盖微软Excel专家考试（77-728，Excel 2016专家）所需的所有核心技能，包括一些仅在PC端可用的功能。 * **结构化教学：** 内容按逻辑顺序编排，每个模块细分为子主题，每个子主题通常包含一个5-7分钟的讲座。 * **实战导向：** 旨在帮助您获得官方认证，并能显著提升您的Excel专业能力。 * **高评价：** 学习体验被评价为“思路清晰，讲解易于学习和理解”，教学风格“引人入胜且结构严谨”，小测验“非常棒”，并提供详细的解题思路。 * **适用性广：** 无论您使用的是Excel 2016、Excel 365还是Excel 2011，本课程都能帮助您达到高级水平。 * **完成时间：** 课程预计耗时约8小时，此外还需要额外时间进行练习和巩固。 **适合人群：** * 希望深入学习Microsoft Excel的用户。 * 希望获得微软Office专家（MOS Expert）认证的用户。 **声明：** 本课程与Microsoft公司无任何关联、认可或赞助。
Building on the skills learnt in "Microsoft Excel for Mac 1", here's levels 6-9. By the end of this course, you will have the skills needed for the official Microsoft Excel Expert exam. How would that look on your resume?Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.Reviews"Well thought out and explained in a way which makes it easy to learn & understand." - Arnold Schwartz"This course is very well structured and the teachers knowledge is very good. His teaching style is capturing and he is very structured. The small tests after each section is great, and even greater is that he takes time to show his thoughts on how is should have been done, not just leaving one to wonder if it was right or not. The resources used in this course is also very suitable. Highly recommend this one" - Daniel SandbergMost 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 9?In this course, learn how to:Manage workbook options and settingsManage Excel workbooks,Manage workbook review,Apply workbook settings, properties and data options, andApply logical and statistical functionsCreate advanced charts and Excel tablesCreate and manage PivotTables,Advanced formatting,Create and manage PivotCharts,Create advanced charts,Apply advanced date and time functionsPreparing for advanced formulasTroubleshoot Excel formulas,Manage and reference defined names,Prepare a workbook for internationalisation and accessibility,Array fornulas.Automation and advanced formulasCreate and modify custom workbook elementsLook up data by using functions (VLOOKUP, HLOOKUP, MATCH, INDEX, TRANSPOSE and INDIRECT). translated into 15 different languages.This course teaches all the skills that Microsoft want you to know for the Expert exams 77-728 (for Excel 2016 Expert), including those aspects which are PC only (sadly), 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 8 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 Excel skills you need to become a certified Microsoft Office Specialist Expert.Regardless whether you have Excel 2016 or Excel 365 (or even Excel 2011), this course will help you get to an advanced level, and maybe even want you to get more!
