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

For those of us who did not grow up with digital cameras/photos, at some point in time, you may have wanted to remove someone from a photo. Perhaps, an ex-boyfriend/girlfriend or former BFF. It may have looked something like this:

And, if you are wise enough to recall that, you will know that pictures of relationships were often patched back together with this tool …

Today, Google Slides cropping tool will help you hide a portion of an image without destroying the hidden area. You will be able to access the area of the image you cropped and restore the entire picture. Here is an example: read more

Read More