Blog » Google Sheets – Dashboard Design

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...

Statistics for Data Analysis Using Excel 2016 Online Course for health economists

Statistics for Data Analysis Using Excel

Online Course. Plain & Simple Lessons on Descriptive & Inferential Statistics Theory With Excel Examples ... Read more

Writing in the Sciences Online Training Course for health economists

Writing in the Sciences

Online Course. We, health economists, are “number” persons. Most of us don’t like writing. Yet, ... Read more

Fundamentals of Machine Learning for Healthcare online course for health economists

Fundamentals of Machine Learning for Healthcare

Online Course. This course will introduce the fundamental concepts and principles of machine learning as ... Read more

Introduction to Artificial Intelligence online course for Health Economists

Introduction to Artificial Intelligence (AI)

Online course. Learn what AI is. Explore cases and applications of artificial intelligence. Understand AI ... Read more

Artificial Intelligence Reinforcement Learning in Python online course for health economists

Artificial Intelligence: Reinforcement Learning in Python

Online Course. Complete guide to Reinforcement Learning, with Stock Trading and Online Advertising Applications. What ... Read more

Presentation training for a health economist

Improve Your Presentation Skills

Online Course. Improve your public speaking skills by using proven branding techniques to make your ... Read more

Categories

Tags