Create Charts and Dashboard using Google Sheets

4.8
stars
126 ratings
Offered By
Coursera Project Network
3,756 already enrolled
In this Guided Project, you will:

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
BeginnerBeginner
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

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.

Skills you will develop

SpreadsheetGoogle SheetsCharts and GraphsData AnalysisData Visualization (DataViz)

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  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

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Reviews

TOP REVIEWS FROM CREATE CHARTS AND DASHBOARD USING GOOGLE SHEETS

View all reviews

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.