In this post we’re going to look at the quiz option in Forms. Since its release earlier this year, I’ve been using it with various classes mainly to check their progress, and it really is a simple but highly effective tool, which I recommend everyone to use. To start let’s just look at the 4… Continue reading Google Forms – Quizzes
Author: bazroberts
Google Sheets Functions – UNIQUE, COUNTUNIQUE, SORT
In this post we’ll look at how we can remove duplicates from a set of data, with one simple formula using the UNIQUE function. We’ll also use the SORT function to put the unique list in order and use this in a drop down menu using DATA VALIDATION. Finally, we’ll look at counting those entries… Continue reading Google Sheets Functions – UNIQUE, COUNTUNIQUE, SORT
Google Sheets Functions – PROPER, UPPER, LOWER, TRIM
In this post, we’re going to look at how we change the format of text to suit our needs, using the functions PROPER, UPPER, LOWER, and TRIM. It’s particularly useful when working with text that has come from, for example, a form, a different computer system, or indeed someone has typed in on your Sheet.… Continue reading Google Sheets Functions – PROPER, UPPER, LOWER, TRIM
Google Sheets Functions – COUNTIF(S) & SUMIF(S)
In this post, we’re going to look at how we can count things and add things up depending on certain conditions that we set. There are four functions we’ll look at here: COUNTIF, SUMIF, COUNTIFS, and SUMIFS. Here I’ll show you the various aspects of the functions through some practical examples. Example 1 – COUNTIF:… Continue reading Google Sheets Functions – COUNTIF(S) & SUMIF(S)
How to add alternating row colours to Google Sheets
When working with tables in a spreadsheet, we often want them to be easy to read and understand. To help us, Sheets has a quick little tool, which allows us to add alternating colours to the rows of our data, making them not just prettier but much easier to read, whilst being really quick to… Continue reading How to add alternating row colours to Google Sheets
Google Sheets Functions – VLOOKUP
Here’s how to look up values in tables in Google Sheets using the really useful VLOOKUP function (Vertical Look up). You give it something to look for in the table and it gets the value you’re after from a different column in that row. As always the best way to show what it does is through… Continue reading Google Sheets Functions – VLOOKUP
Google Slides – Master slides and themes
The built-in themes provide a great springboard to make professional looking slides but what happens if you want them to look different? Or what happens if you want to make your own style of slides and you only want to set it all up once? Well, with editing the Master you can create your own… Continue reading Google Slides – Master slides and themes
Google Slides – Word art & Gradient fill
If you want to make some dramatic looking text, Word art can be a better option than using a normal text box. So, what’s the difference between the two? With Word art, the text is treated like an image allowing to change the size without being limited to font sizes. It also allows you to… Continue reading Google Slides – Word art & Gradient fill
Google Slides (25) – Importing slides
[et_pb_section bb_built=”1″ admin_label=”section”][et_pb_row admin_label=”row” background_position=”top_left” background_repeat=”repeat” background_size=”initial”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” border_style=”solid” background_position=”top_left” background_repeat=”repeat” background_size=”initial” _builder_version=”3.0.51″ custom_margin=”-100px|||”] There are times when you want to import a few slides from a presentation that you or someone else has previously made. You could make a copy of the presentation and delete the slides you didn’t want but a… Continue reading Google Slides (25) – Importing slides
Google Slides (24) – Adding video
[et_pb_section bb_built=”1″ admin_label=”section”][et_pb_row admin_label=”row” background_position=”top_left” background_repeat=”repeat” background_size=”initial”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” border_style=”solid” background_position=”top_left” background_repeat=”repeat” background_size=”initial” _builder_version=”3.0.51″ custom_margin=”-100px|||”] Updated – Now includes adding videos from your Drive. Video can brighten up any presentation and it’s easy to add YouTube videos and videos stored on Google Drive into your slides. Here’s how: Inserting a YouTube video Go… Continue reading Google Slides (24) – Adding video