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)
Google Workspace Tutorials
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
Step-by-Step Guide to Mastering the new XLOOKUP Function
If you’ve used functions for a little while, no doubt you will have seen or used VLOOKUP. It’s a really popular function and one of the first that most people start using but it does come with some limitations. Fortunately, we have a new function on the blocks which doesn’t have these limitations and does… Continue reading Step-by-Step Guide to Mastering the new XLOOKUP Function
How to use CHOOSECOLS and CHOOSEROWS
Google have recently added two useful new functions to Google Sheets, CHOOSECOLS and CHOOSEROWS, which allow us to easily show certain rows or columns we want from a data range. Let’s see how they work with a couple of examples. choosecols Here, we have some questionnaire feedback on a group of teachers and the academy… Continue reading How to use CHOOSECOLS and CHOOSEROWS
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 combine arrays of data into 1 sheet
In this post, we’re going to look at how we can easily combine arrays of data on separate sheets in a Google Sheet and add them on one single sheet. We’re going to use the relatively new spread operator (…) to do this. Situation In this example, we have a set of data on 3… Continue reading How to combine arrays of data into 1 sheet
How to easily add drop-down menus in Google Sheets
Drop-down menus in Google Sheets allow the user to select specific options in a cell which controls what they input into the cells. It also makes it easier and quicker to input the data. When you click on the cell, you will be presented with lovely looking options to click on. Previously, to add a… Continue reading How to easily add drop-down menus 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 how to make a World Cup game using Apps Script
It’s almost World Cup time and I thought what better way to get into it than to create a little World Cup game amongst friends and colleagues using Google Sheets, Sites, and Apps Script. This year I decided to create a game where the participants guess how many goals will be scored in each stage… Continue reading Learn how to make a World Cup game using Apps Script
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