Tuesday, November 30, 2021

2 more Sheets Skills You Can Do

I'm back with two more skills you can master with Google Sheets! 

I am confident that you've been in a situation where you've been given a list of names. I'm going to guess you've felt the frustration of the list having the names in a single cell (probably lastname, firstname OR firstname lastname) but you really wanted them in separate cells. Or what about the reverse ... the list you've been given has the names in separate cells but you want them in the same (maybe separated by a comma?). Ugh. No need to retype the list! You can make your list be exactly what you want ... with very little effort!

I've made a video to demonstrate. It's right at 5 minutes. (Play it in 1.5 speed and will only take about 3 minutes). I've also tucked in a little *bonus* tip at the end ... did you know you can now specify the number of pixels tall you want your rows? Yep! I sneak that in, too! 

As much as I love Google Sheets, I am NOT a Sheets expert. I have a lot to learn. I hope you take these nuggets and add to your learning adventure, too. Sheets really is a very versatile tool. Is there something you wish you knew how to do? Comment below or reach out on social media. All my links are just below my photo near the top right. I'd love to hear from you!

Looking to do more with Google Sheets? Check out:

Sunday, November 14, 2021

2 Sheets Skills You Can Do

Sheets are one of those tools that I get a lot of questions about and most of the time, teachers don't feel confident in their use of Sheets. I haven't always used Google Sheets, but when I began heavily using Google Forms, I had to learn Sheets. And once I started learning Sheets, I found so many easy ways to make Sheets work for me. (And I actually enjoyed learning it!)

Today, I want to help you become more comfortable with Sheets. I am not an expert - I still have so much to learn. I don't do fancy formulas or complicated graphs. But I do use Google Sheets on a very regular basis ... and I love using them.

Learning a skill - or two - at a time, will pay off. 

Today, I'm sharing two of my favorite tips: freezing and sorting. Freezing is quite possibly the best skill to learn in Sheets. Freezing allows you to keep the rows and columns of your choice in view while moving through your data. Knowing how to sort your data is another crucial skill to master. Being able to organize and reorganize your data is incredibly powerful. Interested? Here's a short how to video demonstrating both! And I've tucked some Sheets resources below.

Would it help to have a copy of Sheet I used in the video? Here you go: "2 Sheets Skills You Can Do (public copy)." Click on the "Use Template" button in the upper right corner to make your own copy to play with and try out sorting and freezing. 

Level Up with Google Sheets (Summer 2021 webinar)

Stay tuned! Next week I'll return with a couple more skills to master in Google Sheets. But in the meantime ... what is your favorite way to use Google Sheets? Reach out and let me know in the comments below or reach out on social media!