Back to Create Charts and Dashboard using Google Sheets
Coursera

Create Charts and Dashboard using Google Sheets

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.

Status: Spreadsheet Software
Status: Data Analysis
BeginnerGuided Project2 hours

Featured reviews

YM

4.0Reviewed Jan 5, 2022

It is good for beginners to know basics and get acquainted with the steps of making a dashboard. The instructor spoke clearly. One issue, the workplace sometimes had lagging issues.

NT

4.0Reviewed 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.

R

5.0Reviewed Sep 15, 2021

T​he instructions were easy to understand and work alongside. However, only 8 quiz questions are not enough to evaluate the learning.

LC

4.0Reviewed Oct 31, 2020

the cloud worksheets was a struggle because operation was slow... I don't know if the problem was with my laptop or it is naturally slow. But overload, it was very informative

TN

5.0Reviewed Apr 17, 2023

An extremely helpful and intuitive tutorial. I've learned a lot by the end of the course. Many thanks to the instructor and Coursera for this free guided project.

PK

5.0Reviewed Sep 1, 2023

Very informative and communicative. Also, I believe everything here is helpful further in an individual's career

MJ

5.0Reviewed Jul 2, 2023

A very easy to understand training course to help bost and improve your knowledge about spreadsheets and using custom formulas.

NB

5.0Reviewed May 13, 2022

Impressed with how applicable the course was. The teacher is very informative and shares many useful formulas/charts using real business scenarios.

JF

5.0Reviewed Aug 31, 2021

Perfect intro. The instructor made things clear and gave different samples in the guided project to give enough opportunities to try the skills.

HT

5.0Reviewed Mar 17, 2022

This course will make you ready to some new skills like data analyse and data science. It was good for me and I'm really like that.

YS

4.0Reviewed Mar 21, 2021

Delivers exactly what is promised. Instructions are clear and crisp. Learning by doing is what this course is all about.

MD

5.0Reviewed Aug 11, 2020

An amazing course that gives you knowledge as well as instills curiosity for life-long learning in the field of Data Visualisation.

All reviews

Showing: 20 of 135

�Sadman Sakib Rakin
5.0
Reviewed Sep 15, 2021
98yu Yu
3.0
Reviewed Sep 2, 2021
Olivia Anthony
2.0
Reviewed Nov 9, 2022
Jennifer Taylor-Monteagudo Mora
1.0
Reviewed Apr 11, 2023
jeanette goldman
1.0
Reviewed Jan 20, 2022
Matthew T Norris
5.0
Reviewed Sep 23, 2022
Arya Shah
5.0
Reviewed Aug 10, 2020
Lukman Aliyu
5.0
Reviewed Feb 21, 2022
Kevin Chamalé
5.0
Reviewed Sep 12, 2021
Siddhartha Nagar
5.0
Reviewed Sep 4, 2020
Mamie
5.0
Reviewed Mar 9, 2022
Shahid Hussain Soomro
5.0
Reviewed Aug 3, 2020
Thanh Vân Tôn Nữ
5.0
Reviewed Apr 18, 2023
Nelly Bels
5.0
Reviewed May 14, 2022
Gustavo Rodríguez
5.0
Reviewed Apr 5, 2023
Jamie Fitzpatrick
5.0
Reviewed Sep 1, 2021
YANISE ALCIME
5.0
Reviewed Dec 27, 2021
Hamid Tousinezhad
5.0
Reviewed Mar 18, 2022
Mohit Dhamor
5.0
Reviewed Aug 12, 2020
McMensah Jonathan
5.0
Reviewed Jul 2, 2023