Members-only tutorial

Watch the video and get the practice sheet with membership.

See membership options

Consider Labels as Opposed to Headers

About this Tutorial

A quick video to share with you this theory. Consider repositioning your headers as labels in a dashboard.

Video Transcript

<div> Hey, sheet checkers. It's big sheet head here, Andrew. This is more of a design style video We're looking at headers Explore the difference between headers and labels in your sheets for better data presentation. Opens in new tab or what to do as opposed to headers Explore the difference between headers and labels in your sheets for better data presentation. Opens in new tab . And what I would like to show you is something interesting about labels. Consider labels instead of headers Explore the difference between headers and labels in your sheets for better data presentation. Opens in new tab . Typically we'll have, some kind of information up here, but the information we actually want to.<br><br>Give to someone is usually not the header Learn how headers can impact the readability of your data in dashboards. Opens in new tab , it's the data Understand the importance of data over headers in effective dashboard design. Opens in new tab involved.

And so how we would read this and again, this is totally normal absolutely normal to have a label Discover how query labels can enhance your data organization. Opens in new tab at the top and then data Understand the importance of data over headers in effective dashboard design. Opens in new tab underneath, but in a dashboard Get tips on designing dashboards that prioritize data clarity and engagement. Opens in new tab there's not really like a list of information. It's more. Single number Find out how to present numbers effectively in your sheets for better comprehension. Opens in new tab and how we would read this right, is, oh, this is the number Find out how to present numbers effectively in your sheets for better comprehension. Opens in new tab of subscribers.<br><br>There's 12,403. But in reality, we actually say something like, oh, there's 12,403 subscribers. And how we would read that is in our minds, we flip it, right? So sometimes we can do things like put this on the side. And this makes it more interesting or at least visually more interesting.

It makes everything on one line.<br><br>We can do this with multiple Things here. See, we can do this across, across horizontally. And that looks a lot interesting, a lot more interesting than the typical dashboard Get tips on designing dashboards that prioritize data clarity and engagement. Opens in new tab will look like a header Learn how headers can impact the readability of your data in dashboards. Opens in new tab and then the number Find out how to present numbers effectively in your sheets for better comprehension. Opens in new tab . But we can also go a little one, one more further and put it on the bottom.<br><br>And what this does is it draws our attention first, right? We read from the. Down. And so we read this as if we were reading this in our head. We have 12,403 subscribers. This is very different than I would ever say.

Putting like a list of information together. If you were had a list, there would be a completely different Visual way you wanna do this, but sometimes this actually will let people, obviously the first time people see this, they'll be weirded out.<br><br>But if you consistently do this and consistently create your dashboards Get tips on designing dashboards that prioritize data clarity and engagement. Opens in new tab like this it might actually get people to read the data Understand the importance of data over headers in effective dashboard design. Opens in new tab faster, right? 12,000 subscribers, $1,000 in revenue, $45 in sale, or 45 sales, right? This is how we read. Data Understand the importance of data over headers in effective dashboard design. Opens in new tab from top to bottom.

And this is actually the most important information at the top we have 45 sales, we have 12,000 subscribers or followers or whatever we're tracking in our dashboard Get tips on designing dashboards that prioritize data clarity and engagement. Opens in new tab .<br><br>And if you want to continue that horizontal we can put it on the side but on the right side so we can put it right here. And see what that looks like. That looks like a nice label Discover how query labels can enhance your data organization. Opens in new tab , right? Instead of a hitter this actually reads like a dashboard Get tips on designing dashboards that prioritize data clarity and engagement. Opens in new tab . And we can actually we can do that here as well.<br><br>Give it a little more white space, or in this case, green space, right?

And we do have to organize our sheet a little bit differently, right? We have to give it different places, different white space in different places. We need to add in a little bit of white space on the right. Which is fine. It takes a little bit of time, just like a moment to do this.<br><br>But now we have, we are reading not top to bottom and left to we are just reading left to 12,403 subscribers, $1,000 and $401,400 in revenue, $45 in sales. And this kind of dashboard Get tips on designing dashboards that prioritize data clarity and engagement. Opens in new tab as a label Discover how query labels can enhance your data organization. Opens in new tab allows us to read it as we do, as nor as normal humans read in the English.

Obviously there's other cultures and other languages that we'll read differently we'll read it left right to left, but this allows you to read it as English.<br><br>Hope you can find some really cool use cases for this bite.</div>

Courses

Better Than Happy | Redesign of The Feelings Wheel

Best Header Font Ever

Learn to Love Your Sheets

How Starter Story Designs Data

Sheet Review! 150 Active VCs by LemonIO

Anika Asks: How To Set Text Overflow All The Time

Introducing: Brutal Calendar

Add a Checkbox to Turn on Dark Mode

00:05:10

Create Drop Shadows! This makes your dashboards pretty.

00:12:04

10 Things I Hate About Your Spreadsheets

Merge Cells for Dashboards

00:05:29

Dark Mode / Better Font Color

00:09:35

Better Font Colors

00:02:45

Magical Things You Can do with Checkboxes in Google Sheets

00:12:31

How To Export Your Beautiful Sheets to PDF

00:04:06

Consider Labels as Opposed to Headers

00:04:02

Add Icons To Your Sheets With a Domain Name

00:04:21

How To Color Cell Blocks So Others Enter Data Easily

00:10:30

Great Sheets! Corona Hiring Sheet

00:10:43

Great Sheets! Community Information Board by Seedtable.com

00:07:35

Roast: Hotel PPC Channel Cost Calculator

00:11:25

Better Header Fonts - Best Fonts To Use In Google Sheets

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

00:09:49

Basic Keyboard Shortcuts To Speed Up Your Productivity

00:13:44

Basics - 5 Ways to Change Row Height

00:05:08

How to Refer to Other Cells - A1 and R1C1 Explained

00:13:22

Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

00:09:31

Change the Default Font

00:03:33

Biggest Flaw In Dashboards with Dark Colors

00:07:45

Basics - 4 Ways to Change Column Width

00:05:48

Basics - Structure of a Sheet: Index() Row() and Column()

00:06:49

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

00:08:55

Use Cmd + Y To Do It Again, and Again, and Again

00:03:03

Create an Auto-Update Sales Chart: Trailing 12 Months

00:09:57

Google Sheet Basics - The Absolute Basics

00:09:48

Secure Your Sheets by BetterSheets.co

00:11:07

How To Create An AutoFill in Google Sheets

00:06:07

Build a Thermometer for Savings Goals

Make Your Lists Spicy Hot in Google Sheets

00:01:47

Restrict Access to a Cell if Another Cell is Blank

How to Use Smarket

00:03:28

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

00:06:23

Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

00:53:31