Creating Dashboards in Google Spreadsheets

4.3
stars
11 ratings
Offered By
Coursera Project Network
In this 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

Clock2 hours
BeginnerBeginner
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.

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

Reviews

TOP REVIEWS FROM CREATING DASHBOARDS IN GOOGLE SPREADSHEETS

View all reviews

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.