For Beginners

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

5 Ways to Combine Names in Google Sheets

Ever found yourself stuck in a loop of copying and pasting names in Google Sheets? Let's face it, it's a task that can feel like a never-ending chore. But fear not, because I've got your back! So, we're diving into the world of Google Sheets and exploring five super-easy ways to combine first and last names into a single cell. No more manual labor, no more headaches. Imagine being able to whip up a list of full names in seconds, instead of spending hours on it. Sounds like a dream, right? We...

Oct 16, 2024

5 More Fixes For Your Spreadsheets

Hi, Andrew Kamphey here with Better Sheets, dedicated to helping you improve your Google Sheets every single day. Last time, I shared five ways to fix your sheets. So now, I've got five more tips to make your sheets even better. Let's dive right in! Change the Background Color Let's start by talking about color. While changing the font color is important, altering the background color can make a significant difference too, just follow these steps: 1. Select the entire background. 2. Hit...

Oct 14, 2024

Discover Misspelled Duplicates

The built-in feature can sometimes miss duplicates that have subtle differences, such as variations in spacing or formatting. Our formula-based approach, on the other hand, provides a more granular level of control

Sep 23, 2024

Easiest Mistakes to Make In Spreadsheets

When you start mixing unrelated data in the same rows or columns, it becomes harder to follow what’s going on.

Sep 20, 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

19 Google Sheet Tips for Administrative Assistants

Get better at google sheets to make your job easier.

Sep 4, 2024

Beginners Guide to Using Index, Row, and Column | Simply useful Google Sheets Formulas

You may be using Google Sheet to do math and find that you need to iterate a number. ROW() gets you the row you're on, and helps you with this.

Aug 14, 2024

The Double-Edged Sword of Google Sheets Formulas: A Journey Through Frustration and Triumph

A misplaced comma, an incorrect range, or a simple syntax error can render a formula ineffective, leading to hours of troubleshooting. Formula Parse Error, anyone?

Apr 9, 2024

Sheet Styles - A Free Google Sheet Add on by Better Sheets

Control design, optimize workflows, and enhance readability. Transform your Google Sheets experience with free add-on by Better Sheets.

Mar 17, 2023

The Best Google Sheet Tutorial for Beginners on the IF() Formula

Dive into Google Sheets with our free beginner tutorials on the powerful =IF() formula. Practical applications, templates, and tools included!

Mar 12, 2023

Spreadsheets Explained! 5 Levels of Difficulty: From Basic Text Input to Google Apps Script

Five increasingly difficult ways of explaining spreadsheets in Google Sheets: The basics of Google Sheets text Menu items in Google Sheets Math inside Google Sheets Using Formulas in Google Sheets Apps Script in Google Sheets

Dec 13, 2022