In this post, we’re going to look at how we can identify duplicate rows and also extract both unique rows and duplicate ones using a single formula. We’re going to look at different ways to do this and how we can use one formula which will extract a list of duplicate rows and and also… Continue reading How to filter duplicate rows in Google Sheets
Google Workspace Tutorials
Google Forms – How to add titles and sections
In this post, we’re going to look at how to add titles and sections. Plus, how you can move sections and preview your form. If you’ve got a longer form, you’ll probably want to add sections and possible pages to your form. There is an important difference between titles and sections. Titles – These add… Continue reading Google Forms – How to add titles and sections
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 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
The new Home in Google Drive
In this post, we’re going to look at the new Home page in Google Drive. This was introduced as a way to find files and folders quickly. New Home page The Home page is found above My Drive. It shows you files that Drive thinks you’ll want to use. This is based on various criteria… Continue reading The new Home in Google Drive
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