Google Sheets - Dashboard Design

Creating a dynamic page with custom user input

3.85 (93 reviews)
Udemy
platform
English
language
Google
category
instructor
Google Sheets - Dashboard Design
518
students
42 mins
content
Jun 2019
last update
$24.99
regular price

What you will learn

filter and sort data

Display charts based on selected data criteria

Design clean, user-friendly interfaces

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!

Content

Introduction

Introduction

Filtering Data

Filtering Data

Sorting Data

Sorting Data

User Interface

User Interface

Bonus!

Dynamic Charts

Reviews

Razif
March 27, 2022
Good course, i have learnt many new things about Google Sheet that i never knew before. Thank you so much for sharing. Have to repeat the videos in order to master it.
Kenneth
July 24, 2021
I think this is a great quick course for anyone who has a good handle on excel or google sheets. It is quick and to the point. It makes a perfect refresher. This is not meant to be an in-depth learn every single thing about google sheets course. With that said, buy this course if you literally want to start making dashboards and have fun experimenting afterward. This course saved me hours of time.
Derek
September 26, 2020
This is the weakest instruction I have seen on Udemy. The individual video modules are never named and the presenter never uses the name of the module. I had to determine what I was watching from the duration of the video. The presenter never explains anything in the context of what you are trying to achieve. Audio is awful. Sounds like an echo chamber.
Christine
March 24, 2020
It's short. It'd be nice if the instructor added some more lessons or dashboard options. Instead he dumped a random 30-minute assignment that you do on your own at the beginning. Not worth the $$, especially when you compare it to what some other instructors are offering on here and the time and effort they put in.
Steve
February 21, 2020
There was a lot of unnecessary typing of the formulas. Its much simpler to copy the work you have already completed and change the variables. Overall really well presented and the information was good. There was only one Section that had good sound quality, the others had a very loud echo like you were sitting in an empty auditorium.
Kari
January 27, 2020
I will need more in depth lessons to catch onto everything he was going over. A little hard to keep up but a good snap shot on what it can do.

Charts

Price

Google Sheets - Dashboard Design - Price chart

Rating

Google Sheets - Dashboard Design - Ratings chart

Enrollment distribution

Google Sheets - Dashboard Design - Distribution chart
1725794
udemy ID
6/1/2018
course created date
11/22/2020
course indexed date
Bot
course submited by