|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-secrets-to-generate-the-most-automated-excel-dashboards/
课程评论：没有评论
**课程名称：** Excel自动化仪表板的终极秘诀 **课程概述：** 本课程将教授学员如何利用Excel创建功能强大的自动化仪表板。课程内容涵盖： * **交互式控件与数据联动：** 如何将窗体控件或ActiveX控件与单元格及区域的值进行连接，实现交互式操作。 * **自动化图表生成：** 如何创建能够根据单个或少量单元格值的修改而自动更新的图表。 * **动态图像更新：** 如何通过修改单元格中的数值来动态更新图像内容。 * **函数与公式的应用：** 如何运用Excel的函数和公式构建表格、数据源以及汇总报表。 * **高级查找与引用：** 如何使用组合的查找与引用函数，实现跨不同表格的数据检索和关联。 * **动态数据系列图表：** 如何创建能够动态生成数据系列的可变图表。 课程将通过丰富的实例进行讲解，涵盖常见的业务领域，包括： * 仪表板测试活动 * 利用超链接创建Excel交互式仪表板 * 交互式销售图表 * 多个关键绩效指标（KPI）仪表板 * 使用数据透视表和切片器创建动态仪表板 * 客户服务仪表板 * 项目管理仪表板 / 项目状态报告 * 财务仪表板 此外，课程将在后期介绍**Visual Basic for Applications (VBA)**，这是一种用于创建宏和扩展Excel功能的编程语言，将通过具体示例进行演示。
In this course the students will learn how to create automated Excel dashboards. In details: how to connect form commands or ActiveX to values in cells and rangeshow to generate automated charts which will be updated just modifying a single value in one or a few cellshow to create dynamic images, which will be updated by changing some values in cellshow to use Excel functions and formulas to create tables and data sources and summary reportshow to use combined lookup and reference formulas to retrieve joined values between different tableshow to create variable charts with data series generated dynamically The course is conducted through examples. These examples covers Excel dashboards in the most popular business areas, in details: Dashboard testing activitiesInteractive Dashboard in Excel using HyperlinksInteractive Sales Chartseveral KPI dashboardsMake Dynamic Dashboards using Pivot Tables & SlicersCustomer Service DashboardProject Management Dashboard / Project Status ReportFinancial Dashboard During the course and especially at the end some example will be done implementing Visual Basic for Applications (VBA). The programming language to create macros and functions to expand the functionalites of Excel.
