Way back in 2018, Kim introduced you to a new Google Sheets feature called checkboxes. And then in 2019, Julianne explained how to use the COUNTIF function to… well… count things. In today’s Tech Tip, I’m going to show you how to combine these two features for a super-handy function that will help with tracking data.

In case you missed Kim and Juli’s tips, they should be linked above.

Here’s a quick review on how to add checkboxes to your Google Sheet: read more

Read More

Seeing is believing, right?! A chart can turn data into a powerful visual to help analyze and track trends. Google Sheets offers a wide range of chart types: column charts, pie charts, line charts, bar charts, scatter plots, and others.

One of the “others” I like to use to reference data in a Sheet quickly is a table chart.  Sometimes I will even use both, a more traditional chart like a bar chart and a table chart.

A table chart places the selected columns/rows into a graph where the data can be easily accessible. read more

Read More

This tip comes indirectly from the good folks at Seesaw who use the technique I am about to describe to keep their Seesaw Ambassadors up to date with the latest changes to the Seesaw Ambassador program which is tracked in a Google Sheets document.

A little known feature to most people is that you can enable notifications via email for any Google Sheets document. To enable the feature you use the Tools >> Notifications Rules

On the set notifications rules screen you need to choose to see when either a change is made to the form (by Editors of the sheet) or when a form is submitted (Linked Google Form). read more

Read More

If you’re like me, you get some really messy data in Google Sheets. I have found some very easy ways to clean up this data and make your sheets look really nice. In this Tech Tip, I will focus on three topics – split columns, CONCAT and CONCATENATE, and removing text using the find and replace feature. read more

Read More

I use Google Slides all the time for my professional development presentations. With the COVID-19 pandemic forcing most of our training opportunities online I have had to hone my presentation skills to meet the demands of virtual presentations.

The first and most widely used method of presenting a Slides presentation is by using the Present button in the top right corner in Google Slides.

Present button options

If you click =&0=&

the presentation goes full screen and starts your presentation on the slide currently selected in the sidebar. You exit full screen with the ESC key. Now, presenting full screen is great if you are presenting to an audience as it will fill the screen and make it easier for everyone to see.  read more

Read More