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
Category: Posts
How to move a folder to a Shared Drive
In this post, we’re going to look at moving folders from My Drive to a Shared Drive both for a Google Workspace account and a personal Gmail account How to move a folder to a Shared Drive with a Workspace account Here, I have a folder on My Drive in my Workspace account. I want… Continue reading How to move a folder to a Shared Drive
How to create video presentations in Slides
It’s now possible to create videos of a presentation in Slides which you can then easily share with a link with others. How to record a video presentation Open your Slides document and you will see in the top right-hand corner the recording (Rec) icon. Click on that to record a new video. Click “Record… Continue reading How to create video presentations in Slides
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
How to arrange a meeting from Gmail
In this post, we’re going to look at how we can arrange a meeting and create a calendar event right from Gmail. We will look at how we can offer invitees a selection of dates and times, for them to then select. Workspace then sets up the calendar events. How to offer dates & times… Continue reading How to arrange a meeting from Gmail
How to annotate Google Slides
In this post, we’re going to look at the pen tool in Google Slides, which allows us to annotate them while we are presenting them. Annotate Google Slides From Google Slides, open the slideshow. Hover over the bottom left corner and a little menu will appear. Click on the 3-dot menu and select “Turn on… Continue reading How to annotate Google Slides
How to scan with the Drive app on your phone
In this post, we’re going to look at how to use the scanner in the Google Drive app. It’s quick and easy to use and available to both Android and iOS. How to scan using the Drive app scanner Click on the Drive app on your phone. Tap the document icon to open the scanner.… Continue reading How to scan with the Drive app on your phone
All you need to know about Google Tasks
Google Tasks is a simple way to create to do lists and are connected to Google Calendar, making then quick and easy to use. How to open Google Tasks You can now quickly access Tasks from Google Calendar. At the top of the screen on the right, you can switch between the Calendar view and… Continue reading All you need to know about Google Tasks
Summary of Google Workspace 2023 improvements (Part 3)
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)
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)