|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dashboard-design/
课程评论：没有评论
课程名称：Google Sheets - 仪表板设计 课程概述：在本课程中，我们将学习如何对信息进行过滤和排序，以建立一个易于理解的数据摘要页面。您将获得相同的数据源文件，并在45分钟内理解如何将原始数据转化为有意义的信息。在最后一课中，我们将探索如何构建可定制的动态图表，这些图表将基于用户输入。我们将通过从Google Sheets构建仪表板来进行学习。在本课程中，您将学习使用Google Sheets内置的以下函数：Unique()、Filter()、Sort()、array_constrain()和IsBlank()。请来探索电子表格的奇妙世界，让我带您穿越公式和动态设计的常见困惑。再也不必感到害怕！通过这五个公式，您将能够访问无尽的设计和应用，并拥有强大的工具来创建专业外观的电子表格和仪表板！
In this course, we will cover how to filter and sort information to build an easy summary page of data. You will have access to the same source file, and in 45 min, you will understand how to turn raw data into meaningful information. In the last lesson, we will explore how to build customizable, dynamic charts, build from user input. We will explore this through building a dashboard from Google Sheets. In this course, you will learn to use the following functions pre-built into Google Sheets:Unique()Filter()Sort()array_constrain()IsBlank()Come and explore the wonderful world of spreadsheets as I guide you through the often murky waters of formulas and dynamic designs. No need to be intimidated any longer! Through these 5 formulas, you will have access to countless designs and applications and have powerful tools to create professional looking spreadsheets and dashboard!
