Create Charts and Dashboard using Google Sheets

4.8
47 个评分
提供方
Coursera Project Network
在此指导项目中,您将:

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.

Clock2 hours
Beginner初级
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

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. By the end of the project you will be able to: - Understand the terminologies of spreadsheets - Work with basic formulas in Google Sheets - Create 8 Basic Charts for visualizing data - Generate Dynamic Charts from a dropdown list - Generate Sparklines to represent data - Build a dashboard and introduce Basic and Advanced Charts - Use Slicers to filter data and create a robust and dynamic dashboard Note: If you don't have a Google account, you will need to create one to be able to complete the content.

您要培养的技能

SpreadsheetGoogle SheetsCharts and GraphsData AnalysisData Visualization (DataViz)

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

  1. Introduction + Log In to Google Sheets

  2. Basic formulas in Google Sheets

  3. Introducing 8 Basic Charts

  4. Dynamic Charts

  5. Sparklines

  6. Building Dashboard Part 1 - Basic Charts

  7. Building Dashboard Part 2 - Advanced Charts

  8. Building Dashboard Part 3 - Slicers

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

审阅

来自CREATE CHARTS AND DASHBOARD USING GOOGLE SHEETS的热门评论

查看所有评论

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心