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.

Before I get started, I do want to remind you that Google Sheets has TONS of help built in. Under the Help menu, click Function list and you will be taken to a searchable list of functions that are built-in to Sheets. For each function, there is the syntax and a link to learn even more.  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 Present, 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

Google Sheets is a great tool to use to help keep track of data, analyze numbers, make calculations, etc. One of the many features of Sheets is the fact that you can create charts to visualize your data. There are various charts you can use and you can also customize them to make certain parts stand out.  

One of my favorite charts to use (depending on what kind of data you are analyzing) is the pie chart. First, you highlight all your data and then click on the chart icon. Once your chart is created, you can begin to customize it using the customize tab in your chart editor.  read more

Read More

Whenever I think of counting, I think of The Count from Sesame Street. He loves to count. And, he counts everything. When storing data in a Sheet, you may want to count how many students answered “True” to a question or how many parents indicated they are available to chaperone a field trip. Rather than counting each row manually, use the CountIf function:

For example:

=CountIf(J2:J100,”True”)

Click here to view a brief video on this cool Sheets feature!

Read More