|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-intermediate-creating-a-dashboard/
课程评论：没有评论
Coursera课程《Microsoft Excel 进阶 - 创建仪表板》内容总结： 本课程是一门项目驱动的课程，旨在帮助学员从零开始，一步步在Microsoft Excel中创建一个精美的仪表板。课程适用于在工作或个人生活中使用Excel的学员。 课程内容涵盖： * **PivotTable基础及应用**：讲解PivotTable的基本概念及其在创建仪表板中的有效运用。 * **图表制作**：教授制作仪表板所需的各类图表。 * **切片器（Slicers）**：展示切片器的工作原理，并优化其外观。 * **自动刷新功能**：讲解如何设置仪表板在添加新数据时自动刷新。 * **仪表板设计与整合**：将所有学习到的知识点整合，完成仪表板的最终设计。 完成本课程后，学员将能够自信地创建仪表板，并将大型数据集转化为富有洞察力的可视化仪表板。课程从基础开始，无需Excel预备知识。
If you use Microsoft Excel in your professional life, or even personal life, then this class will be perfect for you.This class is a project based class in which we will work together from beginning to end to create a dashboard in Microsoft Excel. It is designed as if we were in the workplace and have been assigned a new task.You do not need any knowledge of Microsoft Excel to follow along with this course as we will start together from the beginning and work our way up to creating an amazing looking dashboard.To start with, I will explain to you the fundamentals of a Pivot Table and how we can use them effectively for Dashboards. I will then show you how to create all of the charts that are needed for the dashboard. I will also show you how slicers work and how to make them look much better! You will also learn how to make the dashboard automatically refresh when new data is added to the data set. Finally, we will put it altogether and design an amazing looking dashboard.After taking this class, you should feel confident in your ability to create a dashboard and transform a large data set into a insightful visual dashboard.
