Posts Tagged ‘Google’
Conditional Date Formatting in Sheets
I’ve had this question come up a lot over time. How do I make a cell change to red or green based on the date? Fortunately, conditional date formatting is pretty easy with Google Sheets. The example below shows a list of days, and tasks for each day. Right now they’re all grey. We want to…
Read MoreGoogle Sheets Custom Date Format
Dates can be displayed in many formats in your spreadsheet. This article will show you how to set up a custom date format to your liking. Adding Dates to a Spreadsheet When you first enter a date into your spreadsheet, Google Sheets will usually recognize it as a date and format it accordingly. Unless you’ve…
Read MoreInsert Images Into Google Sheets
There is more than one way to insert images into a spreadsheet.  This article shows you how to insert images, and how to use the IMAGE function to embed your image directly into a cell. One Method For Inserting Images The first method is to use the “Insert” menu, and select “Image”. This will open a…
Read MoreCreating a Dropdown List In Google Sheets
Why Create a Dropdown List? You can use dropdown menus to make sure people are only able to enter certain values into a cell, or you can use them to make your life easier when you’re using a cell to regularly check data in your spreadsheet. Creating a dropdown list in Google Sheets is very easy. …
Read MoreUsing the Goo.gl Link Shortening Tool
Did you know that Google has a link shortening tool available for free? It comes with some great analytical tools as well, making it a super useful asset. What is Goo.gl? A lot of you are probably familiar with bit.ly or TinyURL, but may not have heard of the service that Google offers. It’s called…
Read MoreUsing Audio Files In Google Forms
Have you ever wondered if it’s possible to use audio files in Google Forms? In this article we’re going to see how that can be done. Getting an Audio File Into Your Form The first step is to upload an audio file into Google Drive. Make sure that link sharing is on and copy the…
Read MoreUsing the Google Slides Laser Pointer
Is it difficult to keep your audiences attention on specific parts of your presentation? In this article we’ll take a quick look at the laser pointer feature in Google Slides. What is the Laser Pointer Tool? This is a handy tool for presentations with a lot of details in the slides. You can use your mouse…
Read MoreImport Themes Into Google Slides
Have you ever wondered how to keep a consistent style for all of your slides, or use the style of another presentation that you’ve seen? In this article we’ll see how we import theme styles from one theme to another. How to Import a Theme Into Google Slides In the top menu bar of the Google…
Read MoreInstant Data Insights With Google Sheets Explore
Have you ever looked at a spreadsheet and wondered what to do with the data? This is where the Google Sheets Explore tool comes in handy! What Does the Sheets Explore Tool Do? When you’ve got some data in your sheet and you’re trying to figure out what to do with it, try clicking on…
Read MoreDigital Sign-In Sheets With Google Forms
Did you know that there’s a better way to do sign-in sheets for your events? You can use digital sign-in sheets created with Google Forms for your guests. This will allow you to track attendance at events and collect guest information. How to Create a Digital Sign-In Sheet Start by creating a Google Form for…
Read More