Data Visualization in Google Sheets

Start Free Preview

Buying via our links supports this free directory · Affiliate disclosure.
Course facts
  • Payment: Free Preview (Paid Upgrade)
  • Learning style: Self-paced, start anytime
  • Format: Text & Interactive
  • Video access: Streaming Only
  • Before you start: Intermediate Google Sheets
DataCamp details
  • Chapters: 5
Created byDataCamp
Available onDataCamp

Course Details
Learning Style

Start Anytime

Level

Beginner

Study Mode

100% Online

Duration

Short (< 10 Hours)

Languages
Audio Language

English

Outcomes
Certificate

Certificate of Completion

Price & Terms
Pricing Model

Free Preview (Paid Upgrade)

Technical
Content Medium

Text & Interactive

Video Access

Streaming Only

Specification
Access

Subscription

SKU: data-visualization-google-sheets Category: Tags: , , , Brand:

Build an interactive Google Sheets dashboard with column, line, scatter and candlestick charts, list controls, VLOOKUP and conditional formatting rules.

At a glance
Duration4 hrs
LevelBeginner
CertificateCertificate of Completion
LanguageEnglish
Taught byRaina Hawley
AccessSubscription
Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare

Google Sheets can turn rows of figures into a dashboard that someone else reads at a glance, but only when each chart suits the data behind it. You set up a dashboard around Olympic medal statistics, match chart types to the question being asked, give a viewer a list control for choosing what to display, and apply rules that reformat cells as their values change. Along the way you prepare the source data and format each chart’s titles, axes and gridlines.

What You Will Achieve

  • Match a chart type to your data and format its titles, axes and gridlines so the result is easy to read
  • Build a dashboard where a viewer picks an item and the linked formulas and charts update
  • Refer to cells by name to write cleaner sum and average formulas
  • Write rules, including custom formulas, that highlight rows, duplicates or values within a set range


Program Overview

Dashboard Setup and Column Charts

Prepares the worksheet and its data for a basic dashboard, then builds and formats a column chart and introduces named ranges.

  • Sheets as a business intelligence platform
  • Formatting dates and numbers in the dataset
  • Column chart titles, axes, gridlines and series
  • Named ranges for sums and averages

Dashboard Controls and Other Charts

Adds data validation lists that drive VLOOKUP calculations, then fills the dashboard with charts suited to different situations.

  • Data validation combined with VLOOKUP
  • Line plots and histograms
  • Candlestick charts and dates converted to text
  • Scatter charts and in-cell sparklines

Conditional Formatting Rules

Sets formatting rules that react as dashboard values change, and ends by tidying up the finished dashboard.

  • Simple highlight rules and value ranges
  • Custom formulas that highlight a row
  • Duplicates and wildcard characters for dates
  • Editing an existing condition

Certificate Awarded (Paid)


Job Outlook

Spreadsheet charting and dashboard building are used in reporting, sales and survey analysis, and business intelligence work, wherever a team needs its key figures summarized in a single view.


Our take

Good for: Spreadsheet users who already handle formulas in Google Sheets and want to present their figures as an interactive dashboard.

Keep in mind: Despite the beginner label, the course builds on earlier Google Sheets study and expects you to be comfortable with the program and its formulas before you start.

Bottom line: A dashboard-centered Google Sheets course that ties chart choice, list controls and rule-based highlighting into one working sheet.

Frequently Asked Questions

Which charts end up on the dashboard?

The dashboard gathers a column chart, a line plot, a histogram, a candlestick chart and a scatter chart, plus sparklines placed inside single cells, including the column sparkline. Most of the charts get their own formatting lesson, covering items such as titles, axes, fonts and gridlines.

Which records feed the dashboard exercises?

Olympic medal tallies drive the early dashboard lessons. The exercises also draw on shark attack records and Marine Technology data from the ASX, the Australian Securities Exchange.

How does a viewer change what the dashboard shows?

Data validation creates a list the viewer chooses an item in. VLOOKUP then pulls the matching values into the calculations, so charts such as the line plot and the histogram redraw for the chosen item.

What can the conditional formatting rules highlight?

The rules highlight cells that meet a simple condition, values that fall between two limits, a whole row through a custom formula, duplicate entries, and dates matched with wildcard characters. A later lesson shows how to change the condition of an existing rule.

User Reviews

0.0 out of 5
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0

No reviews yet. Be the first to review this course.

There are no reviews yet.

Write your review

Reviews can only be posted by registered learners. Log in, then you will return here to post.

×

    Report this page
    Data Visualization in Google Sheets
    Data Visualization in Google Sheets
    LiveTalent
    Logo
    Compare items
    • Total (0)
    Compare
    0