Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
0 Hour(s) 41 Minute(s)
Language
English
Taught by
Joel Grosjean
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
1 views
Course Overview
Creating a dynamic page with custom user input
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!
Course Content
- 5 section(s)
- 5 lecture(s)
- Section 1 Introduction
- Section 2 Filtering Data
- Section 3 Sorting Data
- Section 4 User Interface
- Section 5 Bonus!
What You’ll Learn
- filter and sort data
- Display charts based on selected data criteria
- Design clean, user-friendly interfaces
Skills covered in this course
Reviews
-
NNathan Wainwright
Course material really needs to be updated for 2025; the date you include now is very stale, and had to sort out what new value for "365" should be used. But also the method for drop down setup has changed dramatically. Overall great course, would be 5 stars with an update/refresh of information.
-
SShubhamagrawal
I am really Grateful for your teachings . Very Nicely Expalined . Thankyou so much
-
RRazif
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.
-
KKenneth Preston
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.
