|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-reporting-and-dashboards/
课程评论：没有评论
**课程名称：** Microsoft Excel: 从零开始的数据报告与仪表板制作 **课程概述：** 本课程旨在为您开启“数据分析世界”的完美旅程。课程强调基础的重要性，帮助学习者扎实掌握Excel的核心概念，避免直接学习高级功能而产生的困惑。通过深入讲解每个概念的背景知识，确保学习者能够正确理解并灵活运用所学技能解决实际问题。 本课程并非仅仅教授Excel的特定功能，而是侧重于培养学习者可迁移的通用数据处理和分析能力。课程结构严谨，按照以下逻辑顺序进行： 1. **数据理解：** 掌握Excel中理解数据框架的关键概念。 2. **数据清洗：** 学习使用“定位到特殊单元格”、“删除重复项”等实用工具进行数据清理。 3. **数据准备：** 深入运用VLOOKUP、文本函数、日期函数、逻辑函数等各类函数对数据进行准备。 4. **数据汇总：** 通过函数与数据透视表，有效地对数据进行汇总分析。 5. **数据呈现：** 根据具体需求，学习使用不同类型的图表进行数据可视化。 6. **报告与仪表板制作：** 结合窗体/ActiveX控件和带有切片器的 Pivot Table，制作交互式报告与仪表板。 **学习成果：** 完成本课程后，您将能够： * 熟练运用Excel的智能功能，自信地工作，节省时间和精力。 * 独立创建交互式报告和仪表板。 * 将所学概念灵活应用于解决各类数据问题。 * 为面试做好充分准备，自信回答相关问题。 * （如果之前不喜欢Excel，现在会爱上它！） 本课程期待您的积极反馈。
This course gives you a perfect start to the "Data Analytics world". "If you feel something is complicated or not your cup of tea, its majorly because you tried jumping on the advanced concepts rather than absorbing the basics first" - This course is an effort to provide ample background of each concepts and stresses on the fundamental areas to ensure that you learn it correctly and can re-implement the concepts when required.This course is not designed to teach you certain functionalities of Excel; But, to teach you the right skills which you can re-implement on other problems tooThe course is structured to cover all major Excel Concepts while Explaining the Data Reporting concepts.Data Understanding - Using concepts that will help you understand the framework of your Data in ExcelData Cleaning - Using various tools like - Go To special, Remove duplicates, etcData Preparation - Using various Functions like VLookup, Text Functions, Date Functions, Logical Functions, etcData Summarizing - Explained using Functions and Pivot TablesData Presentation - Explained using Different chart types we should use depending on the requirement.Reporting & Dashboards - Explained using Form/ActiveX controls and Pivot Table with the help of SlicersAll of this using Microsoft Excel. The course flow ordered exactly like the points above. This order should be followed while working on Excel as well. After completing this course you will be able to:Work confidently and Save your time and effort by using smart functionalities of Excel.Create your own interactive Reports and DashboardsRe implement the concepts to different problemsBe ready to answer Interview questions.Start Loving Excel (in case you currently don't)Looking forward to hear back from you about the course.
