Google Sheetsで学ぶデータ可視化

基礎スキルレベル

更新日 2026/03

Google Sheetsでデータ可視化の基礎を学びます。

コース説明

前提条件

Intermediate Google Sheets

Business Intelligence and Using Dashboards

Learn about business intelligence and dashboards for analyzing information in todays data-driven world. Create a basic dashboard and master setting up your data to get the most out of it.

Using Sheets as a Business Intelligence platform

50 XP

Using data validation controls view medal tallies

100 XP

Using data validation controls to pick from a list

100 XP

Using conditional formatting on a dashboard

100 XP

Setting up a basic dashboard

50 XP

Creating a column chart from your data

100 XP

Setting up your worksheet with formulas of reference

100 XP

Charting the medal statistics

100 XP

Setting up your data

50 XP

Getting started

100 XP

Format dates and numbers

100 XP

チャプターを開始

Efficient Column Charts

Create and format a column chart to showcase data and learn a few smart tricks along the way. Look at using named ranges to refer to cells in your worksheet, making them user-friendly and easy to work with.

Efficient column charts

50 XP

Creating a column chart for your dashboard

100 XP

Format chart, axis titles and series

100 XP

Axis, gridlines, and changing the plot

50 XP

Removing a series

100 XP

Changing the plotted range

100 XP

Named ranges

50 XP

Using named ranges

100 XP

Summing using a named range

100 XP

Averaging using a named range

100 XP

チャプターを開始

Dashboard Controls

A dashboard is like a control panel. Look at ways to allow a user to use this control panel to get different results from your dashboard.

Data validation

50 XP

Setting up your data

100 XP

Format numbers within your dataset

100 XP

Using VLOOKUP with data validation

50 XP

Creating and testing the data validation

100 XP

Adding the calculation

100 XP

Creating the line plot

100 XP

Formatting your line chart

50 XP

Chart titles, axis, font, gridlines

100 XP

Other formatting options

100 XP

チャプターを開始

Other Charts for Your Dashboard

A picture paints a thousand words. Look at what types of charts to use in what situation to showcase your data.

Histograms

50 XP

Inserting the VLOOKUP

100 XP

Creating a histogram on the dashboard

100 XP

Formatting your histogram

100 XP

Candlestick charts

50 XP

Changing your dates to text

100 XP

Creating the candlestick for the dashboard

100 XP

Formatting the candlestick

100 XP

Scatter charts

50 XP

Creating a scatter chart

100 XP

Formatting your scatter chart

100 XP

Sparkline charts within a cell

50 XP

Sparklines

100 XP

Changing the color of your sparkline

100 XP

The column sparkline

100 XP

チャプターを開始

Conditional Formatting

Learn how to use rules based on criteria you set to format certain cells on your dashboard. See the formatting change as the values in the cells change.

Using conditional formatting

50 XP

Creating a simple rule to highlight cells

100 XP

Highlighting cells between a range

100 XP

Using formulas and tidying up the dashboard

50 XP

Using a custom formula to highlight a row

100 XP

Highlighting duplicates

100 XP

Using wildcard characters to highlight dates

100 XP

Change a condition in a format

100 XP

Congratulations

50 XP

チャプターを開始

Google Sheetsで学ぶデータ可視化

コース完了

修了証明書を取得

この修了書をLinkedInや履歴書、CVに追加しましょう
ソーシャルメディアや人事評価で共有しましょう今すぐ登録

Google Sheetsで学ぶデータ可視化

チームのトレーニングを担当していますか？

コース説明

前提条件

Business Intelligence and Using Dashboards

Efficient Column Charts

Dashboard Controls

Other Charts for Your Dashboard

Conditional Formatting

修了証明書を取得

19百万人を超える学習者と共にGoogle Sheetsで学ぶデータ可視化を始めましょう！

DataCamp for Mobileでデータスキルを磨きましょう

コース説明

修了証明書を取得

.css-nklxlk{color:var(--wf-brand--main, #03EF62);}19百万人を超える学習者と共にGoogle Sheetsで学ぶデータ可視化を始めましょう！

無料アカウントを作成

DataCamp for Mobileでデータスキルを磨きましょう

19百万人を超える学習者と共にGoogle Sheetsで学ぶデータ可視化を始めましょう！