Author: bazroberts

Rows of data without clear formatting can be hard to read, especially in large tables. Your eyes can get lost in the grid, making it challenging to follow information across rows. Thankfully, Google Sheets offers an easy fix: Alternating colours. This tool not only makes your data visually appealing but also improves readability. Here’s how… Continue reading Alternating Row colours in Google Sheets

Cell references in formulas allow you to create dynamic calculations which can save you time and enable you to use the formulas across different cells. It’s important to learn that there are two main types of referencing, Relative and Absolute, along with a third which is a mixture of the two. As we’ll see in… Continue reading Google Sheets Cell References – Absolute & Relative

Following on from the my post on rows and columns, let’s look at some more ways to control rows and columns in Google Sheets for a more organized sheet layout. Selecting Multiple Rows or Columns There are two easy ways to select multiple rows or columns. If the rows or columns are next to each… Continue reading Manage Sheets rows & columns like a pro

In this post, I’ll walk you through essential techniques to customize rows and columns, from resizing and selecting entire rows and columns to splitting text into columns. Let’s dive into these to help you better structure your Google Sheets for ease of use and readability. Check out my video which goes through how to use… Continue reading Mastering Rows and Columns in Google Sheets

Formatting data in Google Sheets When working with data in Google Sheets, formatting cells is key to making your spreadsheet clear and visually appealing. Whether you’re dealing with currency (e.g., $500 for rent), percentages (e.g., 15% for a discount), dates (e.g., 9/9/2024 for a deadline), or plain numbers (e.g., 123 for product quantities), applying the… Continue reading How to format data in Google Sheets

Cell formatting in Google Sheets is a simple but powerful way to make your data more readable and visually appealing. By customizing how your information looks, you can make patterns and insights stand out. Let’s dive into some key formatting techniques! For a detailed, step-by-step guide on how to apply these formatting techniques, check out… Continue reading Enhance your Google Sheets: Cell Formatting

Google Sheets is an incredibly powerful tool, capable of much more than just data entry. You can perform complex calculations, send emails, draw pictures, and even play games! However, before jumping into advanced functions, it’s important to start with the basics. Check out this video which covers all the basics: Creating a Google Sheet To… Continue reading Google Sheets – The Basics

Do you ever find yourself staring at a spreadsheet full of information, wishing there was an easier way to organize it? Well, fret no more! Google Sheets has a powerful tool called the Group By View that can help you quickly categorize and analyze your data in seconds. This post will walk you through the… Continue reading How to quickly group data in Sheets

Stop the Status Update Emails! Automate Notifications with Google Sheets. Tired of your team emailing you every time they complete a task? There’s a better way! Google Sheets can now send you automatic email notifications when data is changed, saving you and your team time. Learn how to set up this handy feature in this… Continue reading How to send automatic notifications from Sheets