10 BEST Google Sheets HACKS for Teachers

[@asky314]

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!

[@robinwilson133]

Once again, a great BIG thank you Michelle. Your videos inspire me to make my teacher life easier and more organized. I’ve always been a paper and pencil person, but this information has changed me. I’m leaning towards purchasing your sheets to save even more time. Happy Birthday and congratulations on your second power lifting win. Enjoy your delayed celebration 🎉

[@PocketfulofPrimary]

Aww, thank you SO much Robin! That's so sweet of you and I'm so happy you were able to learn some new things in this video! Also, thank you for the birthday wishes and the kind words about my powerlifting meet! I appreciate you! 🥰🖤

[@stefylovesCeline]

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 !😍😍😍😍

[@alexiamcbride7441]

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!

[@sloaneeisin1199]

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

[@firealarmdiscovery]

I want to be a special education teacher when i graduate. I always get bored and make things on technology (slides, worksheets ect.) and I use so much of what you teach us! Thanks Machelle

[@PocketfulofPrimary]

That's so great to hear! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@benhunter4093]

Two hacks that you missed that I have seen used as an IT student were creating self grading assessments and creating QR codes. Thankyou very much Michelle for your videos and Happy 29th Birthday. Hopefully Billy, Ember, your cats are spoiling you.

[@PocketfulofPrimary]

I actually already have videos on both of those! Thank you so much for the birthday wishes! I appreciate it!

[@laepelba]

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.

[@Anna-ut6wx]

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

[@PocketfulofPrimary]

That's wonderful to hear Anna! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@kimwoods7131]

As a special education teacher I am SCREAMING a big THANK YOU!! I’ve always been a pencil/paper kind of gal when it comes to data collection and sharing. With these tips, I am equipped to go digital!! Woohoooooooo 🎉

[@PocketfulofPrimary]

Aww, yay! I'm happy this was helpful for you Kim! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@jennygessner]

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!

[@kristinapaulson8398]

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!

[@Mandymei8]

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

[@PocketfulofPrimary]

Aww, that's so sweet Amanda! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@colleendriggers]

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!

[@jo-annguthur7314]

Actually productive advice! Thank you!

[@isabelmarisy5457]

Data Validation, Auto-fill Across Sheets, and Conditional Formatting. Thank you! This teacher needs this in her life. I'm not a Google Sheets lover but you have changing my mind.

[@PocketfulofPrimary]

I'm so happy you found this useful Isabel! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@lourdesmarquez1491]

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

[@PocketfulofPrimary]

I'm so happy you enjoyed it Lourdes! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@kimberlycelis623]

Such helpful information! I just wish I would have watched it sooner! Would have saved me so much time. :) Thank you so much!

[@sweettea6447]

Great video! Just curious, how did you format the cells with the check boxes to toggle the correct color format once you checked the box? Hope that makes sense. Love your videos!!

[@marykategajadhar8384]

I’m interested in this too

[@PocketfulofPrimary]

As I mentioned in the video, this is a little more complicated, ha. It took me a big to figure out but I'll consider sharing it in a future video! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@rilian226]

I figured it out after a lot of searching online. As the author stated, it's complicated. You basically have to construct a custom conditional formatting rule that uses the logical operator AND. The rule will change depending on what cell your checkbox is in and what cells you want highlighted but it would look something like this: =AND($K$2=TRUE,$F2="searchterm") ... Where cell K2 is the checkbox location and F2 in this case has a sample of the search term. The $ in front of the F2 means to highlight the entire row within the selected range of cells to conditionally format. You can replace searchterm inside the quotes with what text you're looking to highlight. Highlighting empty cells would be "". You can alter the selected text for a given conditional rule and/or alter the search term as desired. You can get fancier and add more conditions as needed with AND, NOT and OR functions.

[@NailDivaCreativeManicures]

Very good!! I am loving my journey with Sheets!

[@stacin6331]

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

[@PocketfulofPrimary]

