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に追加する
SNSで共有し、評価面談でも活用しましょう今すぐ登録

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で学ぶデータ可視化を始めましょう！