10 BEST Google Sheets HACKS for Teachers

Thanks! Love your "student" names in the Google sheet! LOL!

This was really great. Thanks for sharing.

Your tips are excellent, Michelle. Thank you! I have always stayed away from sheets because to me, it is overwhelming and thus I have always inserted tables into docs to get my "grids" and "arrays" for student documentation instead of using sheets. After watching your video today I feel like I might be more willing to try Google sheets out again. Thank you!

THANK YOU! I learned so much! My grade level has started using Google Forms for all of our assessments, is there a way to take data from multiple classes from the Google Form assessments and input the data using your Student Data Sheets template?

Michelle, I bought the google data sheets file you sell on TPT and I am having problems. How do I contact you? Thank you

I wanted to use the google sheets to give a certificate withe their name and 1 more data point using google slides. I can't seem to find the extension for doing that! Can you help me please! ❤

Ok, Hack 7 I was so expecting you to show us how to do the toggle on and off and I can't tell you how helpful that would be to know! Where did you learn it or can you please make a video on that? Seriously, where did you learn all this stuff??

Thank you so much for sharing these hacks! I love tech tips and you are so easy to learn from. Would love to learn how to create the functional checkbox that toggles on/off highlighting empty cells, if you're able to share! Streamlining my sheets now for the upcoming school year! Keep up the helpful work!

Thanks heaps! Always looking for teacher time savers and hacks. Big help. Have subscribed. 🎉

Can you please make a video about how to add the toggle that you mentioned in this video?

Used several of your videos to help me review and study for the Google Level 1 Certification! Thanks for making learning enjoyable with all the topics you cover!

Hello! I love your videos! I want to learn Google Sheets so that I can use digital assessments, checklists, progress reports, ...etc...all of it! Do you have any more Google sheets videos or can you recommend tutorials made for teachers? I googled some and I couldnt understand any! I love your videos! Please help!

Oh my gosh, Michelle! I just started following your channel and I'm not even a teacher! lol Well...in theory I am because I'll begin homeschooling my son again this year, but these hacks changed my liiiiiife! I actually hate excel so I use google sheets all the time now, and I can't thank you enough for sharing these! :)

Is like Excell

Hello, great video, I wonder if you have a hack about comments, i have a problem in my company and only some users when they write a comment and use the @ symbol they can see a list of users to whom they can assign the comments, other people just don't have this list displayed. Do you have an idea of what might be the problem? Thanks in advance in you have some insight about this problem.

Thank you Michelle!! Your hacks are invaluable!!

Thank you for the great information. I have learned a lot of new things by watching your videos. Do you have a tutorial on mail merge?

I live for you! Your videos are so helpful!!! I love all of your organizational tips and tricks especially within the Google apps

Holy guacamole! This is amazing!

Thank you!

Newbie , thanks for sharing

Thank you soooo. much dear Michelle! I already bought the templates!!! They are amaziiiing! I can't wait to hear you and Bridget next Thursday !😍😍😍😍

Oh wow! Hate Google Sheets and Excel. Definitely will revisit this as our District is a Google District. Thanks for this!

Thank you so much!!! I've found all these hacks SUPER USEFUL!! I was just wondering if you know how to use Google Sheets, or any other free app, to keep track of the books students borrow from my classroom library in order to be able to have a bird's-eye view of the children who haven't returned their books yet. Thanks again!!! 🤩

Very helpful. Could you teach us how to do flash cards with a number on the top right corner and the sight words on the middle??😁😁😁

Hi Michelle! I was wondering how you would do something like importing only certain information onto a new sheet, ex. Empty cells or cells under a certain number will input into a sheet that is for missing assessments or a recommended retake sheet? How would you transfer only certain values? Thanks!

I LOVE these hacks!! I watched your video on Student Checklists and now I have my entire teaching team using checklists to record daily attendance for each class we teach! You are amazing!

I have a question about the student data sheet you created. Using your hacks I've been able to create a data sheet specific for my school and the data we collect. Is there a way to automatically create a sheet for each student? Or do I have to create 79 individual sheets in one document to have one on each student? I LOVE the drop down boxes but was wondering if there was an easy way to keep a digital sheet on each student. I hope this makes sense.

Thanks for your videos!

As always another great tutorial! Thank you so much for sharing. We use a lot of data in our child study and plc meetings. Super helpful.

I’m a bookkeeper with a mom who is a teacher. She loves your channel! I do a lot of Data Entry at work & love learning more about spreadsheets! Thank you for a great video!

I have to ask. Were your cat’s ears in the video, or am I seeing things? Also, these hacks are AWESOME! Thank you! ❤

Your Kids must love you! Im doing my ancestry for my 2 boys and their families on google sheets Im very new i was doing great with your teaching up until # 5 and on thank you for the hacks If you have a slow way to make the data part easier I would really appreiate your time

Oh my goodness! I've been down the rabbit hole today as I worked to create and replicate all the cool sheets you showed us, Michelle. Thank you for sharing!

Actually productive advice! Thank you!

Gosh you are so smart and able to apply that knowledge so expertly. I am not a teacher and I am a dunce when it comes to excel but this was so interesting to watch.

Wow Michelle you really covered your bases with this. Thank you for putting out great resources for teachers and students everywhere

Could you do a video on how to make an attendance spreadsheet?

Thank you so much for your tutorial. I have a question about the Excel cells on your Sheet. As you write, the cell gets bigger automatically. Would you tell me how ?

I learned something new

Very helpful thanks!!

Amazing!! I’m obsessed with your videos! They make my life so much easier! I look forward to hopefully learning about your checkbox formatting!

Thanks 🙏🏼

Big THANKS Michelle - one of your most helpful videos for me!!

These videos are actually helping me in my project manager course! Now I can use all these tips for a neat layout!🙂

I always learn so much from your videos. Always, so well thought out and a straightforward presentation. For someone who teaches online this is a HUGE help!!

I always learn something when watching g your presentations and I have been teaching awhile!

This is a fantastic video!!! Very, very useful!

Can you manipulate a Google sheet from a Google format in this way or make the form prior and pull over the scores from the form into that sheet?

Thanks for that video! Can you make a Google Sheets tutorial using conditional formatting to create mystery picture activities?

Did you know that your past 2 videos have posted in the middle of the week? Just asking, not complaining. 😃

Thanks for this fantastic list of Google Sheets hacks! I get more and more into GS every day. :) I teach high school math, and am often tracking over a hundred students over two different courses and five class period. I use data sorts based on columns a lot. One of the things that I use almost weekly is Google Forms to collect information from kids, make exit tickets, send forms home for parent input, etc. During the pandemic I was using Google forms for attendance and student feedback. Do you ever use Google Forms? I LOVE the connections between Forms and Sheets.

Wow!!! As always, another GREAT and USEFUL video.😍