Unique Features - Design a Better Dashboard Part 2

<div> 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.<br><br>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.<br><br>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. 80 Years In 1 Spreadsheet BEFORE YOUR SHEET GOES TO AI

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.<br><br>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. Roasting Google Sheets Gmail Declutter Engine How to Filter By Color in Google Sheets

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.<br><br>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. Make It Easier For Others To Use Your Google Sheets YOU CAN DO BETTER

Um, we're gonna use conditional formatting .<br><br>Uh, this is really good for, uh, sort of creating heat maps and creating, um, types of, um, comparison without having, uh,&nbsp; 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.<br><br>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 . Upsides and Downsides of Google Sheets Conditional Formatting Messy Sales Pipeline CLEANED UP

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 .<br><br>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. BEFORE YOUR SHEET GOES TO AI

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.<br><br>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.<br><br>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.<br><br>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 . How To Make That Viral Growing Plant Progress Chart Week 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 .<br><br>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 .</div>