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

A picture can tell a thousand words - but only if you use the right picture! This course teaches you the fundamentals of data visualization with Google Sheets. You'll learn how to create common chart types like bar charts, histograms, and scatter charts, as well as more advanced types, such as sparkline and candlestick charts. You will look at how to prepare your data and use Data Validation and VLookup formulas to target specific data to chart. You'll learn how to use Conditional Formatting to apply a format to a cell or a range of cells based on certain criteria, and finally, how to create a dashboard showing plots and data together. Along the way, you'll use data from the Olympics, sharks attacks, and Marine Technology from the ASX.

A picture can tell a thousand words - but only if you use the right picture! This course teaches you the fundamentals of data visualization with Google Sheets.

<h2>Chart Creation Techniques</h2>
In this course, you'll start by learning how to create various common chart types, including bar charts, histograms, and scatter charts. You'll not only master these basic chart types but also delve into more advanced options such as sparkline and candlestick charts. These tools are essential for effective data presentation, allowing you to convey complex information in an easily digestible visual format. Whether you're analyzing sales data, survey results, or any other kind of numerical data, these charting techniques will be invaluable.

<h2>Data Management and Analysis</h2>
Data preparation is key in data visualization. This course guides you through the use of Data Validation and VLookup formulas to precisely target specific data for charting. You'll learn how to organize and sift through your data to find the insights you need. Additionally, the course covers the use of Conditional Formatting, a powerful tool in Google Sheets that enables you to apply formats to cells or ranges based on certain criteria. This skill is particularly useful for highlighting key data points, identifying trends, and making your data more readable and impactful.

<h2>Dashboard Creation and Real-world Applications</h2>
The final part of the course focuses on creating a comprehensive dashboard that combines plots and data. Dashboards are essential for summarizing complex data sets and providing an at-a-glance view of key metrics. You'll apply the skills you've learned by using real-world data sets, such as information from the Olympics, shark attack records, and Marine Technology data from the ASX. This hands-on approach ensures that by the end of the course, you'll not only understand the theory behind data visualization but also have practical experience in applying these techniques in real-world scenarios.

Intermediate Google Sheets

Learn how to create different chart types, from bar charts, histograms, and scatter charts, to advanced sparkline and candlestick charts in Google Sheets.

Data Visualization in Google Sheets

Learn the fundamentals of data visualization using Google Sheets. 

Google Sheets Fundamentals

Averaging using a named range

Data Visualization in Google Sheets

Exercise instructions

Hands-on interactive exercise