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 […]

Conditional Formatting with Sheets | Tips & Tricks Episode 94

Looking at some of the basics of conditional formatting and how it can be used in the classroom. This includes a number of examples both from a teacher organization and data tracking perspective, and ideas of how conditional formatting can be used with students as well to allow for both learning and creative expression. This […]

Publishing to the Web – Sheets and Slides | Tips & Tricks Episode 90

How the publish to the web feature, which can be found in Docs, Sheets, and Slides, can be used to help in keeping everything up-to-date. This video picks up where the Docs video left off, and focuses on how Publish to the Web looks different in Sheets and Slides. This video is sponsored by Acer […]