Create Charts and Dashboard using Google Sheets

4.8
234 個評分
提供方
Coursera Project Network
7,570 人已註冊
在此免費的指導 項目中,您將:

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.

您要培養的技能

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的熱門評論

查看所有評論

常見問題

常見問題

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