|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/visually-stunning-microsoft-excel-dynamic-dashboard-course/
课程评论：没有评论
**Coursera课程：Microsoft Excel动态仪表盘制作（视觉呈现）** 本课程专注于教授学员如何**设计和创建具有视觉吸引力的Excel动态仪表盘**，以帮助您和同事**快速识别趋势并基于数据做出明智决策**。 通过本课程，您将掌握**分析大型数据集所需的宝贵技能**。我们将深入讲解如何利用**多个数据透视表、数据透视图和数据透视表工具**来构建动态仪表盘。此外，学员还将学习使用**切片器（Slicers）和时间轴（Timeline）**，这些工具能够让数据透视表和图表**自动筛选和调整**，清晰地展示用户所需的信息。 本课程的另一大亮点在于，您可以**轻松刷新仪表盘**，当数据添加或更新时，仪表盘会**自动同步**。这意味着您只需**一次性创建仪表盘报表**，便可省去重复劳动。 课程内容循序渐进，涵盖**11个基础仪表盘、3个中级仪表盘以及4个高级仪表盘**的制作。通过**跟随课程进行实践**，您将成为Excel动态仪表盘制作的**大师**。
This course teaches you to create well-designed dynamic Excel dashboards so you and your colleagues can see trends and make quick decisions informed by data.By participating in this Microsoft Excel Dashboard course you'll gain the widely sought after skills necessary to effectively analyze large sets of data. In this topic, we'll discuss how to use multiple PivotTables, PivotCharts and PivotTable tools to create a dynamic excel dashboards. Then we'll give users the ability to quickly filter the data the way they want with Slicers and a Timeline, which allow your PivotTables and charts to automatically expand and contract to display only the information that users want to see. In addition, you can quickly refresh your dashboard when you add or update data. This makes it very handy because you only need to create the excel dashboard report once.You will start with 11 Basic Level Excel Dashboards and gradually move to 3 Intermediate and 4 Advanced Level dashboard. Practicing the dashboard along with the course will make you a Master of Microsoft Excel Dashboards.
