In this 2-hour long project-based course, you will learn how to create effective charts and a dynamic dashboard to visualize data sets. You will be able to work with vlookups, pivot tables and basic formulas and be able to create dynamic charts, sparklines, and a robust, dynamic dashboard to present the data.

Create Charts and Dashboard using Google Sheets

位教师:Ishita Sinha
访问权限由 New York State Department of Labor 提供
33,501 人已注册
您将学到什么
Perform basic functions and generate basic charts to visualize data.
Generate dynamic charts, sparklines and find duplicate data entries.
Learn how to use slicers and create a robust and dynamic dashboard.
您将练习的技能
要了解的详细信息

添加到您的领英档案
仅桌面可用
了解顶级公司的员工如何掌握热门技能

在 2 小时内学习、练习并应用岗位必备技能
- 接受行业专家的培训
- 获得解决实训工作任务的实践经验
- 使用最新的工具和技术来建立信心

关于此指导项目
分步进行学习
在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:
-
Introduction + Log In to Google Sheets
-
Basic formulas in Google Sheets
-
Introducing 8 Basic Charts
-
Dynamic Charts
-
Sparklines
-
Building Dashboard Part 1 - Basic Charts
-
Building Dashboard Part 2 - Advanced Charts
-
Building Dashboard Part 3 - Slicers
推荐体验
Familiarity with Google Sheets or Microsoft Excel is helpful but not required.
5个项目图片
位教师

提供方
学习方式
基于技能的实践学习
通过完成与工作相关的任务来练习新技能。
专家指导
使用独特的并排界面,按照预先录制的专家视频操作。
无需下载或安装
在预配置的云工作空间中访问所需的工具和资源。
仅在台式计算机上可用
此指导项目专为具有可靠互联网连接的笔记本电脑或台式计算机而设计,而不是移动设备。
人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.
学生评论
- 5 stars
75.11%
- 4 stars
17.97%
- 3 stars
3.53%
- 2 stars
0.92%
- 1 star
2.45%
显示 3/647 个
已于 Jul 31, 2020审阅
This material is very light to understand how to maximize some basic functions in the Google Sheet.
已于 Jul 31, 2020审阅
It was really Great Guide project for beginners ,Those who want the basic knowledge or Good Foundation in this particular Topic .I learnt a Good Basic Knowledge regarding this topic.
已于 Sep 15, 2021审阅
The instructions were easy to understand and work alongside. However, only 8 quiz questions are not enough to evaluate the learning.






