79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

This tutorial is not available for free users. Please purchase a subscription to view this tutorial.

Hey there stranger!

Please sign-up or sign-in to watch this tutorial.

Unique Features - Design a Better Dashboard Part 2

About this Tutorial

We're gonna talk about some features that we're gonna be using that might be new to you, or, just remind you that we're gonna use them to make 'em very interesting and unique to, using dashboards.

Video Transcript

 Hi, uh, welcome to part two. We're gonna talk about some features that we're gonna be using that might be new to you, or, um, just remind you that we're gonna use them to make 'em very interesting and unique to, uh, using dashboards. But just before that, I wanna review the notes. The reason we're using these features are to be able to lead the eye to that necessary information.

We're only gonna show necessary information in the way that we need to show it. We're also gonna keep a lot of data or math equations out of view, and we're also gonna show not just the data, not just the actual number where app, we're gonna show that comparison. Delta changes between, uh, month over month time periods, week to week.

Daily, we can do a lot of different comparisons, but we're gonna show the data plus that comparison. And these help us. So first I just wanna remind you that we can set our own colors. Uh, when you're creating a dashboard, even in Google Sheets, one of the simplest and sort of lazy and easiest things to do is to create just black and white information.

But if you set your own colors for your business, Hey, you can even screenshot that and, and share that in, uh, emails. Instead of having to share a Google sheet, you can just share a really nice, uh, uh, version. Or you can even, um, if you have, uh, some interesting charts you can make in Google sheets, in your colors, and then share them on like LinkedIn publicly if you wanna share certain, uh, information.

But also it makes it, uh, feel better and closer to your branding if you have even a small company, 3, 4, 5 people, or even up to 10 people. Um, as long as you're working within your own colors and you see these colors all the time, it makes you feel like you're part of, you know, a team. Um, we're gonna use conditional formatting.

Uh, this is really good for, uh, sort of creating heat maps and creating, um, types of, um, comparison without having, uh,  in addition to seeing the numbers. Uh, so you see some liquidations of colors, but you can also, um, create some interesting things with conditional formatting. Um, and you might have seen my other, uh, video.

I do a lot of more interesting creative use of conditional formatting. There all, there's like a whole video all about conditional formatting. Uh, this gauge chart is a rather interesting chart. You can set the colors on it, you can set its minimum maximum, and. This, just like I was talking about in the last video, is speedometer where you can use this to see if an some piece of information or some data is within a good range.

Or if it's like too much or too little, um, and you can use this, uh, literally in your dashboard. Um, I'm also gonna share with you these characters. This is an up and down Chevron, I think, and I think they're actually like other, I think they actually have a real name, like a, it's probably some kind of accent, but we're gonna use it as an up chevron and a down Chevron to show up and down.

We can actually, uh, even color these right now. This isn't a fun of Forta, but we can change this to. Be any style and why I share the character number is because the way we get it is literally doing this formula equals C H A R for character, uh, and then 7 0 8 for up and 7, 0 9 for down. This is going to help us showcase.

um, that those deltas, right? If we see something going up or down, we're gonna a, see the number is up, uh, a positive. We may see a number that's negative, or we may just see two numbers and we don't know if it's going up or down based on. Our temporal or like time, right? Week, week, week over week or month over month.

Um, this helps us literally see, oh, we're on Upward Slope. We'll also create some little charts, um, some spark lines maybe. Um, I have a whole, um, video series on a progress bar. We're probably gonna skip that because that's in the other video. But we might, um, we may jump into some other things when we build a dashboard.

So these are all the features we're gonna. Uh, go through it and, uh, I'll see you in the next video to actually build the dashboard.


Sheet Stories / Video Notes + ADDED: Email Notifications



Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet



Getting Started Coding in Apps Script

Seek Errors When Coding Apps Script

Think Like a Programmer: Develop The Mindset of an Apps Script Coder

ChatGPT Clone in Google Sheets Part 2

ChatGPT Clone in Google Sheets Part 1

Quickstart Tutorial OpenAI API in Google Sheets

Embed a Number in a Website from a Google Sheet

Create Navigation Like A Book or Presentation

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?


Embed a Headline in a Website from Google Sheets

Capture Emails from Website Form to a Google Sheet (Without Zapier)

Hold a Giveaway Raffle in a Google Sheet

Create a new Spreadsheet from just a Name in a Sheet.



Email Yourself a Cell from a Google Sheet, Every Day

OpenSea Data Inside Sheets


Shwitter | Twitter in a Google Sheet

Create an Email Campaign Stats Calculator


Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Highlight Row as You Move Your Cell Selection

Create a Timer with Apps Script

LinkTree in a Google Sheet


Password Protecting Data In a Google Sheet

Automatic Weekly Backup of Google Sheets

Create a CPM Custom Function (Create Better Calculators!)

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script


What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users


Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.


Sync Two Tabs Without ImportRange()

Password Protecting Data In a Google Sheet Part 2 The Basics

Benoit Asks: How to Convert Case



Learn to Code in Google Sheets, For Programmers

Add a Checkbox to Turn on Dark Mode


Write Your First Script


Find Keywords in Any Column, And create a quick search dropdown to find them.


Basic CRM - Add a Powerful Script To Move Row Based on Status

How To Improve: 1,000 Business ideas: Business Idea Generator


Let's Make a Bookmarklet!


Troubleshooting Bitly in a Google Sheet Script


Unique Features - Design a Better Dashboard Part 2



How To Set Up Stripe Webhook to Google Sheets with Google Script


How to Edit a Macro


Sheet Stories / Video Notes + Clear 24 Hour Old Videos


Add A Timestamp to Task Lists (without Now Formula)


Make your Custom Functions Like Native Functions | Custom Function Autocomplete



Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop



New Syntax for WhatChanged Formula in Google Script


How to Record Macros


2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)


Deep Inside Dark Habits Google Script


How to Trigger Macros Daily


5 Ways to Create Coupon Codes | Create UUIDs

Create a Radio Button From Checkboxes Using Google Script