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

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

Tableau 2020 A-Z - Hands-On Tableau Training for Data Science online course for health economists

Tableau 2020 A-Z: Hands-On Tableau Training For Data Science!

Learn Tableau 2020 for data science step by step. Real-life data analytics exercises & quizzes ... Read more

Presentation training for a health economist

Improve Your Presentation Skills

Online Course. Improve your public speaking skills by using proven branding techniques to make your ... Read more

Advanced Excel Formulas and VBA Functions online course

Advanced Excel Formulas and VBA User Defined Functions

Online Course. Master advanced Excel mega-formulas combining multiple functions and learn to create your own ... Read more

Microsoft Excel Data Analysis and Dashboard Reporting Online Course for Health Economists

Microsoft Excel Data Analysis and Dashboard Reporting

Build Dynamic, Interactive Microsoft Excel Dashboards (Excel 2010, 2013, 2016) with a Best Selling Excel ... Read more

Excel VBA Programming - The Complete Guide Online Course for health Economists

Excel VBA Programming – The Complete Guide

Online Course. Automate your Excel workflow, accelerate your productivity, and master the fundamentals of programming ... Read more

Categories

Tags