Data Visualization in Spreadsheets

Course Cover

5

(3)

compare button icon

$12

$6

49% OFF

Visit Course

Visit Course

Course Features

icon

Duration

4 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Mobile, Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

4 hours

Course Description

A picture can convey a thousand words but only if it is the right one. This course will show you how to use Google Sheets for data visualization. You will learn how to create simple chart types, such as histograms, scatter charts and bar charts. Also, you'll learn how to create more complicated types like sparkline or candlestick. How to prepare data, how to use Data Validation and VLookup formulas, and how to target specific data when charting. Conditional Formatting allows you to apply a particular format to a cell or range of cells based on specific criteria. You will also learn how to create dashboards that display data and plots together. Data from the Olympics, shark attacks, and Marine Technology from ASX will also be used.

Course Overview

projects-img

Virtual Labs

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

check-card-img

Intermediate Spreadsheets

What You Will Learn

check-card-img

Learn the fundamentals of data visualization using spreadsheets

check-card-img

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

check-card-img

You'll use data from the Olympics, sharks attacks, and Marine Technology from the ASX

Course Instructors

Author Image

Raina Hawley

Owner/Instructor, OzGrid Business Applications

Raina Hawley from Australind, Western Australia is a professional Microsoft Excel consultant whose company, OzGrid Business Applications offers services in all aspects of Excel, and VBA for Excel. Oz...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%

Course Cover

$12

$6

49% OFF

Visit Course

Visit Course