Thank you so much for watching Staci and taking time to comment! I appreciate you! 🥰🖤

[@amandabohn6086]

You are so easy to learn from! A stellar teacher. If you feel like it is something manageable, I would love to see how to add those toggle check boxes. Thanks so much for your guidance :)

[@karenalder6024]

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.

[@rheaanglesey6913]

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

[@melanieives4240]

Happy Birthday Michelle!

[@PocketfulofPrimary]

Thank you so much Melanie! 🥰🖤

[@MitaPota]

amazing! So much to learn from you!!

[@amandawilkins8403]

Happiest of birthdays to you, Michelle! I have learned so much from your video, as I am more familiar with Excel than with Google Sheets. Also, best wishes for a fantastic powerlifting meet tomorrow. You rock!

[@PocketfulofPrimary]

Aww, thank you SO much Mandy! I'm so happy you enjoyed it and I really appreciate your birthday wishes and the good luck at my meet! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@mrs.angieduncan7366]

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

[@PocketfulofPrimary]

That's so great Angie! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@thetotinofamily]

This is very helpful. Thank you!

[@tiffhunny01]

Wow! So many great tips. Thank you. 🙂

[@PocketfulofPrimary]

I'm so happy you could learn some new things! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@alymandr]

Your videos are way too helpful 😁

[@PocketfulofPrimary]

That's great to hear! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@mizem169]

This is awesome! I teach Special Education and watching your videos is helping me be more organized with all the data tracking and other demands. Keep them coming😊😊

[@PocketfulofPrimary]

Aww, that's awesome to hear Cassandra! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@JuanDiaz-tz1kg]

Excellent video, personally I find pretty useful to make use of the =sparkline() function. After you've selected a range of data it will display a minimalistic graph wich is basically a line plot, but designed to fit into a cell, pretty useful when wanting to have a simple visual aid to start seeing patterns on the data you're working with.

[@jacquig3116]

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!!

[@PocketfulofPrimary]

That's great to hear Jacqui! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@rebeccagrantham6922]

Thank you Michelle!! Your hacks are invaluable!!

[@PocketfulofPrimary]

Thank you so much Rebecca! 🥰

[@Stephaniejedlicka]

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! :)

[@CCBeanzzz]

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.

[@berthalopez4227]

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?

[@SullyRides]

Great work! I left teaching years and years ago- before this technology was being used. 🙄. I love watching your videos even still!! Keep up the good work!

[@PocketfulofPrimary]

I'm so happy you enjoyed it Katie! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@helenainacio2291]

Brilliant, as always! Thanks for sharing!

[@PocketfulofPrimary]

I'm so happy you liked it Helena! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@CaylaCommonFolk]

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

[@PocketfulofPrimary]

Hi Cayla! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@anagalvez4775]

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!!! 🤩

[@biancastinney7320]

So helpful!! Thank you!

[@jacqorr]

Your videos are so great! I am pretty familiar with google sheets and conditional formatting but your check mark clicking it on and off was AMAZING! Can you point me in the right direction on how to do that? I had zero luck when I googled it.

[@christiwall3103]

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!

[@IrisEsmeroVlogs]

Thank you for this comprehensive hacks. 💯

[@elisaguzzardi1994]

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?

[@margaritaramosvelez400]

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

[@pattimcguire8877]

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

[@PocketfulofPrimary]

I'm so happy you liked it Patti! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@sukhigoomer9804]

Holy guacamole! This is amazing!

[@Bung_26]

Thanks! So useful!

[@PocketfulofPrimary]

I'm so happy you found it helpful Yvette! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@sherryarcher5495]

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

[@ez2follow380]

You are one smart cookie!😊

[@PocketfulofPrimary]

LOL! Thanks dad!

[@Saveapetcoupon]

Amazing video - I will save soooo much time now!!! 🎉🎉🎉

[@PocketfulofPrimary]

I'm so happy you found it helpful Tina! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@juliemark5764]

I followed the checklist tutorial and am so happy. I have checklists for my students for the entire second quarter.

