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
Posts
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
Google Slides – Line spacing & Text indenting
Here we’ll look at a couple of simple little tools which can help make your text in your Slides that much better. They are line spacing and indent. Changing the line spacing In this example, I’ve got a slide with some point on it, which as there are only 4 points, I want to spread… Continue reading Google Slides – Line spacing & Text indenting
Google Slides (19) – Version History
[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”3.0.47″][et_pb_row admin_label=”row” _builder_version=”3.0.47″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.0.47″ parallax=”off” parallax_method=”on”][et_pb_text admin_label=”Text” _builder_version=”3.0.51″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_margin=”-100px|||”] Updated – Includes the new version of Version history and naming revisions One of the best features of the Google Apps is the revision history, which stores every change to your document, allowing you to go… Continue reading Google Slides (19) – Version History