Create Charts and Dashboard using Google Sheets

4.7
364 個評分
提供方
Coursera Project Network
10,332 人已註冊
在此免費指導項目中,您將:

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.

必備條件

Familiarity with Google Sheets or Microsoft Excel is helpful but not required.

您要培養的技能

  • Spreadsheet
  • Google Sheets
  • Charts and Graphs
  • Data Analysis
  • Data 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的熱門評論

查看所有評論

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心