Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google Sheets - Dashboard Design
Rating: 4.2 out of 5(101 ratings)
562 students

Google Sheets - Dashboard Design

Creating a dynamic page with custom user input
Created byJoel Grosjean
Last updated 6/2019
English

What you'll learn

  • filter and sort data
  • Display charts based on selected data criteria
  • Design clean, user-friendly interfaces

Course content

5 sections • 5 lectures • 41m total length

  • Introduction1:22

    In this course... learn to create Dashboard in google. Personally done for work functions saving countless hours of data analysis, understand and modify work-place practices, and helped pitch new ideas using data. 

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

Report abuse