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

ChatGPT Masterclass: ChatGPT Guide for Beginners to Experts!

ChatGPT Profit Playbook: Skyrocket your Online Earnings with AI Tools. ChatGPT Implementation, Plugins, Content Mastery. ... Read more

Resume Writing and LinkedIn Profile Optimization Online Course for health economists

Resume Writing + LinkedIn Profile Optimization

Online Course. Writing Your Resume (CV) & LinkedIn Profile Using SEO Techniques For Your Job ... 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

Complete Web Automation with Excel VBA online training course for health economists

Complete Web Automation with Excel VBA

Online Course. Fill Out Web Forms Dynamically, Navigate Web Pages Intuitively, And Extract & Manipulate ... Read more

Online Course: Unlock Excel VBA and Excel Macros

Unlock Excel VBA and Excel Macros

Why health economists should take this course? Are you a health economist building budget impact ... 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

Categories

Tags