[@PocketfulofPrimary]

That's so great to hear Julie! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@victoriaLL345]

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

[@primaryprocedures2289]

I learned something new Very helpful thanks!!

[@PocketfulofPrimary]

Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@kathrynmacgown6575]

Thank you! I needed this!

[@PocketfulofPrimary]

Thank you so much for watching Kathryn and taking time to comment! I appreciate you! 🥰🖤

[@SmartEnglishToday]

Thanks Michelle. Do you have a video where you explain how to make editable PDFs? I started watching you because you inspired me a lot being a teacher. Now you are encouraging me to be more technology 😊

[@PocketfulofPrimary]

Thank you so much Alice! I don't currently have a video about making editable PDFs but I'll definitely add it to my list for future video ideas! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@marcycooper2302]

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!

[@mandyjacotin8321]

Well explained! I subscribed.

[@Mafioso1731]

Like how did you learn all this 🤯! PHENOMENAL CONTENT I LOVE ALL THE STUFF YOU MAKE

[@PocketfulofPrimary]

I've always been pretty tech-savvy, ha! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@confidencegh]

Thank you!

[@MeganBlackler]

Great video! On your assignment tracking sheets you could also make the assignment title a link to the actual assignment so that it would be easy to reproduce for students completing catch-up work.

[@PocketfulofPrimary]

YES! I love that idea! Thank you so much for sharing... genius!

[@dcrisolago]

Wow! Another awesome helpful video! Is it possible to after filling in everything on the sheet can we print it and the notes we’ve made on students? Thanks for another great video

[@PocketfulofPrimary]

Hi Debbie! Yes! Any of the sheets can be printed :) I have a video coming next week on creating a student data binder which uses some of the sheets you see here so stay tuned!

[@111484mt]

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??😁😁😁

[@barbaralucke4262]

Hello Michelle! I've followed your channel for several years and have been a big fan of your posts. Your videos helped me through all the ups and downs of teaching-thank you! Your content is relevant and helpful, and you are engaging. I especially enjoy your technology hacks and step-by-step tutorials. I recently left teaching and am currently working on my MA in Education. We've been asked to pose a question on any social media platform, and I chose yours. I was hoping you wouldn't mind briefly responding, especially since you are an educator, author, KZbinr, and speaker. For my class, we are examining the differences between research and evaluation, and I would love any thoughts you'd care to share on this topic, especially since you are working on a new book! Thank you for your time and opinions, and congratulations!

[@PocketfulofPrimary]

Aww, thank you so much for all your kind words and support Barbara! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤 Please feel free to send me an email at [e-mail] with what you need for the recording and I'll get back to you as soon as I can!

[@Texaschic79915]

Newbie , thanks for sharing

[@Texaschic79915]

I’m using it for track of my sales etc

[@MzLinnie]

Did not know sheets could do some of these things. Thank you!

[@PocketfulofPrimary]

I'm so happy you could learn something new Lynn! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@shahrzadh1821]

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 ?

[@PocketfulofPrimary]

Hi there! You would need to change the text wrapping to "Wrap". This will allow the text to move onto multiple lines but it won't change the width of the column. Hopefully that makes sense!

[@mariaports5168]

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??

[@jagathkumaraperera3523]

Thank you, very clear

[@PocketfulofPrimary]

Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@Dove_Hotep]

omg just did 500 numbers by hand. lol. Excellent video.

[@jackalex]

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!

[@garrett2728]

Love the office character names

[@PocketfulofPrimary]

Thanks for noticing!

[@Losersimpl]

First one here haha 😍 anyways thx for the tips not a teacher but useful ❤️

[@PocketfulofPrimary]

LOL! Congrats and I'm so happy you found it useful even though you're not a teacher. Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@gerry8558]

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

[@frenchwithmadameg1116]

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

[@PocketfulofPrimary]

Ahhh, yes! I can add that to my list for future video ideas! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@robinbench3969]

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?

[@PocketfulofPrimary]

