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
Category: Sheets
How to randomize a list 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
How to merge cells 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
How to remove duplicates in Google Sheets
In this post, we’re going to look at how to remove duplicates from a list in Google Sheets. This will remove complete rows if they are found to contain a duplicate value. List with duplicated data Here, I have a list of imaginary subscribers and I want to remove any where the email address is… Continue reading How to remove duplicates in Google Sheets
How to add a calendar in a cell – Sheets
When working with spreadsheets we want to be able to enter data as quick as possible and to make it as easy as possible. Here, we’re going to delve into two practical methods for seamlessly integrating calendars into your spreadsheet cells. By utilising smart chips or data validation, I’ll show you how to speed up… Continue reading How to add a calendar in a cell – Sheets
Summary of Google Workspace 2023 new features (Pt 1)
In a bustling year of developments, the Google Workspace team introduced numerous new features and improvements across their suite of apps. Here’s a concise summary of my top picks that affected Sheets, Docs, Drive, and the new AI Bard. Sheets New functions Another 11 brand-new functions were added to Sheets, including LET, TOROW, TOCOL, WRAPROWS,… Continue reading Summary of Google Workspace 2023 new features (Pt 1)
How to use Mail Merge in Gmail to email multiple people
In today’s digital era, efficient communication is vital for success, whether you’re a professional, marketer, or simplifying email outreach. Picture effortlessly sending personalized emails to many recipients, transforming each message into a custom experience. No need to imagine— in this post you’ll learn how to use mail merge in Gmail and Google Sheets, a game-changer… Continue reading How to use Mail Merge in Gmail to email multiple people
How to set up data validation in Google Sheets
In this post, we’re going to look at how to set up data validation in Google Sheets as a whole and how it can be used to validate different types of data being entered and make it easier for the user to enter the data. This expands on my post, where I looked at creating… Continue reading How to set up data validation in Google Sheets
How to easily create a timeline in Google Sheets
In this post, we’re going to look at how to create a timeline in Google Sheets, which automatically creates a timeline from a set of data. Short on time? Here’s a quick video to show you how to do it: Action plan A common use of this is to visually see the actions in a… Continue reading How to easily create a timeline in Google Sheets
Learn useful Google URL tricks to make your online easier
In this post, we’re going to look at several useful Google URL tricks which allow us to quickly do a whole range of things, like quickly create documents, provide links to copy master templates, and from a link automatically download a PDF version of a document, and many more. We’re going to look at….. Useful… Continue reading Learn useful Google URL tricks to make your online easier