|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-interactive-dashboard/
课程评论：没有评论
**Course Title:** Excel 互动式仪表板（Excel Interactive Dashboard） **课程概述：** 本课程将教授如何利用图表和数据透视表（Pivot Tables）创建出色的动态仪表板。学员将从基础的图表学习入手，了解如何插入和编辑数据透视表、切片器（Slicers）和数据透视图（Pivot Charts）。课程还将深入探讨一些非 Excel 标准的、需要创新思维的图表类型，例如动态圆环图、圆角进度圆环图、动态折线图、叠加图片图表等。 **课程特色：** * **从零开始：** 课程假定学员仅需了解 Excel 的基本原则，将全程指导学员从头开始构建动态仪表板。 * **适用人群广泛：** 无论您是 Excel 初学者、中级用户还是高级用户，本课程都适用。 * **提升技能：** 帮助学员告别传统的、固定的报表方式，提升到使用动态仪表板和非标准 Excel 图表的更高级别。 * **版本兼容性：** 主要使用 Excel 2019 进行演示，但大部分功能在之前的 Excel 版本中也可用。 * **学习建议：** 强烈建议学员在学习过程中下载并使用课程提供的资源进行实践。 **学习目标：** 通过本课程的学习，学员将能够： * 熟练运用 Excel 图表和数据透视表创建动态仪表板。 * 掌握数据透视表、切片器和数据透视图的使用技巧。 * 学习并应用多种非标准、创新的 Excel 图表制作方法。 * 显著提升 Excel 数据可视化和分析能力。 **学习建议：** 请下载课程提供的资源并在学习过程中加以实践，以达到最佳学习效果。
In this course, you will learn how to use charts & pivot tables to create amazing dynamic dashboards. But to do that you must first learn the basic charts and how to insert and edit pivot tables, slicers and pivot charts which will be taught in this course as well. During that journey, you will learn additional uncommon charts that requires an out of the box thinking as they are not an excel standard charts, such as the dynamic doughnut chart, rounded edges progress donut chart, dynamic line charts, overlay image charts and much more.This course only requires you to know the basic principles of excel as the course will guide you to do dynamic dashboards from scratch. Therefore, this course is applicable for all levels, beginners, intermediate and advanced levels in Excel.This is your chance to enhance you sheets, it is time to stop using standard direct methods, and level up your game to use dynamic dashboards and uncommon Excel charts. I will be using Excel 2019 but most of the features are available in the previous Excel versions.With that being said, I can't wait to see you inside. If you decided to join me and other thousands students all over the world, I strongly advice you to download the resources and work on them while learning. But whatever you decide, stay productive and happy learning!!
