How to Delete Blank Rows in Google Sheets | Tips & Tricks Episode 124

Remove Empty or Blank rows from your Google Sheets in no time! Here are some of your options to clean up the data! This video is sponsored by Acer for Education and Produced by Sethi from the ‘Flipped Classroom Tutorials’ Channel for AppsEvents. ➤➤➤➤Get your own Online training with AppsEvents here: AppsEvents.com/online Share this video […]
Google Sheets – Protecting sheets and ranges | Tips & Tricks Episode 123

Using the ‘protecting sheets and ranges’ feature in Google Sheets, will mean that no data can be accidentally overwritten. This video is sponsored by Acer for Education. ➤➤➤➤Get your own Online training with AppsEvents here: AppsEvents.com/online Share this video with a friend: https://youtu.be/TOpuwPGiIhw or learn more about Google Educator Certified: https://youtu.be/Ka7aIBAkdDI ➤➤Acer for Education: https://eu-acerforeducation.acer.com/ […]
How to create pivot tables in Google Sheets | Tips & Tricks Episode 120

How do I reorganize my data and change the way the table is showing the Data? Pivot tables are the answer! Find out how to create a basic Pivot table in this video! This video is sponsored by Acer for Education and Produced by Sethi from the ‘Flipped Classroom Tutorials’ Channel for AppsEvents. ➤➤➤➤Get your […]
How to Sort Google Sheets Rows Alphabetically | Tips & Tricks Episode 117

How do I sort my Sheet data and what is the difference between sorting a Sheet and sorting a Range? In this Beginners video, you learn how to sort your data, freeze the first row and keep important data connected so it doesn’t jumble up your work. This video is sponsored by Acer for Education […]
Feed Multiple Forms into a Single Sheet | Tips & Tricks Episode 108

Feed multiple forms into a Single Sheets file! Great to keep track of all the information you collect on students and parents. Collate the results and stay organized. This video is sponsored by Acer for Education and Produced by Sethi from the ‘Flipped Classroom Tutorials’ Channel for AppsEvents. ➤➤➤➤Get your own Online training with AppsEvents […]
How to use a Theme in Google Sheets | Tips & Tricks Episode 107

Use your brand or school colours and set them as a Sheets theme. Themes are a quick and easy to use way to customize all your fonts and charts at once! This video is sponsored by Acer for Education and Produced by Sethi from the ‘Flipped Classroom Tutorials’ Channel for AppsEvents. ➤➤➤➤Get your own Online […]
Using Data Validation in Google Sheets | Tips & Tricks Episode 106

Use Data validation in your Google Sheets to limit the options people can select or create a drop down box that changes as the values change. This video is sponsored by Acer for Education and Produced by Sethi from the ‘Flipped Classroom Tutorials’ Channel for AppsEvents. ➤➤➤➤Get your own Online training with AppsEvents here: AppsEvents.com/online […]
Use Slicers to filter Data in Google sheets | Tips & Tricks Episode 105

Filter your Data with a Google Sheets Slicer. This is a quick and easy way to clean up the way you present or show data. The slicer will act as a floating button that you can use to select and show data in tables, charts and more! This video is sponsored by Acer for Education […]
Protect Sheets and Ranges in Google Sheets Tips & Tricks | Episode 104

How Do I protect a Range or sheets from being edited or changed? In Google Sheets this can be done in just a few steps! You can have a Rage protected whilst still giving editing rights to the rest of your spreadsheet. This video is sponsored by Acer for Education and Produced by Sethi from […]
Tracking Data using Sheets | Tips & Tricks Episode 97

In this episode, we share two different tips that can help you look at data in different ways. Color scales can help you compare within a data set while sparklines can help you quickly look at changes. This video will help you learn more about how to use both. This video is sponsored by Acer […]