|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-creating-dynamic-dashboards/
课程评论：没有评论
Coursera 上的《Microsoft Excel - 创建动态仪表板》课程是一门专注于利用 Excel 呈现数据、使其功能性、视觉吸引力强且用户友好。 本课程要求具备 Excel 的基础知识，将教授学员如何创建动态仪表板来展示复杂数据。课程从数据准备开始，然后深入仪表板的构建。学员将有机会创建一个包含个人健康信息摘要的仪表板。 通过本课程，您将学习： * 优化 Excel 数据以用于仪表板。 * 创建具有视觉吸引力的仪表板组件。 * 添加交互性以实现个性化用户体验。 * 创建分布直方图。 * 使用华夫饼图（Waffle Chart）展示进度。 * 为按钮添加操作。 * 将仪表板作为输出生成。 * 将仪表板导出为 PDF。 * 在 PowerPoint 中使用仪表板或通过 OneDrive 进行共享。 课程提供练习文件，方便学员跟随讲师进行学习。完成本课程后，您将能够轻松创建自己的自定义动态 Excel 仪表板。
Are you interested in how Excel can be used to present data in a functional, visually attractive, and user-friendly ways? This tightly focused course will show you how to create dynamic dashboards to present complex data using a variety of techniques. A basic knowledge of Excel is required. You will start by learning how to prepare the data, then jump into building the dashboard. Throughout the course, you will be working to create a dashboard that provides a summary of a person's health information. Erin will teach you how to optimize Excel data for use in dashboards, create visual dashboard components, and add interactivity to customize them for each user. This video tutorial also covers how to create a distribution histogram, use a waffle chart to show progress, and add actions to buttons. Finally, you will learn how to generate dashboards as outputs, produce them as PDFs, and utilize them within PowerPoint or share via OneDrive. Once you have completed the course, you'll be able to create your own custom dynamic dashboards in Excel with ease. Working files are included, allowing you to follow along with the author throughout the lessons.
