Google Slides Presenting Tips

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

Customize Your Charts in Google Sheets

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

Must Count All The Things

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

Formatting Comments in Google Docs

Have you ever wanted to format your comments in Google Docs to get your point across and make it clearer?  

If so, I have great news!  You can bold, italicize and strikethrough text in a Google Doc comment with a couple easy keystrokes.

For bold text:

Add an asterisk on both sides of the word or sentence you wish to bold  

*BOLD*

After clicking comment, the text will appear like this:
For italicized text:

Add an underscore on both sides of the text or sentence you wish to italicize

 _italicize_

After clicking comment, the text will appear like this:
For Strikethrough text:

Add a hyphen on both sides of the text or sentence you wish to strikethrough  

-strikethrough-

After clicking comment, the text will appear like this:
For All Three

Place an asterisk, hyphen and underscore on both sides of the text or sentence, making sure each side mirrors the other.

After clicking comment, the text will appear like this:

In addition, these tricks also work in Sheets and Slides (and anywhere else that you can use Google’s commenting system).

Read More

Create QR Codes Right in Google Sheets

You know what QR codes are, right? They are those funky square images that you can scan and be instantly transported to a website. But QR codes are so much more than that.

You can create QR codes that provide directions, prompt the user to make a phone call, share contact information and more. QR codes are very useful, especially to educators. But how can we easily create them? Sites such as QRStuff.com are helpful, and the Goo.gl URL shortener had them built in (but Goo.gl is going away in a few weeks). read more

Read More