Creating Dashboards in Google Spreadsheets

13 ratings
Offered By
Coursera Project Network
In this Free Guided Project, you will:

Learn how to cleanse data using the TRIM and CLEAN functions, understand and work with the SUBSTITUTE function and Data Validation

Understand and work with conditional formatting, VLOOKUP function, and how to visualize with Graphs and Charts

Understand and create Pivot Tables and Dashboards

Showcase this hands-on experience in an interview

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

In this 2-hour long project-based course, you will learn how to analyse data to draw business insights, Data cleansing, Data validation, conditional formatting, how to use pivot charts and tables, lookup functions, how to structure the business data to easily locate information and provide accurate and complete answers to the question.


No prior experience needed

Skills you will develop

Business IntelligenceData Analysis

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. Data Cleansing using the TRIM and CLEAN functions

  2. Working with the SUBSTITUTE function

  3. Understanding Data Validation

  4. Understanding Conditional Formatting

  5. Working with the VLOOKUP function

  6. Visualizing with Graphs and Charts

  7. Creating Pivot Tables

  8. Creating Dashboards

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



View all reviews

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.