Author: bazroberts

Organising data effectively is essential when working with Google Sheets. Whether you’re sorting performance figures, class lists, or creating randomised groups, Sheets offers flexible sorting and randomisation tools. In this post, we’ll walk through sorting your data numerically or alphabetically, sorting with and without headers, and look at how to randomise data. How to sort… Continue reading How to quickly sort data in Google Sheets

Filtering data in Google Sheets allows you to focus on what matters most in your datasets. Whether you’re identifying patterns, narrowing down results, or creating reusable views, filters are invaluable. In this post, we’ll explore how to use basic filters, filter by colour and condition, and harness the power of Filter Views to customise and… Continue reading Mastering Filters and Filter Views in Google Sheets

Google Sheets is like a book of grid-patterned pages, with each page represented as a tab at the bottom of your screen. These tabs act as individual pages, allowing you to organise different sets of data in one file. Let’s explore how to manage these tabs to make the most of your spreadsheets. How to… Continue reading Working with Multiple Sheets in Google Sheets

In this post, I’ll give you an overview of the ways of moving, copying, and pasting data in Google Sheets. Starting with the basics, we’ll then explore more advanced tips, such as paste special options and sequential numbering, to save time and streamline your workflow. Moving Cells You can move cells with two options: drag-and-drop… Continue reading Google Sheets: Moving, Copying & Pasting Data

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