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

Complete Python Bootcamp: Go from zero to hero in Python 3 online course for health economists

Complete Python Bootcamp: Go from zero to hero in Python 3

Learn Python like a Professional! Start from the basics and go all the way to ... Read more

Online Course: Ultimate Excel VBA

Ultimate Excel VBA

Online Course. This is an introductory course on how to program Excel using VBA macros. ... Read more

Excel VBA - How to Write Macros Like a Professional online course for health economists

Excel VBA: How to Write Macros Like a Professional

Online course. Learn how to write real-world Excel VBA Macros from scratch. No experience required! ... Read more

Online course: R Programming

R Programming

Online Course. R programming online course by the Johns Hopkins University. In this course, you ... Read more

Excel VBA - The VBA Beginner's Blueprint to Programming Excel online course for health economists

Excel VBA Beginner’s Blueprint to Programming Excel

Online course. You’re Minutes Away From Learning How To Program Excel. What you’ll learn? If ... Read more

Complete STATA Workflow

Complete STATA Workflow + Tips

Online Course. Master STATA for data management, graphs and data analysis with TIPS for the ... Read more

Categories

Tags