Тёмный

Make Your Google Sheets Look PRO in Under 10 Minutes! 

New EdTech Classroom
Подписаться 220 тыс.
Просмотров 320 тыс.
50% 1

Learn the best formatting tips and tricks and significantly boost your Google Sheets skills in this quick tutorial!
=======================================
Get started with our award-winning micro-courses for free at nextgenerationteacher.com
Become a member of this channel to support our work!
/ @newedtechclassroom
For tips, ideas, and resources for how to use education technology to increase engagement, rigor, and creativity in your classroom, visit: www.newedtechclassroom.com
Follow New EdTech Classroom on Twitter: / newedtechclass
Facebook: / newedtechclassroom
Instagram: / newedtechclass
TikTok: / newedtechclass
LinkedIn: / the-new-edtech-classroom

Опубликовано:

 

20 сен 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 300   
@mr.jaycasey4676
@mr.jaycasey4676 2 года назад
It didn't matter to me that I knew all of this information. I was so incredibly impressed at your efficiency in introducing so much useful information that I watched this video through until the end. No time wasted here. This is the type of video that makes me subscribe to a channel!
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Awesome! Love to hear that, Jay!
@Elczupakadra1
@Elczupakadra1 2 года назад
agreed
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
@@Elczupakadra1 Thanks so much! 😀
@allenlivera1611
@allenlivera1611 2 года назад
Excellent tutorial, with not one wasted word. I like lessons like this, small bites that don't overwhelm. Nice job!
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Thanks so much! Glad to hear you liked it!
@kimberleymalloy3098
@kimberleymalloy3098 3 месяца назад
This was SO helpful! I'm a beginning Assistant Principal and charged with overseeing schoolwide attendance data - this was exactly what I needed to help me sort and organise! Thank you so much for the tutorial!
@teresiaharrison8836
@teresiaharrison8836 2 года назад
I have always been intimidated by Sheets and Excel. This video was a game changer! I see so many possibilities and will be applying several of these tasks immediately. Your channel has increased my productivity as an educator. Big thanks!
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Love to hear that! You're very welcome!
@tptrading_23
@tptrading_23 Год назад
me too girl!!!
@aliciapearce9955
@aliciapearce9955 2 года назад
Great information! I knew most of the features that you showcased but I was happy to learn a couple of new things. :) My next steps are to learn how create percentages based on a series of marks (including checkboxes) and the IF feature, e.g. convert that % into a letter grade. These are a couple of things I saw in another video on how to use (but didn't provide a how-to make yourself) a particular company's purchased units from TPT which include Sheet assessments. I am not purchasing, thus I need to learn how to do myself lol
@MsMerwoman
@MsMerwoman Год назад
I'm a retired teacher, but I still like to watch your tips on using various apps. This one was just what I needed when I was teaching but is also useful to me now. As usual, you have done an excellent job!
@NewEdTechClassroom
@NewEdTechClassroom Год назад
I appreciate that Corby!
@StormOfEclipses
@StormOfEclipses 4 месяца назад
Mostly just using sheets to keep up with random lists of stuff, and to learn how it works so I can use it for more important things down the road. Thanks for keeping it short and getting straight to the point! I'm definitely saving this somewhere so I can look back at it when I need it.
@mikekent8148
@mikekent8148 2 года назад
nice tutorial! drop downs are a great win in Google sheets. personally I prefer creating a separate worksheet for drop down options and use the data validation > select from range option. what's nice is to put the range to be the whole column in the options worksheet and then I can quickly add or remove options (or fix typos) without having to open the dialogue menu 😊
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Great tip Mike! Yeah the drop downs are such a simple way to make the spreadsheet so much more functional and professional looking.
@viviandibrell849
@viviandibrell849 3 месяца назад
I am brand new to google sheets and this was so helpful! I am trying to use google sheets for inventory tracking for a new Etsy shop.
@angelle07
@angelle07 2 года назад
This is a great video. I feel that I don't use Sheets as much because, much like excel, I find it a bit intimidating. This made it much easier to understand. I will be saving this to look back at frequently. Thank you so much.
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Awesome! Glad to hear that!
@vibecheck8901
@vibecheck8901 Год назад
Now that I'm starting as a secretary I've been floded with work. I choosed google sheets to organize the organization's log. Thanks to you now I've learned some tips that have made my life easier. TSYM!!👍👍
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Good luck in the new secretary role!
@justinpenascosa
@justinpenascosa Год назад
What the heck?! This was such a great and well-made video! I'm trying to learn Sheets for the first time because the thought of being able to log down literally ANYTHING I want is such a great skill I envy.
@NeilyonNutrition
@NeilyonNutrition 2 года назад
Super! I use sheets often and knew many things you outlined in the first few minutes....but then I learned a LOT more - so thanks for that! One challenge I have - and it happens often - even if I already had things like text wrap, vertical align (center of cell), etc for the whole sheet, it doesn't always work when entering new info. It seems to divert back. Make sense? Would appreciate thoughts/solution.
@Precisechi
@Precisechi Год назад
I love it when I find the most comprehensive and simple explanations. THANK YOU!!
@NewEdTechClassroom
@NewEdTechClassroom Год назад
So glad you found it helpful! 👍🏼
@user-pv4ff1to2e
@user-pv4ff1to2e 4 месяца назад
I'm new to google sheets and this was fantastic! Thank you!
@pete1589
@pete1589 14 дней назад
Extremely extremely helpful
@allisonmaldonado8008
@allisonmaldonado8008 2 года назад
THANK YOU x 1, 000!! I have lost track on how many times that I have gone to your videos for a tutorial on "x" topic. I love your instructional style and your straight-forward approach to helping viewers understand technology. Additionally, your great sense of humor always makes me laugh!! :) Mil gracias!
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Thank YOU for this amazing comment, Allison!
@sunbroker
@sunbroker 7 месяцев назад
Thank you! I was able to use these suggestions right away. It was a well-paced video
@naduellab
@naduellab 2 года назад
This is the best! All that in just under 10 minutes, I feel more comfortable with Google Sheets. I can’t wait to use what I learned here. Thank you so much🤩
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Awesome to hear Naduella!
@ProlificOaktree
@ProlificOaktree 2 года назад
I like the way you put this video together. It's a bit more "fun" than a typical spreadsheet video. Nice work.
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Thanks so much! That's what we were going for so glad to hear that feedback :)
@tptrading_23
@tptrading_23 Год назад
me too i love the funny pictures its so engaging
@rebekahrobbins1340
@rebekahrobbins1340 Год назад
Wow, this is amazing! I'm going to be so prepared this year. Last school year was my first year as team leader, and this knowledge is going to be an entire game changer.
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Right on Rebekah! Happy spreadsheeting :)
@Chanok69
@Chanok69 Год назад
This helped out a lot. I really never used sheets since I never had any use for them, but in my new job I do need to know and this just showed me what I needed to know!!!! Thank you!!!
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Right on Juan! Happy spreadsheeting 👍🏼
@monicabalmes3699
@monicabalmes3699 Год назад
I'm super enjoying this lesson and actually doing it while he's there demonstrating all of this. Goodness I am so thankful I found your video, this is really helpful in doing my inventory!
@NewEdTechClassroom
@NewEdTechClassroom Год назад
So great to hear it Monica!
@mariagandara269
@mariagandara269 2 года назад
OH MY GOSH! I can't believe I just learned how to create a Google Sheet! I feel so accomplished! Your video is amazing and just enough to get me started! Thanks a million! Your video was worth the million times I replayed it to follow you step by step! You're the best! Thanks from Chicago😀!!!
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
You did it Maria! Happy spreadsheeting :)
@thatmortgagelady
@thatmortgagelady 4 месяца назад
This was the best ever!!!!! I finally feel like I can actually do it! Thank you!
@user-cs8gg7he5w
@user-cs8gg7he5w 10 месяцев назад
Seriously ...love the way you present this. Great video
@kaileybaker4488
@kaileybaker4488 3 месяца назад
This was amazingly clear, quick, just the right amount of information and very understandable. Thank you so much, super helpful!
@jethrotejano2013
@jethrotejano2013 Месяц назад
Great video. Note that Data Validation can come with its own coloring directly so there isn't really a need to apply conditional formatting on top of that. And adding Filters is also a good way to group together columns.
@corondatodd5632
@corondatodd5632 2 года назад
Can you please make a tutorial on how to make this data into graphs without displaying student names? Please? And great job as always! I love your tutorials.
@kristym4243
@kristym4243 Год назад
Extremally helpful info and there is no wasting time its straight to the point. I'm saving this one!
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Glad to hear it Kristy! 👍
@sofiamurgado606
@sofiamurgado606 8 месяцев назад
Excellent video! He’s a true teacher and made learning very simple. Thank you!!
@qrushfitness
@qrushfitness 5 часов назад
You earned my like in the first :3 secs 👏🏾 I just watched another video and let’s just say they tried thier best lol You came with the fire value immediately 🙏🏾
@Mister-gc8pt
@Mister-gc8pt Год назад
One of the best tutorials ever! You don’t waste time with small talk!
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Glad you found it helpful Mister!
@ellenbakerdubois2214
@ellenbakerdubois2214 2 года назад
Excellent ! I can see some other uses for tracking in Google Sheets such as billing for English classes, forming groups... you are awesome !
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Definitely!
@christasiastrickland7326
@christasiastrickland7326 2 года назад
You mentioned around 20 things in this video but somehow you taught me 27 new things 😁🤯. Thank you for the simplicity of it all.
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Ha! Right on :)
@AlexEckhart
@AlexEckhart Год назад
Wow! Thank you for sharing this workflow! Exactly what I needed that I didn't even think was possible! ⚡🙏
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Glad it was helpful Alex! 👍
@JenoSingson
@JenoSingson 7 месяцев назад
I ABSOLUTELY LOVED THIS VIDEO! THANK YOU FOR SMALL HILARIOUS TOUCHES.
@jessicaurdaneta88
@jessicaurdaneta88 2 года назад
Thank you so much for sharing this informative learning. I will definitely apply this in my future sheets task.
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
You're welcome!
@folsterfarms
@folsterfarms 2 месяца назад
2024 I used a lot of this information TODAY. Thank you for such a well-done and concise video!
@dhruvbaria5985
@dhruvbaria5985 2 года назад
Your way of presenting and those gif's playing made this tutorial enjoyable.
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Thanks!
@mrs.george3190
@mrs.george3190 2 года назад
Clear and precise! Thank you!
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
You're very welcome!
@atishsihi8860
@atishsihi8860 2 года назад
Nice tutorial, if you can cover some more functionalities like this, it will help a lot. Thanks again for all your super videos.
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
You're very welcome!
@user-kb5si1el7z
@user-kb5si1el7z Год назад
What a video, the editing omg. Has to be one of the best informational videos I´ve seen in my life, you deserve to blow up definitely thanks!!
@rpgmafia8363
@rpgmafia8363 2 года назад
The only Tutorial that helped me with the drawboxes etc. Thank you sir
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
You're very welcome! Glad to help!
@user-ps4tv7lb6y
@user-ps4tv7lb6y Год назад
Thank you for your time and useful video for the google sheets. I learnt a lot of best ways to minimize my time while working with it. Have a great day!
@user-kw7hn5un2u
@user-kw7hn5un2u 8 месяцев назад
brilliant tutorial thank you!
@MinhNguyen-mk7cc
@MinhNguyen-mk7cc 8 месяцев назад
Thank you so so much for an amazingly valuable lesson!!!😍🥰
@liawinarso4340
@liawinarso4340 9 месяцев назад
i'm teacher from indonesia.. Thank u Somuch sir, for the knowledge... appreciated it
@rashare1247
@rashare1247 Год назад
Thanks for your great content. Im new to sheets. I have created a pricing calculator for HVAC equipment. Its simply calculates the subtotal, taxes and final total for the entered equipment pricing. I would like to share this, not as a shared document, but as individual, stand alone calculators for anyone who has a copy. They should be able to manipulate the fillable cells without affecting anyone else's copy. Is this possible?
@rveats
@rveats Год назад
That freeze row trick was epic !
@NewEdTechClassroom
@NewEdTechClassroom Год назад
🥶
@steveo44
@steveo44 Год назад
Absolutely great tutorial. Thanks so much. No messing around here
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Thanks so much Steve!
@TechWithBabak
@TechWithBabak Год назад
I knew some of these but your presentation style is quite nice and engaging! Love your floating head and use of muppet samping!
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Glad you liked it Babak! 🙏🏼 I need to use my puppet more often!
@cathymcgrath7909
@cathymcgrath7909 2 года назад
So many time savers here. Thanks for sharing these.
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
So glad you found it helpful!
@jag2333
@jag2333 2 года назад
I'm new to sheets. Thank you for sharing this. This information has been very helpful and useful for me. 😊🥰😊
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
You're very welcome, Jo!
@WestPat23
@WestPat23 Год назад
I was able to create while watching, thank you
@sheena6696
@sheena6696 2 года назад
You taught me in 10mins what I couldn't learn in 3 MONTHS in class, thank you
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Ha! Glad you found it helpful Sheena!
@sajiali9336
@sajiali9336 2 года назад
Thank you i have been looking for a video that is clear and concise. I look foward to seeing more.
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Glad it helped Saji!
@k80rock
@k80rock Год назад
Thank You! I appreciate all the time- saving tips! Super helpful 😅
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Glad you found it helpful K80 G!
@tptrading_23
@tptrading_23 Год назад
OMG thanks sooo much! my sheets look so much better, and it didn't take a week to fix!!! I subscribed !!
@juliecastaneda-hicks3792
@juliecastaneda-hicks3792 Год назад
You speak my language! Thank you!!🙏🏼🙏🏼🙏🏼
@kimsandy8969
@kimsandy8969 Год назад
Teaching skills are off the chart! Thank you!
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Thanks Kim!
@mainstreet-mastery
@mainstreet-mastery Год назад
This was a very helpful video. Thanks for sharing so much value!
@rarroo2122
@rarroo2122 Месяц назад
So helpful! Thank you!
@mariaottinger6194
@mariaottinger6194 Год назад
Blown away. Excellent tutorial.
@ademarviniciusfagionfreita642
@ademarviniciusfagionfreita642 2 года назад
Thank you so much for sharing these tips!!
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Any time!
@joecrites
@joecrites 6 месяцев назад
Useful and quick...perfect
@lmwms1
@lmwms1 2 года назад
Fantastic information! Thank you!
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
You're very welcome!
@VeronicaULLOA-bb3wh
@VeronicaULLOA-bb3wh Год назад
Excellent class, concise and precise.
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Thanks Veronica!
@JanelleSeales
@JanelleSeales 11 месяцев назад
simple and straight to the good stuff!
@KimberlyM48
@KimberlyM48 Год назад
You and one other dude have been so very helpful!! Thank you so much for these videos!!!
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Thanks Kimberly! (from the one other dude 👍)
@tayler555
@tayler555 Год назад
For some reason, I cannot do the dropdown box like you instructed at 3:30. When I click Data Validation, it just adds data validation rule to the right sidebar, but does not give me the same options in this video. :(
@jjmmusicc
@jjmmusicc Месяц назад
great video, thank you
@taniapocius3964
@taniapocius3964 2 месяца назад
Your video was helpful. Thank you for sharing!.
@melodischonken8241
@melodischonken8241 2 года назад
This is so helpful! Thanks.
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
You're very welcome, Melodi!
@anthonyrasberry6715
@anthonyrasberry6715 Год назад
Great info and even better delivery!
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Thanks so much Anthony!
@leighm
@leighm 2 года назад
Such a helpful video Thank YOU!!
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Glad it was helpful Leigh!
2 года назад
Excellent! Thank you!
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
You're very welcome!
@misstorresivette
@misstorresivette 2 года назад
Thank you so much. I was wondering how to create this type of tracker. I really enjoyed your pop-ups. Can you create a video on how to add pop-ups? Thank you
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
We use Adobe Premiere Pro to make our videos, and the pop ins are images we're bringing in during video editing. Glad you enjoyed them!
@user-db6pn5eu2b
@user-db6pn5eu2b 2 года назад
Amazing video!!! Thank you!!!
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
You're welcome!
@Palash_Das
@Palash_Das 4 месяца назад
Best tutorial ever 💯👌
@yimsakii8559
@yimsakii8559 Год назад
Thank you for your guidance
@NewEdTechClassroom
@NewEdTechClassroom Год назад
My pleasure Yim!
@charleschukwurah9126
@charleschukwurah9126 Год назад
coolest teacher everrrrrrr
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Ha, thanks, Charles!
@stratixfinance
@stratixfinance Год назад
Oh sick, sweet video. Thanks for keeping it short and sweet.
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Thanks Yaroslav! 😃
@latoyaluise467
@latoyaluise467 8 месяцев назад
loved this! really appreciate it
@brynevans9699
@brynevans9699 Год назад
Incredible videos!! Can I please ask, how did you get the video of yourself talking with no background?? What program did you use?
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Hey Bryn! I used a green screen and a program called Screenflow. It's about $100 and has a bit of a learning curve.
@profsport2536
@profsport2536 Год назад
Thank you, earned a subscriber. Is there a way to create a %. For example somebody does something 100 times and may get 2 wrong, is there a way for me to set rules that turns the % a colour when a certain percentage is hit?
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Hey ProfSport! Yes you can use percentages in Sheets. Here's a page with more info on it - spreadsheetpoint.com/calculate-percentage-in-google-sheets/
@richardhead6792
@richardhead6792 2 года назад
More like this would be great
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Can do!
@mangalambahavathsingh3023
@mangalambahavathsingh3023 2 года назад
Greetings from India. Informative. Thanks
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
You're welcome!
@milaniequizo7186
@milaniequizo7186 Год назад
I’m so impresses. It gives me a lot of ideas on how to do my business google sheet.
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Awesome! Happy spreadsheeting Milanie 😃
@douglasfriedman5032
@douglasfriedman5032 Год назад
Like the sense of humor, this stuff is deep.
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Glad to hear it Douglas! Happy spreadsheeting :)
@user-uw4if2mb8h
@user-uw4if2mb8h 10 месяцев назад
Very useful, thank you so much!
@nontokozothango5191
@nontokozothango5191 2 года назад
Great content!!!! What do you use to create your videos?
@NewEdTechClassroom
@NewEdTechClassroom 2 года назад
Thanks! We use a combination of Screenflow and Premiere Pro
@user-ko3kk2nv5x
@user-ko3kk2nv5x 11 месяцев назад
You are VERY good with this system! I'm just getting my feet wet and could use some help. Can you give me a hand with a couple of actions we are trying to acomplish?
@Texaschic79915
@Texaschic79915 Год назад
Newbie ! Thanks for this. I’m doing my sheet tomorrow
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Hope your Sheet came out looking PRO!
@donica.sadberry.real.estate
Great information! This will help make it easier for me to create my social media schedule for all of my business platforms.
@NewEdTechClassroom
@NewEdTechClassroom Год назад
For sure Donica!
@redmond007wa9
@redmond007wa9 5 месяцев назад
@NewEdTechClassroom can you please tell us what are tools you used to produce (recording, editing, ... ) this video? I want to send out videos for my clients with these tools. Thank you so much 🙂
@splitfeys4566
@splitfeys4566 Год назад
Thanks man, you helped me with my business
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Glad to hear it!
@levisaidmyname
@levisaidmyname 3 дня назад
Very good video!
@tbagonyou6937
@tbagonyou6937 7 месяцев назад
holy Sh*t. you learn something new everyday
@robertobehar9238
@robertobehar9238 Год назад
Excellent video. Thanks very much.
@NewEdTechClassroom
@NewEdTechClassroom Год назад
Thanks Roberto!
Далее
10 BEST Google Sheets HACKS for Teachers
21:12
Просмотров 63 тыс.
15 Functions in Google Sheets You NEED to know!
17:30
Просмотров 419 тыс.
ИСПОЛНЯЮ МЕЧТУ Анастасиз
34:51
Просмотров 895 тыс.
Incredible Wheel Restoration Process 🚙
01:00
Просмотров 2,1 млн
Learn FigJam in Under 10 Minutes!
9:49
Просмотров 11 тыс.
Interactive dashboards in Google sheets
17:42
Просмотров 49 тыс.
Beginners Google Sheets Tutorial - Lesson 1
43:16
Просмотров 175 тыс.
5 Apps You Never Knew You Needed
8:37
Просмотров 22 тыс.
7 Google Sheets Tips that will Save You So Much Time!
11:49
Google Sheets Tips for Productivity
8:05
Просмотров 34 тыс.
Google Sheets - Full Course
3:03:32
Просмотров 1,6 млн
10 Google Sheets Tips You DON'T Want to Miss
13:51
Просмотров 555 тыс.