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

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

Data Science, Analytics & AI for Business & the Real World online course for health economists

Data Science, Analytics & AI for Business & the Real World™

Use Data Science & Statistics To Solve Business Problems & Gain Insights Into Everyday Problems ... Read more

Beginners to Expert Excel and Excel VBA 38 Hours Mega Online Course for health economists

Beginners to Expert Excel and Excel VBA – 38 Hours Mega Course

Online Course. Learn Excel formulas, Pivot Tables, Excel VBA macros, charts and the basics with ... Read more

Excel Visual Basic Course for Health Economists

Excel VBA

Online Course. Bestselling online Excel Visual Basic course for experienced Excel users who want to ... Read more

Excel Macros & Excel VBA Programming for Beginners Online Course for health economists

Excel Macros & Excel VBA Programming for Beginners

Online Course. Did you know that Excel VBA expertise is the most frequently asked technical ... Read more

Excel Charts: Visualization Secrets for Impressive Charts Online Course for Health Economists

Excel Charts: Visualization Secrets for Impressive Charts

Online Course. Gain Highly Advanced Excel Skills to Create Impressive Excel Graphs for your Management ... Read more

Categories

Tags