Google Sheets – Dashboard Design

Online Course. Creating a dynamic page with custom user input.

What you’ll learn?

  • Filter and sort data.
  • Display charts based on selected data criteria.
  • Design clean, user-friendly interfaces.

Requirements:

  • Able to navigate the internet.
  • Able to use a computer.

Description:

In this course, we will cover how to filter and sort information to build an easy summary page of data. You will have access to the same source file, and in 45 min, you will understand how to turn raw data into meaningful information. In the last lesson, we will explore how to build customizable, dynamic charts, build from user input. 

We will explore this through building a dashboard from Google Sheets. In this course, you will learn to use the following functions pre-built into Google Sheets:

  • Unique()

  • Filter()

  • Sort()

  • array_constrain()

  • IsBlank()

Come and explore the wonderful world of spreadsheets as I guide you through the often murky waters of formulas and dynamic designs. No need to be intimidated any longer! Through these 5 formulas, you will have access to countless designs and applications and have powerful tools to create professional looking spreadsheets and dashboard!

Who this course is for:

  • Anyone looking to streamline data analysis

See more Google Sheets Courses

See also...

Learn Excel for Health Care Professionals Online Course for Health Economists

Learn Excel for Health Care Professionals

Online Course. Learn how to use Excel for your next research or quality improvement project. ... Read more

Das ultimative Excel Kurs Komplettpaket online course for health economists

Das Ultimative Excel Kurs Komplettpaket

Online Course. Der ideale Excel Kurs für Beginner und fortgeschrittene Excel Nutzer, die zeitsparender & ... Read more

Getting Started with Python – Online Course

Getting Started with Python

Online Course. This course aims to teach everyone the basics of programming computers using Python. ... Read more

Introduction to Microsoft Excel VBA Online Course for health economists

Introduction to Microsoft Excel VBA

Online Course. Learn Microsoft Excel VBA Fundamentals (Excel 2010, 2013, 2016) What you’ll learn? Requirements ... Read more

The Complete Presentation and Public Speaking/Speech Online Course

Presentation and Public Speaking

Online course. From page to stage; learn everything you need to know about giving a ... Read more

Taming Big Data with Apache Spark and Python

Big Data with Apache Spark and Python – Hands-On Online Course

Dive right in with 15+ hands-on examples of analyzing large data sets with Apache Spark, ... Read more

Categories

Tags