|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-365-expert/
课程评论：没有评论
课程名称：Microsoft 365 Excel - 专家 课程概述：本课程是在高级课程的基础上进一步深化，扩展了之前介绍的一些主题，并引入了许多新功能。课程开始时介绍工作表自动化工具，包括下拉框、旋钮控制和选项按钮，这些元素可以插入工作表并与公式连接，无需编写宏代码即可实现专业效果。接着，课程探讨数据汇总，重点使用3-D公式和数据汇总功能，尤其适用于不同工作表的数据整合。 “数据类型”在Excel中是一个重要概念，允许用户从单一来源访问组织内外的各种信息。课程还讲解了如何创建数据模型，以最大程度利用PowerPivot，从不同来源获取信息，整合多个表格以生成可用于数据透视表或其他分析类型的单一数据模型。 课程进一步深入查找函数，介绍了一些新函数，帮助学员掌握新用法和技巧，提升应用能力。动态数组函数作为一种新兴工具，使学员能够超越标量函数的使用，进入动态数组函数的新领域。 此外，课程精选了财务和统计函数，帮助用户在无需专业培训的情况下，对工作表数据进行高水平的分析。最后一章重点讲解预测分析的相关功能，扩展Solver的使用，并与情景管理器结合，利用分析工具库创建描述性摘要和传统直方图，应用新的直方图图表类型，对预测表进行再审视和运用。 本课程将为学员提供更加专业的Excel技能，适用于各类数据分析和展示需求。
This course builds on the advanced course. Some topics that were introduced in earlier courses are expanded on and many new topics are introduced, including new features.The course begins by examining worksheet automation tools. Drop-down boxes, spinner controls, option buttons are all placed onto a worksheet and wired into its formulae. No macro code is required to achieve these professional results.Data consolidation is examined using both 3-D formulae and the Data Consolidation feature itself with the emphasis on using it with dissimilar worksheets.While the term "data type" has several different meanings, it's a feature in Excel and is used to access different types of information from a single location - either within an organization or outside.PowerPivot cannot be used to its fullest without the ability to create a data model. This course retrieves information from different sources, takes multiple tables, and creates a single data model that may be used for PivotTables or other types of analysis.Lookup functions are covered to a certain level in n earlier course, but the Expert course pushes those functions further. It also introduces several new functions as well. Even those who are familiar with some of these functions will find new uses, tips and tricks, and other opportunities to push their usage further for a new level of professional results.While array functions have been available for several years, dynamic array functions are new. This course moves students past the use of scalar functions and brings them into the new world of dynamic array functions.Even the best of Excel users may find themselves intimidated by Excel's financial and statistical functions. In this course, functions have been curated from both categories that add a large degree of professional analysis to worksheet data without the need for formal training in finance or stats. Everyone can use and understand these functions.The last chapter examines features used to perform predictive analysis. The use of Solver is expanded upon and is integrated with the Scenario Manager. The Analysis ToolPak is used to create descriptive summaries and traditional Histograms. The newer Histogram chart type is also utilized. Forecast sheets are finally re-examined and put to use.
