YoVDO

Create Charts and Dashboard using Google Sheets

Offered By: Coursera Project Network via Coursera

Tags

Business Software Courses Data Visualization Courses Google Sheets Courses Pivot Tables Courses Slicers Courses VLOOKUP Courses Sparklines Courses

Course Description

Overview

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

Related Courses

Making Sense of Data
Google via Independent
Introduction to Spreadsheets and Models
University of Pennsylvania via Coursera
Comptabilité de gestion et pratique du tableur
Université Montpellier 2 via France Université Numerique
The Power of Data in Health and Social Care
University of Strathclyde via FutureLearn
Digital Media Analytics: Introduction
Purdue University via FutureLearn