Google Sheets Tips and Tricks — Blog

How To Make That Viral Growing Plant Progress Chart

Imagine checking off tasks and seeing a cute little plant sprout right before your eyes. That's exactly what we're going to create today!

Oct 28, 2024

Word Tracker and Progress Tracker in Google Sheets

Ever dreamed of having a personal writing assistant right there in your Google Sheets? Imagine tracking your word count, setting goals, and watching your progress grow – all without leaving your favourite spreadsheet app. Well, your dream is about to come true! In this post, we're going to show you how to create your very own word counter and goal tracker using Google Sheets. It's super easy to set up, completely customizable, and perfect for keeping you motivated on your writing journey. L...

Oct 21, 2024

Name Match: Who's In and Who's Out

Let's say you have a master list with over 700 names and a new list from a recent meeting containing 175 names. How will you identify which names from the new list aren't on the master list so they can be added.

Sep 18, 2024

9 Google Sheet Tips for Affiliate Marketers

Learn how to apply formulas and calculations within Google Sheets in order to develop a tracking system for the effectiveness of your campaigns.

Sep 13, 2024

5 Google Sheet Tips for Admin Assistants

As an admin assistant, you could use this Google Sheets tutorial to get better at managing the frequent data manipulation tasks your job requires.

Sep 11, 2024

19 Google Sheet Tips for Administrative Assistants

Get better at google sheets to make your job easier.

Sep 4, 2024

4 Ways to Resize Columns, Change the Column Width in a Google Sheet

Adjusting column width is crucial for enhancing the readability and functionality of spreadsheets. Properly sized columns ensure that all data is visible without unnecessary scrolling or cutting off information, which can lead to errors or misinterpretations.

Aug 30, 2024

Explore Coding in Google Sheets

Did you know you can actually code in Google Sheets?

Aug 23, 2024

10 Simple Ways to Make Your Spreadsheets Better

Here's a few things you can do very simply and in no time at all, to make your spreadsheets better. Make better spreadsheets for you to spend time in. And better for other people who have to use your spreadsheets.

Jul 31, 2024

How To Hide Data with Checkboxes in Google Sheets

Checkboxes in Google Sheets are a game-changer. They add interactivity, flexibility, and functionality to your spreadsheets, making data management easier and more enjoyable.

Jul 26, 2024

A Decade of Spreadsheet Wisdom

10 years ago Timber was the #1 song... and I was coding in spreadsheets then, just as I am now. Learn from my decade of experience.

Jan 10, 2024

Exporting a Google Sheet to PDF – Why Do It via URL?

Turning your Google Sheet into a PDF is a great option when you need to create a quick snapshot of your spreadsheet data, or send a report. With the new free BetterSheets tool, there is now a faster and more replicable way to distribute your Google Sheets data in PDF form (via URL).

Nov 27, 2023