After 35 years in a Middle School classroom I know that teaching is a gift. Many brilliant people just cannot get information across to others in a form that is easily understandable. You have presented this in an excellent manner and left no doubt as to how to do the functions available in the program. Wonderful job. Looking forward to your other videos. Now I have to go type up my notes.
I've been reluctant to try google sheets because I really didn't know where to start. Your videos are exactly what I've been looking for as I prepare for the next school year. Thank you for sharing all of these useful tips!
Thank you so much for an excellent presentation. It helped me a lot for an assignment I needed to complete and as I'm not too familiar with Google Sheets - its was very much appreciated. You also have a wonderful way of presenting
very helpful and clear to understand. just learned about conditional formatting - if students enter correct answer in cell - the cell can turn green to let them know answer is correct. My question is how can I protect this formatting so that kids can't tinker with it? Can you show us how to do that?? I'll look for that video.
Thank you for the video. Do you have a video that explains how to set up a Google spreadsheet for 8.5" x 11". I have one and it scrolls very long. When I try to print, (hitting fit to page) it ends up cutting rows off in the middle. Hope that makes sense. Thank you!!
Been trying to print a file ,,, I have 1final colmn that prints, by itself, on a SEPARATE pg. Are there Margin settings I can adjust, [There is space available on my Landscape sheet.].
This is awesome, so many helpful tips and easy to follow along!! What font did you use for "October" in your monthly calendar, I love it! Do you design fonts as well? Thanks again!
Instead of resizing the columns multiple times, I'd just select them all and double click the spot used to resize them. This will make each column be resized to its optimal size :)
I sense you are well knowlegible to advise on this predictiment. My 'sheet contains 8 colmns., however, I only want to display 5, on a Chart. Is there some Formatting/Shortcut option, I could use to achieve this? Thanks!
Could you help me? I would like to input a time in minutes and seconds, and have it display in just seconds for printing. For example if I type in 0:10:06 or 10.6 (as in 10min 6seconds) I want 606 to be displayed in that cell. If yes, could you also do this with hours?
Hello Teacher Lady! I am using Google Sheets for my small Business. When I make an invoice and download it into a PDF form the font is so small.. how do I fix this. BTW I put the font as high as 18 so it can be a little visible. THANKS!!!!!!!!
I learned how to make a crossword puzzle in sheets for my students' distance learning. I am having trouble editing the notes attached to the across/down clues. I changed the numbers in each note but when I click on the print option to view it, the old numbers are still showing. Do you know how I can change these? Thanks for your help.
Hello There!!! Q: Microsoft Excel Made It So User Friendly To Locate, View And Delte Duplicates With Highlights. I Know Google Sheets Has A "Unique" Way Of Doing Such But It's NOT User Friendly At All. Is There An Easier Way To See, Manage and Have Duplicates Highted To Work WIth Using Sheets? My Job Does Not Use Microsoft Any Longer, We've Transitioned Strictly To The Use Of Google EVERYTHING, Can You Please Help?
what if one student had 3 lunch choices or say this column was subjects and each child had 5 or more different subjects under a 'class' column. How do you sort and filter each subject
On your Growth Data Chart, it looks like you have an image inserted into your cells for your title. If so, what size image did you build so it didn't get wonky? Also, what font is that?! I NEEEEED it in my life.
If you insert the image into the actual cell, it automatically resizes the image based on the width/height of the cell. I believe the font is from A Perfect Blend -- one of the ones with coffee in the name (can't remember exactly).
When you sorted by last name, all the data went with it! Mine sorts the name column but leaves the data of the previous student list so it's all mismatched. How do I fix this?
Great tutoials on Google Sheets, thanks for posting them. But your playlist of them has #1 & #2 REVERSED! (I thought I was the only one who makes silly mistakes like this and doesn't notice.)
Cool tips, but we're just supposed to believe that all those opposing factions from Game of Thrones would allow themselves to be organized in a single spreadsheet? I'm not buying it. Daenerys Targaryen doesn't do 'permission slips'.
After 35 years in a Middle School classroom I know that teaching is a gift. Many brilliant people just cannot get information across to others in a form that is easily understandable. You have presented this in an excellent manner and left no doubt as to how to do the functions available in the program. Wonderful job. Looking forward to your other videos. Now I have to go type up my notes.
Wow, thank you so much!
Awesome video! Thanks for posting. This is the first one that I found that clearly explains how to merge cels.
Glad it was helpful!
This is the first video I watched that felt like it made good and complete sense. Leave it to a teacher! :) Thank you!
So happy to hear that, thank you!
me too!
This is so amazing, I'm only quarter way through and my Excel sheet is already looking so amazing, so easy to follow, thank you for sharing!
very informative and I GOT your sense of humor cheers to you
Haha, love it. Thanks!
I've been reluctant to try google sheets because I really didn't know where to start. Your videos are exactly what I've been looking for as I prepare for the next school year. Thank you for sharing all of these useful tips!
Thank you for the kind words! So glad the video was helpful.
The GOT names! Nice touch!!
You explain very well. I learned a lot with this tutorial. Tks.
Wow! Lots of good tips here! Looking forward to viewing the next one!
Awesome, thank you!
Thank you, Ms. Teacher Lady!
(Now I have to change my favorite teacher answer in all my security questions.)
LOVED YOUR GREAT VIDEO AND I THANK YOU VERY MUCH FOR THIS EFFORT. YOU ARE A GREAT TEACHER. WISH YOU THE VERY BEST.
You're very welcome!
Very helpful video on formatting with Google Sheets. I learned several new tricks. Thank you for sharing your knowledge.
Yay, happy to hear!
You make excellent vids! Lot's of great & important tips dispersed in an efficient manner. NO FLUFF!
Thanks a lot! Appreciate it. :)
Easy to follow along with. You've made something seemingly difficult fun and inspiring. I'll make sure to pay it forward. Thank you. 🙏
Fantastic, Teacher Lady! Thank you!
You are a great teacher. Thank you.
Very very helpful!
Super easy to follow. You are so helpful. Thank you for putting in the time. I have subscribed to see all your videos to get better at Google.
Awesome! Thank you!
Learned a ton from this. Thank you!
So helpful! Thank you!
Thank you so much for an excellent presentation. It helped me a lot for an assignment I needed to complete and as I'm not too familiar with Google Sheets - its was very much appreciated. You also have a wonderful way of presenting
A great, comprehensive video, thank you!
Thank you so much !! I really needed this tutorial.
Thank you very much! This video is helping me a lot :)
Great tutorial.....thank you!
absolutely loved the content. keep up the good job.
Take love❤
this is amazing - you are such a great help!! Thanks again.
So clear! Thank you!
Thanks! Very helpful.
I am so glad I found you! I am a teacher and I want to make life easier and organized with data! This helped so much!
So glad it was helpful!
Thank you very much for this video.
This was very helpful. Thank you!
very helpful and clear to understand. just learned about conditional formatting - if students enter correct answer in cell - the cell can turn green to let them know answer is correct. My question is how can I protect this formatting so that kids can't tinker with it? Can you show us how to do that?? I'll look for that video.
A Million and one thank yous!
Thanks so much for doing this!! It is so helpful. Would love to see more videos for google in the classroom. Do you do your gradebook in google too?
Thanks for this tip 3:37!
thanks was very helpful
Thanks a lot...
Great video...very helpful. Is there anyway to change one individual cell width, not merging, but just that one cell?
Thank you for the video. Do you have a video that explains how to set up a Google spreadsheet for 8.5" x 11". I have one and it scrolls very long. When I try to print, (hitting fit to page) it ends up cutting rows off in the middle. Hope that makes sense. Thank you!!
Hi Cindy,
Fit to Page, Width or Height usually does the trick. Sometimes you have to play around with the settings a bit.
Do you have a shareable growth tracker?
In Excel ctrl+ arrows allow us to jump to the last value of the column or row. What's the equivalent of that in google sheet?
Been trying to print a file ,,, I have 1final colmn that prints, by itself, on a SEPARATE pg. Are there Margin settings I can adjust, [There is space available on my Landscape sheet.].
I can’t find the third video on Google Sheets that you mentioned in the 2nd one! Is it available?
This is awesome, so many helpful tips and easy to follow along!! What font did you use for "October" in your monthly calendar, I love it! Do you design fonts as well? Thanks again!
How did you get your student growth data formated like that
Instead of resizing the columns multiple times, I'd just select them all and double click the spot used to resize them. This will make each column be resized to its optimal size :)
Would you please explain how: to place the file icon on DESKTOP. Thanks!
I sense you are well knowlegible to advise on this predictiment. My 'sheet contains 8 colmns., however, I only want to display 5, on a Chart.
Is there some Formatting/Shortcut option, I could use to achieve this? Thanks!
Just saw your application of the CTRL key. Prob. solved!
I think filter can work
Thank you 🙏🏻
Could you help me? I would like to input a time in minutes and seconds, and have it display in just seconds for printing. For example if I type in 0:10:06 or 10.6 (as in 10min 6seconds) I want 606 to be displayed in that cell. If yes, could you also do this with hours?
How do I take a freeze off column A?
Hello Teacher Lady! I am using Google Sheets for my small Business. When I make an invoice and download it into a PDF form the font is so small.. how do I fix this. BTW I put the font as high as 18 so it can be a little visible. THANKS!!!!!!!!
Make sure you have Fit to Page or Fit to Width/Height selected. Try each of them to see which one is best for your specific document.
I learned how to make a crossword puzzle in sheets for my students' distance learning. I am having trouble editing the notes attached to the across/down clues. I changed the numbers in each note but when I click on the print option to view it, the old numbers are still showing. Do you know how I can change these? Thanks for your help.
Hi Mary,
I'm not sure what you mean by "notes" -- Can you elaborate?
Hello There!!!
Q: Microsoft Excel Made It So User Friendly To Locate, View And Delte Duplicates With Highlights. I Know Google Sheets Has A "Unique" Way Of Doing Such But It's NOT User Friendly At All. Is There An Easier Way To See, Manage and Have Duplicates Highted To Work WIth Using Sheets? My Job Does Not Use Microsoft Any Longer, We've Transitioned Strictly To The Use Of Google EVERYTHING, Can You Please Help?
what if one student had 3 lunch choices or say this column was subjects and each child had 5 or more different subjects under a 'class' column. How do you sort and filter each subject
On your Growth Data Chart, it looks like you have an image inserted into your cells for your title. If so, what size image did you build so it didn't get wonky? Also, what font is that?! I NEEEEED it in my life.
If you insert the image into the actual cell, it automatically resizes the image based on the width/height of the cell. I believe the font is from A Perfect Blend -- one of the ones with coffee in the name (can't remember exactly).
When you sorted by last name, all the data went with it! Mine sorts the name column but leaves the data of the previous student list so it's all mismatched. How do I fix this?
Hey, you might want to freeze the last name column before you sort it. That way the rest of the data stays aligned with that column.
LOL I noticed that all your students names are names of characters from Game Of Thrones
How to high light cell which is greter than next cell
Thanks! My google sheets game about to be way prettier!
Great tutoials on Google Sheets, thanks for posting them. But your playlist of them has #1 & #2 REVERSED! (I thought I was the only one who makes silly mistakes like this and doesn't notice.)
Baric Dondarian is bringing blackstrap rum from home. Keep him in the front of the bus.
😂😂😂
Cool tips, but we're just supposed to believe that all those opposing factions from Game of Thrones would allow themselves to be organized in a single spreadsheet? I'm not buying it. Daenerys Targaryen doesn't do 'permission slips'.
😂😂😂
This is brilliant, thank you! BUT the faint background music is driving me nuts! Can you get rid of it somehow? Thank you
Game of thrones fan
Good presentation, but please slow down.
Try slowing down the video in settings, I've used it a lot on fast videos so I can keep up.
You know how to teach
Thank you, I've so many sheets that will be that bit better now. Khal Drogo wouldn't fit in a small t-shirt by the way.lol
Hahaha, best comment.
text
so helpful! Thank you