Great Sheets

Includes

11 Tutorials

About this topic
Get inspiration from reviewing and breaking down great sheets found in the wild.

Great Google Sheets. Get inspiration from reviewing and breaking down great sheets found in the wild. These are sheets that have great design, great usability. In these videos I break them down and reveal their secrets. Learn how to make great sheets yourself.


What Makes a Great Google Sheet?
Before we dive into specific examples of great Google Sheets, let's find out what makes a spreadsheet great. A great Google Sheet should have the following characteristics:
  • Clean and Clear Design: A great Google Sheet should have a clean, easy-to-read design that highlights the most important information. Allows the user to find what they are looking for, or accomplish the task they came to the sheet to do. 
  • Well Branded Design: A great design doesn't mean just adding ornamentation for the sake of it. It means that someone who uses your sheet knows it is an extension of your business, or community. They can tell you made it, it's for them, it's where they should be. A well branded designed sheet will make the spreadsheet experience seamless from your users other experiences with you.
  • Usability: A great Google Sheet should be easy to use and navigate. Users should be able to find the information they need quickly and easily. Navigation in complex sheets can be, well, complex. Make sure to think about what your user wants to do next, and where, and get them there.
  • Customization and Personalization: A great Google Sheet should be customizable to meet the specific needs of the user. In fact a personalized experience is important too. But this also can be related to communities. Does your user know this spreadsheet space is for them? If they can't tell, then you have some work to do. Not just that it's custom to a user, but that it's personalized and brings them joy!
  • Automation: A great Google Sheet should automate repetitive tasks to save time and increase efficiency. But not just timed and event based automations like triggers. There are simple faux-mations that you can create with Google Sheets Formulas. Formulas like IF() and ISBLANK() can be combined in wonderful ways.  These are formulas that create experiences that seem like automation.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

There’s no shortcuts to becoming a Google Sheets pro! Learn more here at Better Sheets

Watch the magic for yourself. Video tutorials at every turn here at Better Sheets.

Your spreadsheets will never be the same again.

At bettersheets.co/formulas, I have everything you need to take your Google Sheets skills to the next level. 
From ABS() to YIELD(), Better Sheets has it all. 

Better Sheets has got every crucial formula essential to enhance your Google Sheets skill

Tutorials

Great Sheets! Corona Hiring Sheet

Great Sheets! Corona Hiring Sheet

Reviewing a Corona hiring sheet. A great example of using Google Sheets....
Google Maps Scraper for Outreach

Google Maps Scraper for Outreach

Get this fun template to search on google maps via API, and quickly mess...
Create Your Own Pride Flag Easter Egg in Sheets

Create Your Own Pride Flag Easter Egg in Sheets

If you type the letters of PRIDE in the first 5 columns in the first row...
Life to Date

Life to Date

This is a review and improvement of Emmett Shear's Life to Date Sheet. O...
Visicalc 2023 Technical Walkthrough

Visicalc 2023 Technical Walkthrough

welcome to the technical walkthrough of VisiCalc 2023. This is the sheet...
How Starter Story Designs Data

How Starter Story Designs Data

Learn how Starter Story, and Pat Walls, created a report that is well de...
Great Sheets! Community Information Board by Seedtable.com

Great Sheets! Community Information Board by Seedtable.com

Incredible design and inspiration for us in our sheets.
Ali Abdaal's Google Sheet | Year at a Glance

Ali Abdaal's Google Sheet | Year at a Glance

Ali gave away a free Google Sheet Template. In this tutorial I step thro...
SubSpyHub Subreddit Scanner

SubSpyHub Subreddit Scanner

I built a subreddit search tool to keep track of subreddits with keyword...
HYPERLINK() IF() ISBLANK() SUBSTITUTE()
10 Things I Hate About Your Spreadsheets

10 Things I Hate About Your Spreadsheets

10 Things I Hate About Your Spreadsheets and how to fix them. Here is a ...
IF() ISBLANK() ISEMAIL() ISURL()
Study Better With Google Sheets

Study Better With Google Sheets

Made Ali Abdaal's study google sheet better.
COUNTA() GOOGLETRANSLATE() INDEX() RANDBETWEEN() VLOOKUP()