In this final post on the 2023 improvements to Google Workspace in 2023, let’s look at the AI and coding side of things. Duet AI Google weren’t content with just bringing out Bard to compete in the AI ‘arms race’ last year, they also brought out Duet AI. This uses AI right across Google Cloud.… Continue reading Summary of Google Workspace 2023 improvements (Part 3)
Author: bazroberts
Summary of Google Workspace 2023 improvements (Part 2)
Following on from part 1, let’s take a look at my favourite improvements to Slides, Chat, Meet, Calendar, Classroom, and Gmail. Slides Presentable video recordings This allows for videos to be recorded of Slides content and then shared. This saves having to use 3rd party apps. The rollout for this has been delayed and should be… Continue reading Summary of Google Workspace 2023 improvements (Part 2)
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
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