Tutorial: Charts and Dashboards in Google Sheets

4.7
stars
178 ratings
Offered By
Coursera Project Network
4,876 already enrolled
In this Free Guided Tutorial, 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.

Showcase this hands-on experience in an interview

Clock2 hours
BeginnerBeginner-friendly
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

In this 2-hour long guided tutorial, 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 tutorial 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.

Requirements

Familiarity with Google Sheets or Microsoft Excel is helpful but not required.

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 Tutorials 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 TUTORIAL: CHARTS AND DASHBOARDS IN GOOGLE SHEETS

View all reviews

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.