Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Coursera Project Network

Create Charts and Dashboard using Google Sheets

Coursera Project Network via Coursera

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
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.

Syllabus

  • Project Overview
    • In this guided project, you will learn how to clean your data sets and create effective charts and a dashboard to visualize these data sets. You will gain hands-on learning about how to clean raw data, perform basic functions and formulas like vlookups and pivot tables and create basic charts, find out duplicate data, and do some advanced analyses. By the end of this project, 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 visualize the data.

Taught by

Ishita Sinha

Reviews

4.7 rating at Coursera based on 562 ratings

Start your review of Create Charts and Dashboard using Google Sheets

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.