Category: Google Sheets (page 1 of 2)

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

Copy Comments and Suggestions in Google Docs, Sheets and Slides

I love collaborating with my team (and educators all over NW Ohio!) with Google Docs, Sheets, and Slides. One of my biggest frustrations is that the comments and suggestions don’t transfer when you make a copy. This means you lose your history of all your collaboration when you duplicate a document, spreadsheet, or presentation.. Now Google is making it possible to copy comments and suggestions any time you make a copy of a Docs, Sheets, or Slides file.

To copy your comments and suggestions, simply select “Make a copy” from the File menu as your normally do. Now you’ll see an option for “Copy comments and suggestions” or “Copy comments.” read more

Older posts

© 2018 Tech Tuesday Tips

Theme by Anders NorenUp ↑