|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-using-microsoft-excel/
课程评论：没有评论
课程名称：使用 Microsoft Excel 进行数据分析 课程概述： TEST4U团队认识到需要一个完整的实践培训系统，以便使用 Microsoft Excel 进行数据分析，因此我们创建了“使用 Microsoft Excel 进行数据分析”课程。该课程旨在帮助希望学习如何使用 Microsoft Excel 执行各种数据分析任务的用户。 课程亮点： - 120个经过良好分类的作业 - 170个用于每个作业和练习的独特文件 - 120个作业解决视频 - 50节讲座 详细课程内容： 1. 基础 Excel 培训 2. 审核工具 3. 文本函数 4. 数学函数 5. 逻辑函数 6. 日期和时间函数 7. 查找函数 8. 财务函数 9. 统计函数 10. 多工作表和数组公式 11. 假设工具和求解器附加组件 12. 数据管理 13. Excel 数据获取与转换 - Power Query 14. 数据透视表与切片器 15. 高级和数据透视图表 16. Cube 函数 17. PowerPivot 18. Power Maps 19. 统计分析 20. 商业建模 21. 分享 - 发布 - 另存为 每个作业都有专属的练习文件和详细的视频解决方案，我们建议学员在查看解决方案前先尝试独立完成作业，以便更好地了解自己的不足之处，然后可以根据视频解决方案确认答案是否正确。 快速反馈机制： 我们通常在一到两个工作日内对所有作业提供反馈，许多情况下甚至能在几个小时内回复。 课堂授课： 本课程包括约50节讲座，讲解 Excel 的各种功能和特性，尽管讲座数量众多，但本课程的主要重点仍然是通过解决作业所获得的实用技能。
The TEST4U Data Analysis using Microsoft Excel CourseThe TEST4U team realized that there is a need for a complete hands-on Training system for Data Analysis using Microsoft Excel, so we created the Data Analysis using Microsoft Excel course. It is targeted to people, who want to learn how to perform various Data Analysis tasks using Microsoft Excel.The Course at a glanceIn this course you will find:120 assignments properly categorized170 distinct files for each of the above assignments and for practicing120 solution videos for every assignment50 LecturesThe Course in detail120 assignments properly categorizedIn this course you will practice on the following categories, using Microsoft Excel:1. Basic Excel Training2. Auditing tools3. Text functions4. Mathematical Functions5. Logical functions6. Date and Time functions7. Lookup functions8. Financial Functions9. Statistical functions10. Multi-Sheet and Array Formulas11. What-if tools and Solver Add-in12. Data management13. Get and Transform with Excel - Power Query14. PivotTables and slicers15. Advanced and Pivot Charts16. Cube Functions17. PowerPivot18. Power Maps19. Statistical Analysis20. Business Modelling21. Share - Publish - Save as170 distinct files for each of the above assignments and for practicingEach and every assignment and lecture comes with its distinct file(s) for practicing.120 solution videos for every assignmentAll assignments are accompanied by detailed video solutions. We recommend you try to solve the assignments without viewing the solution. This way you will better understand your limitations and be able to focus on them. You can then see the video after you have solved it, to know if you answered the question correctly.Fast feedback from our instructorsWe give feedback to all assignments, usually within one or two working days. Although in many cases we have been known to answer within a few hours.50 LecturesThere are approximately 50 lectures in this course explaining various function and features of Excel. Even though there is a plethora of lectures this course's main focus remain the practical skills you can gain by solving the assignments.