Hi Robin! Yes... absolutely! You can copy and paste scores from other places onto Google Sheets!

[@notthispage6452]

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! ❤

[@pollycure6265]

Is there a way to connect two Sheet books? I’d like to have my class assessment book automatically populate into another Sheet book that has only a single student’s assessments - that way I can share it directly with the student and their parents and not have to spend extra time filling in both books manually. 🤗😘

[@allisonjordan573]

There’s a way. I’m not sure of the exact formula but there’s a way that involves typing the actual link to the other sheet

[@PocketfulofPrimary]

Hi Polly! Yes... you can do that! Here's a link with directions on linking Google Sheets together: cloud.google.com/blog/products/g-suite/g-suite-pro-tips-how-sync-one-spreadsheet-another-google-sheets Hopefully that's helpful for you!

[@pollycure6265]

@@PocketfulofPrimary AWESOME!!!! 💜

[@butterflywings2001]

Please do the a video about the formulas; I need the toggle formulas in my life!

[@PocketfulofPrimary]

It's something I had to play around with for a while to get working... which means it is a little more advanced but I'll consider sharing it in a future video. Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@butterflywings2001]

@@PocketfulofPrimary Yes please do! I'm in the same boat of struggling to find the exact formula to get it to work, and I'm hoping yours will give me a better place to start. Thank you for everything!

[@veronicamoreno2785]

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.

[@lauracantahimnos]

Thanks 🙏🏼

[@PocketfulofPrimary]

Thank YOU for watching Laura!

[@larakimmel6917]

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

[@PocketfulofPrimary]

Hi Lara! Please reach out to me at [e-mail] which is also listed in the product info PDF included with the product!

[@reginahall3290]

Michelle! I just made my best ever google sheets check list! Thank you for the tutorial 🥰

[@PocketfulofPrimary]

That's so great to hear Regina! Thank you so much for watching and taking time to comment! I appreciate you! 🥰🖤

[@mrs.gonzalez-artteacher9370]

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

[@laurasuriel2332]

My favorite new hack was the note option! I literally still use the comments button.

[@CitizenTurtleIsland]

My greatest hack would be to have an admin person create all those wonderful spreadsheets for me. Just kidding. Hope you had a great birthday. You've already helped so many people and you are only 29!

[@PocketfulofPrimary]

Ha, I mean that's great if you have someone to make it for you! Thank you so much for the birthday wishes... I appreciate you! 🥰🖤

[@brookiestrickland8307]

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

[@PocketfulofPrimary]

Hi Brookie! My last video, How to Create a Student Checklist In Google Sheets, can be used as an attendance spreadsheet! kzbin.info/www/bejne/rJeXcqKerbqbjZI

[@lucias1276]

HOw can I create roaster?

[@laprofesw]

Happiest of birthdays!

[@PocketfulofPrimary]

Thank you so much! I appreciate it!

[@warriors1erwin]

As an avid Office fan I loved seeing what grade each person received. Poor Mose 🤣

[@PocketfulofPrimary]

Hahahaha, I'm happy someone noticed that! 🤣🤣

[@lucias1276]

Dont you teacher have a software at school where you keep all the data, grades, notes, forms etc?

[@lupitaochoa9529]

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

[@PocketfulofPrimary]

Yes! I'm the one that scheduled them, LOL! I shared with my email subscribers that I was switching my upload day from Sunday to Friday so you have longer to watch the video over the weekend!

[@ilylove1]

Is Friday your new upload day?

[@PocketfulofPrimary]

Yes! I shared the change with my email list last week 🥰

[@yuneimyluis9114]

Is like Excell

[@marshmm]

If you have a drop down of priorities (Urgent, High, Medium, Low) and want to sort sheet by this exact order, how can I do that? Like, I want all the urgents at the top, all the highs next, etc. Is there a way to have something like this besides sort sheet a-z / z-a? Thanks!

[@_AkshaySingh_]

Mia Is that you?

[@_chimera_]

This is beyond basic