A chart truly is worth a thousand numbers! In this post, we’ll explore how to create and customise charts in Google Sheets to transform raw data into compelling visuals. How to create a chart in Google Sheets To create a chart, start by selecting the data you want to visualise, then click the Insert Chart… Continue reading Create charts in Google Sheets with ease
Author: bazroberts
Chart your data with Sparklines in Google Sheets
Charts can simplify complex data, allowing us to quickly identify trends and make informed decisions. Sparklines in Google Sheets are a powerful tool for visualising data within cells. These mini-graphs are easy to create and customise, making them perfect for dashboards or reports. Let’s explore how to use sparklines effectively. How to insert sparklines to… Continue reading Chart your data with Sparklines in Google Sheets
Google Workspace 2024 Recap (Pt 2)
In this second part of the 2024 Google Workspace recap, (Part 1 here) we delve into exciting updates to tools like Google Forms, Docs, Slides, and the innovative Google Vids and Notebook LM platforms. From enhanced organisation features to AI-driven content creation and improved presentation tools, these updates empower users to collaborate, communicate, and create… Continue reading Google Workspace 2024 Recap (Pt 2)
Google Workspace – 2024 Recap (Pt 1)
In 2024, Google Workspace unveiled a host of updates across its suite of apps, aimed at enhancing productivity, collaboration, and user experience. This post summarises the key improvements to Google Chat, Drive, Sheets, and Meet. Google Chat Huddles for Quick Calls Chat introduced “huddles,” a feature powered by Google Meet that allows users to initiate… Continue reading Google Workspace – 2024 Recap (Pt 1)
Master Conditional Formatting in Google Sheets in Minutes
Conditional formatting in Google Sheets allows you to highlight key data automatically based on rules you set. Whether you’re marking exam results, tracking performance, or analysing trends, it simplifies your work by visually emphasising important points. This quick guide walks you through setting up basic and custom formatting to make your Sheets more effective and… Continue reading Master Conditional Formatting in Google Sheets in Minutes
How to quickly sort data in Google Sheets
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
Mastering Filters and Filter Views 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
Working with Multiple Sheets 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
Google Sheets: Moving, Copying & Pasting Data
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
Alternating Row colours in Google Sheets
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