79% OFF online library of tutorials for mastering Google Sheets
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
Video Transcript
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.
Topics
Courses
Dashboard Principles - Design a Better Dashboard Part 1
00:05:33
Unique Features - Design a Better Dashboard Part 2
00:04:13
3
Create Square Cells for Dashboards or Beautiful Information
00:08:15
Build The Dashboard - Design a Better Dashboard Part 3
00:18:47
Switch Months Menu - Design a Better Dashboard Part 4
00:07:23
Sheet Stories / Video Notes + ADDED: Email Notifications
00:00:00
2
Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet
00:29:08
3
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?
00:05:43
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.
00:05:21
16
Email Yourself a Cell from a Google Sheet, Every Day
OpenSea Data Inside Sheets
18
Shwitter | Twitter in a Google Sheet
Create an Email Campaign Stats Calculator
00:35:13
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
00:11:22
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
00:12:29
What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users
29
Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.
00:00:00
Sync Two Tabs Without ImportRange()
Password Protecting Data In a Google Sheet Part 2 The Basics
Benoit Asks: How to Convert Case
00:07:35
33
Learn to Code in Google Sheets, For Programmers
Add a Checkbox to Turn on Dark Mode
00:05:10
Write Your First Script
00:08:31
Find Keywords in Any Column, And create a quick search dropdown to find them.
00:09:37
Basic CRM - Add a Powerful Script To Move Row Based on Status
How To Improve: 1,000 Business ideas: Business Idea Generator
00:11:20
Let's Make a Bookmarklet!
00:12:37
Troubleshooting Bitly in a Google Sheet Script
00:07:07
Unique Features - Design a Better Dashboard Part 2
00:04:13
42
How To Set Up Stripe Webhook to Google Sheets with Google Script
00:22:10
How to Edit a Macro
00:08:22
Sheet Stories / Video Notes + Clear 24 Hour Old Videos
00:35:10
Add A Timestamp to Task Lists (without Now Formula)
00:07:44
Make your Custom Functions Like Native Functions | Custom Function Autocomplete
00:17:58
47
Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop
00:23:26
48
New Syntax for WhatChanged Formula in Google Script
00:07:14
How to Record Macros
00:06:20
2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)
00:09:53
Deep Inside Dark Habits Google Script
00:18:54
How to Trigger Macros Daily
00:06:58
5 Ways to Create Coupon Codes | Create UUIDs
Create a Radio Button From Checkboxes Using Google Script
00:15:01