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 Workspace Tutorials
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
Google Slides (23) – Leaving & replying to Comments
[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|||”] One of the great things that Slides allows you to do is collaborate together on a set of Slides. Quite often you want to leave comments to your collaborators to make comments on what they’ve done or ask… Continue reading Google Slides (23) – Leaving & replying to Comments
Google Slides (22) – Audience Q&A
[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|||”] One of the most recent updates to Slides has been the addition of “audience Q&A”, which allows those watching some kind a presentation ask questions to the speaker. It’s really easy to use and can make presentations and… Continue reading Google Slides (22) – Audience Q&A