Academy ↓
Hey there stranger!
Sign up to get access.
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
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
Create Drop Shadows! This makes your dashboards pretty.
00:12:04
Sheet Stories / Video Notes + ADDED: Email Notifications
00:00:00
Fast FAQS
ChatGPT Clone in Google Sheets Part 2
Create an Internal Google Sheets Add-on
Why Different Cell References in AI Integration in Sheets?
Show Sheet Tabs Based on Edit
Add Title Case to Google Sheets
Getting Started Coding in Apps Script
How to Power Testimonials with Google Forms and Sheets
Seek Errors When Coding Apps Script
Think Like a Programmer: Develop The Mindset of an Apps Script Coder
ChatGPT Clone in Google Sheets Part 1
Embed a Number in a Website from a Google Sheet
Create Navigation Like A Book or Presentation
Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet
00:29:08
Hold a Giveaway Raffle in a Google Sheet
Capture Emails from Website Form to a Google Sheet (Without Zapier)
Embed a Headline in a Website from Google Sheets
Quickstart Tutorial OpenAI API in Google Sheets
Create a new Spreadsheet from just a Name in a Sheet.
00:05:21
Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?
00:05:43
Email Yourself a Cell from a Google Sheet, Every Day
OpenSea Data Inside Sheets
Create an Email Campaign Stats Calculator
00:35:13
Twitter App Clone in a Google Sheet
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
Sync Two Tabs Without ImportRange()
Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.
00:00:00
Password Protecting Data In a Google Sheet Part 2 The Basics
Benoit Asks: How to Convert Case
00:07:35
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. Create quick search dropdown to find keywords
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
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
Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop
00:23:26
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 Apps Script
00:15:01