|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-expert-certification-77-728-77-427-77-428-77-888/
课程评论：没有评论
**课程名称：** Excel in Microsoft Excel 2: Intermediate to Expert advanced **课程概述：** 本系列课程以 Excel 2016 和 Excel 2010 为基础录制，内容也涵盖 Excel 2013 和 2019。在“Excel in Microsoft Excel 1”课程技能的基础上，进一步深入到 6-10 级。完成本课程后，您将具备参加官方 Microsoft Excel Expert 考试所需的技能。 **课程内容亮点：** * **掌握高级函数：** 学习运用逻辑函数、统计函数、日期与时间函数、数组公式，以及 VLOOKUP、HLOOKUP、MATCH、INDEX、TRANSPOSE 和 INDIRECT 等查找函数。 * **数据分析与可视化：** 掌握高级图表创建、数据透视表 (PivotTables) 和数据透视图 (PivotCharts) 的创建与管理，进行数据分析和商业智能。 * **工作簿管理与优化：** 学习管理工作簿选项和设置、评审工作簿、应用属性和数据选项，以及准备工作簿进行国际化和无障碍访问。 * **公式的高级应用：** 学习公式的准备、故障排除，以及管理和引用命名单元格。 * **自动化与 VBA：** 了解 Visual Basic for Applications (VBA) 宏和窗体控件，实现自动化操作。 * **自定义与用户体验：** 创建和修改自定义工作簿元素。 **课程优势：** * **专家级技能：** 教授 Microsoft 官方认可的 Excel Expert 考试核心技能，包括 77-851 (Excel 2007 Expert)、77-888 (Excel 2010 Expert)、77-427/77-428 (Excel 2013 Expert) 和 77-728 (Excel 2016 Expert) 所需能力。 * **系统化学习：** 课程结构清晰，模块化设计，每个子主题通常包含一个 5-7 分钟的讲座，易于理解和消化。 * **实操性强：** 课程包含小测验，并会详细解析解题思路，确保学习效果。 * **适用广泛：** 无论您使用的是 Excel 2007, 2010, 2013, 2016 还是 365，本课程都能助您达到高级水平。 * **提升职业竞争力：** 获得 Excel Expert 认证将极大提升您的简历价值。 **目标学员：** * 希望深化 Microsoft Excel 学习的学生。 * 希望获得 Microsoft Office Specialist Expert 认证的学生。 **课程时长：** 约 8 小时（不含额外的测试和实践时间）。 **免责声明：** 本课程非 Microsoft 官方出品，与 Microsoft 公司无任何关联、认可或赞助。
This course series has been recorded on Excel 2016 and Excel 2010 for the PC, but the content also covers Excel 2013 and 2019.Building on the skills learnt in "Excel in Microsoft Excel 1", here's levels 6-10. 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 Sandberg Most 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 10?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 formulas.Automation and advanced formulasPerform data analysis and business intelligence in Excel.Visual Basic for Applications (VBA) macros and form controls.Create 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. Specifically, they are the skills required to undertake the Microsoft Certificate 77-851 (for Excel 2007 Expert), 77-888 (for Excel 2010 Expert), 77-427 and 77-428 (for Excel 2013 Expert) and 77-728 (for Excel 2016 Expert) 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 2007, Excel 2010, Excel 2013, Excel 2016 or Excel 365, this course will help you get to an advanced level, and maybe even want you to get more!
