Google Workspace Tutorials

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

In this post we’re going to see how to wrap text in Google Sheets, how to clip text, and how to just let it overflow, with the help of Nibbles the hamster and some revealing questions for our friends. Text overflow Normally, if you write too much in a cell you will see that it… Continue reading How to easily wrap text in Google Sheets

In this post, we’re going to look at how we can search in Google Sheets for specific text, numbers, formulae, and links. Search in Google Sheets Here we have a list of customers and we want to find any called “pott”. Press Ctrl + F and the search box will appear. Type in the search… Continue reading How to search in Google Sheets

In this post, we’re going to learn how to sort in Google Sheets. We’re going to see how we can sort data in one or more columns, and look at the different options that are available. How to sort data by one column Here we have a list of students’ exam results, which is a… Continue reading How to sort in Google Sheets

In this short post, we’re going to look at how to randomize a list of names. For example, a teacher may want to change the order of a group of students. First, select the cells you want to randomize. Then right-click on the range and then click View more cell actions > Randomise range. Alternatively,… Continue reading How to randomize a list in Google Sheets

In this post, we’re going to look how to merge cells, which combine cells multiple cells into one cell. This allows you to format the cell and can simplify your data and make it easier to read and understand. It’s often used for headers in tables or where you have long text which goes across… Continue reading How to merge cells in Google Sheets