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

Using data validation controls view medal tallies

Using data validation controls to pick from a list

Using conditional formatting on a dashboard 

Setting up a basic dashboard

Creating a column chart from your data

Setting up your worksheet with formulas of reference

Charting the medal statistics

Setting up your data

Getting started

Format dates and numbers

Business Intelligence and Using Dashboards

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

Creating a column chart for your dashboard

Format chart, axis titles and series

Axis, gridlines, and changing the plot

Removing a series

Changing the plotted range

Named ranges

Using named ranges

Summing using a named range

Averaging using a named range

Efficient Column Charts

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

Format numbers within your dataset

Using VLOOKUP with data validation

Creating and testing the data validation

Adding the calculation

Creating the line plot

Formatting your line chart

Chart titles, axis, font, gridlines

Other formatting options

Dashboard Controls

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

Histograms

Inserting the VLOOKUP

Creating a histogram on the dashboard

Formatting your histogram

Candlestick charts

Changing your dates to text

Creating the candlestick for the dashboard

Formatting the candlestick

Scatter charts

Creating a scatter chart

Formatting your scatter chart

Sparkline charts within a cell

Sparklines

Changing the color of your sparkline

The column sparkline

Other Charts for Your Dashboard

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

Creating a simple rule to highlight cells 

Highlighting cells between a range

Using formulas and tidying up the dashboard

Using a custom formula to highlight a row

Highlighting duplicates

Using wildcard characters to highlight dates

Change a condition in a format

Congratulations

Conditional Formatting

一张图胜过千言万语——前提是图选得对！本课程将带您掌握在 Google Sheets 中进行数据可视化的基础。您将学习如何创建常见图表类型，如柱状图、直方图和散点图，以及更进阶的类型，例如迷你图（sparkline）和蜡烛图。您还将了解如何准备数据，并使用 Data Validation 和 VLookup 公式，将特定数据用于绘图。您会学习通过 Conditional Formatting 按条件为单元格或单元格区域应用格式，最后创建在同一处呈现图表与数据的仪表板。课程中将使用奥运会、鲨鱼袭击，以及来自 ASX 的海洋技术等数据。

一张图片胜过千言万语——但前提是你用对了图片！本课程将教你使用 Google 表格进行数据可视化的基础知识。

<h2>图表创建技巧</h2>
在本课程中，你将首先学习如何创建各种常见图表类型，包括条形图、直方图和散点图。 您不仅会掌握这些基本图表类型，还会深入了解更高级的选项，例如迷你图和蜡烛图。 这些工具对于高效的数据展示至关重要，能帮助你以易于理解的可视化形式传达复杂信息。 无论您是在分析销售数据、调查结果，还是任何其他类型的数值数据，这些图表制作技巧都将非常有价值。

<h2>数据管理与分析</h2>
数据准备是数据可视化的关键。 本课程将引导您使用数据验证和 VLookup 公式，精准定位用于制图的特定数据。 您将学习如何整理和筛选数据，以找到您需要的洞察。 此外，课程还涵盖条件格式的使用，这是一项 Google 表格中的强大工具，可让你根据特定条件将格式应用于单元格或单元格区域。 这项技能尤其适用于突出关键数据点、识别趋势，并使你的数据更易读、更具影响力。

<h2>仪表板创建与实际应用</h2>
课程的最后部分重点在于创建一个将图表和数据结合起来的综合仪表板。 仪表板对于汇总复杂数据集并提供关键指标的一目了然视图至关重要。 你将通过使用真实世界的数据集来应用你所学到的技能，例如奥运会信息、鲨鱼袭击记录以及来自澳大利亚证券交易所（ASX）的海洋技术数据。 这种实践导向的方法确保在课程结束时，你不仅能理解数据可视化背后的理论，还能在真实场景中获得应用这些技术的实际经验。

Intermediate Google Sheets

学习在Google表格中创建不同类型的图表，包括条形图、直方图、散点图、迷你图和K线图。

Google Sheets 数据可视化

使用 Google 表格学习数据可视化基础。 

Google 表格基础知识

Formatting the candlestick

Google Sheets 数据可视化

练习说明

动手互动练习