Category: Google Sheets (page 2 of 4)

A (Dot) New Way to Google

There are several ways to create a new Google file. You can do it using the plus sign in Google Drive… or start a new document from a current one using the File menu… or go to docs.google.com/create.

Now there is a super easy way to start a new Google file… and it’s (dot) new!

Want to make a new Google Doc? Open a new tab and enter doc.newdocs.new or document.new in the address bar.


How about a Google Sheet? Try sheet.new, sheets.new, or spreadsheet.new.

Need a quick Google Form? That’s form.new and forms.new. read more

Split Text to Columns Easily

Sometimes the simplest features can be the lifesavers! Today’s tip is no different.

Have you ever had a list of names or other data that need split? In my example, I have a roster of students’ full names. This is not ideal, because I’d like to have them split by first and last so I can sort and perform other operations.

Previously, you would have to use something like the Power Tools add-on. I LOVED this add-on, but alas, it’s no longer free. But don’t fret… because this feature is now built-in to Google Sheets! read more

Summer PD Roundup

Summer is almost here! It’s a great time to relax, recharge and yes, even level up your technology proficiency. While Tech Tips Tuesday is going on our annual break, we wanted to leave you with some summer professional development opportunities.

Remember, all Northern Buckeye/NWOCA trainings are included with membership at no additional cost. You also have access to our archive of webinars, class materials, and other PD resources. Our training website at training.nwoca.org has all of these and more. If you’re unsure if your district is a member, check out the list on our website. read more

It’s Here! Checkboxes for Google Sheets!

Google recently launched this new feature in April 2018 which makes it very easy to insert checkboxes in Google Sheets, and allow us to use Google sheets as tasks lists. Use checkboxes for many purposes like to take attendance, track a project, and check off your to-do list.

Let’s take a look:

Open a spreadsheet in Google Sheets.  If you are using a spreadsheet from a Google Form you will need to insert a column for your checkboxes.  Click Insert > Column left

Highlight the range of cells or the column for where you want the checkboxes. In the top menu, click Insert > Checkbox read more

Google Photos in Slides

Some of you may have noticed that the image options for inserting images in G-Suite has undergone a refresh. When you go to add a picture from the insert menu it now has a sub-menu.

New insert menu

The Photos option is what we are sharing in this tip.

Selecting photos will open a sidebar on the right side of your document which then loads pictures from your google photos. Select a photo and then click the add button to add it to your document.

Photos screen

What I find this really useful for is to put pictures that I have taken with my phone into a presentation or document or even a google drawing. read more

Older posts Newer posts

© 2019 Tech Tuesday Tips

Theme by Anders NorenUp ↑