Google Sheets Beginner Tutorial
HTML-код
- Опубликовано: 14 июл 2024
- Google Sheets Beginner Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Who it's for: Anyone looking to gather, format, and interpret data in a spreadsheet.
What it is: Google Sheets is Google’s free, web-based spreadsheet application that mirrors the magic of Microsoft Excel, with some standout features and key differences as well.
What you'll learn: First, students will be shown how to navigate the app. Then, they’ll learn the basics like creating and sharing spreadsheets. Next, they’ll learn how to calculate data with functions and formulas, as well as how to filter and sort all their data. Finally, users will get some hands-on time with popular features like Pivot Tables, AutoFill, VLOOKUP, Macros, and more.
For ad free training and certificates please join Learnit Anytime:
www.learnitanytime.com
Enroll in our live, instructor-led Google Sheets classes:
bit.ly/3K2WnEK
For Private Group Trainings please visit:
www.learnit.com/private-group...
Start 0:00
Introduction 0:03
Start Page 0:28
Interface 2:10
Search the Menus 3:46
Navigating and Selecting Cells 5:51
Entering and Editing Data 8:37
Explore 11:49
Performing Simple Calculations 17:03
Saving 19:57
Introduction to Google Drive 21:04
Building Basic Formulas 24:22
Using Simple Functions 28:03
Copying Formulas and Functions with AutoFill 32:50
Relative vs Absolute Reference 37:15
Inserting Rows and Columns 43:30
Moving, Copying, and Pasting Data 46:57
Using AutoFill to Complete a Series of Values 49:54
Cell Formatting - Align, Text Rotation, Text Wrapping 53:07
Formatting Worksheet Data and Using Cell Design 57:19
Using Sheets Templates 1:00:29
Inserting, Deleting, Renaming, Moving, and Copying Worksheets 1:02:02
Freeze Panes 1:04:49
Currency Formatting 1:07:44
Hiding Rows and Columns 1:08:34
Spell Check 1:10:39
Using the Full-Screen View 1:12:00
Printing 1:12:55
Download Options 1:14:31
Publishing Sheets to the Web 1:15:16
Sending Sheets as Emails 1:16:21
Conclusion 1:18:14
#GoogleSheets
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
thanks! it's 2024 and I am learning a lot from this video from 3 years ago. you're such a great teacher! lol
Great to hear!
I was trying to use excel for the past many years and didn't find a proper tutor, until I stumbled upon this site. Thank you very much, for explaining in a simple manner wherein a lay man can understand and use the service professionally. I highly recommend all to learn from here.😀
Thank you so much for the kind words!
I have tried several different tutorials. I am an absolute beginner and you really helped me breakthrough my anxiety with your deliberate, cheerful, skillful way of presenting. Thanks so much!
Thank you for watching Steven!
Wow, I've never tried to make a spread sheet before. I was nervous, and imagined all sorts of wild formulas that I would have to memorise. You make it simple to understand, and I am so relieved that there is no algebra lol
Though I have been using google sheet for a while and knew some advanced functions, this tutorial still taught me many unknown to me. Great job, Joe!!!
You're very welcome!
I have just started and honestly, no lecture has ever been so pleasantly delivered, thank you for the great delivery.
You're very welcome!
I never liked Google Sheets because it was always hard for me, but tonight, you broke down the barriers so easily that I have fallen in love with it soon after watching your video. This is the best that I have seen so far. Thank you! Thank you!!
Glad it was helpful!
Extremely good and the way he explains everything with samples over and over is great, thank you!
You're very welcome!
thank you so much. i thought this was gonna be another one of those boring, complicated videos, but no, you did a great job! like no joke, i now know how to do anything on sheets after watching this video. you're a legend sir
You're welcome!
This is the best online tutorial I have ever seen. I am a complete beginner to Sheets, but I feel so confident using it now. Thank you so much for this!
Glad it was helpful!
Oh my gosh, thank you so much for creating this tutorial! It's one of the easiest to-follow ones that I've ever used. I especially like how you break all of the information down into tiny steps and give us a chance to practice them on our own as opposed to glossing over the information. I wish that I had this back when I was in college. It would've made finding a job that's right for me so much easier.
You made learning fun. I would've paid for this video. I was gonna watch just a little bit after a long day, but you made it so interesting. I finished in one sitting. I loved the pauses for practice too. Great job!
Glad you enjoyed it!
The lessons are simple and straight to the point.
Well done, enjoyed the lesson a lot.
Thank you for the kind words!
I can't believe my school made me pay just to be taught ms excel when there's a guy like you here on yt. thank you very much for a very informative, understandable video tutorial.
Thank you so much for watching Chad!
Thank you! Just finished in a couple of days & now looking forward to the advanced tutorial!
Hope you enjoy it!
Thank you for your excellent teaching style. Spreadsheets have always been difficult for me but your explanations are easy to understand. Thank you.
You're very welcome!
Very nice class , explained it in very simple words . Thank you Joe 😊🙏🏻 I did the entire class on my laptop on the side .didn’t have one hiccup
Thank you for the kind words Prajwal!
@@LearnitTraining P oo
,
Bewafai lagta na thi tu Deva bhai sahab khulvana
Wow thank you so much I almost forgot everything found your video initially I was like what more than an hour video but once I started watching it man I just get in with the flow . Instructor Joe he has a nice way of delivery. Keep it up guys ur now my priority to learn about tools checked ur playlists it's 👏🏻. Wish u constant growing thank you for this teaching 🙏🏻
Thank you so much for watching M. Rajesh Kumar!
Wonderful tutorial. Been using sheets for 5 years and still learnt a lot. The good thing is I finished in 1 sitting almost. Now I can't say I have short attention span. It's the teacher's fault if I don't sit longer for any tutorial.
Great to hear!
Starting a new job tomorrow and the company predominately uses google sheets. Thank you for this insightful guide.
Best of luck at the new job!
I was always intimidated by the whole spread sheet bit, but you've made it a cinch. Thanks. 👍👍👍
You’re welcome 😊
Easy to learn from your instructions and walking us through the process!
Thank for watching and thank you for the kind words!
Very nice! Great for people like me who didn't know anything about spreadsheets before watching. Thanks, Joe.
Yes Amazon is filled with that sort of mentality via data manipulation/over charging for dildos.
Glad you enjoyed it!
Excellent video! The content was very clear and the pace was just right. Many thanks.
You're welcome!
I've learned so much watching this and applying it on my own vs. taking a class at work. Thank you for this.
You're so welcome!
i never thought i would need a google sheets tuturial.
Here to help!
You’re a life saver bro. Had to learn basics of Excel/Sheets for a new job and this saved my ass lol
You are very welcome Trysten!
The pacing made learning easy. This is the first time I viewed an excel tutorial without having a headache. 🤣🤣 Thank you, keep it up!
You're very welcome!
Really good class!! You are such a great teacher !!Thank you so much 😊
Thank you! 😃
Ahhhhhh -- so calm and well-paced, with helpful examples and repetition -- a stand-out in a messy sea of hype
Thank so much for the continued support CHITUS! We hope you are learning a lot!
I thought I was a spreadsheet literate, until I watched this. Wow, I learned a lot, thank you!
You are very welcome!
I just subscribed to your channel. I love the patience while teaching. Its like having a hand-on class. Thanks Joe
Awesome, thank you!
thank you so much for this wonderful teachings I literally followed step by step along side you teacher you made everything too easy and simple I'm impressed .KUDOS!!!
You're very welcome!
Thank you this was very helpful. You taught me some new things and helped remind me of others. You have a great style. Great Job Joe!
Awesome! Thank you!
Wow! The presentation 👌I feel so empowered !! Thankfully Ms.J
This really is food for the mindbrain 🤯 but its 💯 proof ; the truth!
You are so welcome!
The best, most easiest tutorial I have seen yet. Great job and Thank You!!
You're very welcome!
Thank you, very well delivered and paced.
Glad you enjoyed it!
An informative,effective and on-the spot practical approach has helped me grasp a superb grip on google sheets. Enormously helpful. Thank you so much.
Glad it was helpful!
You are an excellent instructor, very nicely done. Thank you!
You're very welcome!
Wonderful learning all these again. Beautifully tutored ❤❤
Thank you for the kind words!
Great tutorial, first time using Google Sheets at work and I really like a lot of the features. Thank you
You're very welcome!
I absolutely loved it! Thank you!
You're so welcome!
@@LearnitTraining can I get the link to download this sheet containing data so that I can practice while watching. Would be really grateful to you all
Thanks for your helping this course
I wish all learning was as much fun! Excellent video, will follow any of your videos.. hopefully more. Thank you
You are very welcome Kim!
At last, a tutorial that was fun and informative!
Glad you liked it!
I just like how you explain and the pause to practise. Thanks a lot. You got a subscriber.
Thanks for the sub!
This was a great learning video. Thank you so much You provided great instruction and it was extremely helpful. I look forward to discovering more of your learning videos.
Glad it was helpful!
You're very welcome!
This is actually.... relaxing? Lol! Thank you!
You're welcome 😊
😂😂
Truely a wonderful video tutorial. Thank you guy a lot guys. I really appriciate it.
Our pleasure!
You're the best....great tutorial. thanks for taking the time to make this video. Now onto the Advanced Tutorial!!!!!
Glad you liked it!
Just went through the video.. very easy to understand. Thank you so much for this!
You are very welcome!
I'm new to all of this and your video and clear instructions have been a great help!
You are welcome! Thanks for watching!
It was a great learning of Google SpreadSheets and I really understood the each concept and I am sure I can use this in my daily life of work .. Thanks To Joe for bringing up this to the World.
You're very welcome!
Thank you so much Joe, we learn a lot just watching this video.
You are very welcome!
Absolutely astounding video! Thank You, Joe!
Glad you enjoyed it!
Thanks for this tutorial
This is incredible. Thank you so so so much for creating this and making it available for everyone.
Our pleasure!
GREAT WORK, JOE.
Thank you kindly!
Thank you so much for you efforts
What a great explanation 👏👌🏽
Thank you 😊
You're welcome 😊
Thank you so much for this., i really enjoy the session
You're so welcome!
thank you so much for creating this tutorial
You're very welcome!
Wow I really needed this! Thank you so much, great job 👍🏻
You're so welcome!
Thanks a lot! You made me to use Google sheet right away.
Glad we could help!
This was great! I used it as a refresher but I defo learned some new things.
Thank you for watching Matthew!
Amazing, the best tutorial I’ve ever seened. Thankyou
You're very welcome!
i really enjoyed this tutorial,thanks for sharing it.hopefully i can watch the rest of series very soon.
Glad you enjoyed it!
Excellent! It's really for beginners.
Glad it was helpful!
Thank you so much sir.....
Thanks buddy,,,,, learning this from Kenya and it helps alot..
Glad to hear it!
Thank you, this is really helpful!
You're very welcome!
The video was very helpful. Thank you so much
You are welcome!
Finally found a helpful tips.Thank you! because of these tips, I've learned a lot.
Great tutorial, I learned a lot from it. Thanks!
Thank you for watching!
Thanks for this video! It's easier learning from you.
Glad it was helpful!
Thank you much !!! excellent tutorial 🤩
You're very welcome!
Thank You for this useful video. I learn alot from this video.
Glad it was helpful!
thank you so much joe
You are very welcome!
Thank you for your effort, very useful.
Glad it was helpful!
Muchas gracias!
You are very welcome!
THANK U SO MUCH LOVED YOUR EXPLANATION FROM INDIA
You are very welcome!
Thank you, Joe.
You are welcome!
Excellent video. Well explanation. Clear understanding. The other videos; are annoying and can't understand the person.
We are glad you enjoyed the video!
Thank you so very much I appreciate you explained it so well. Just learning to do spreadsheet.
You're very welcome!
Really, you made learning fun. Learning something should be like what you did there. Keep up the fantastic job. Big thank you.
Thanks for watching!
Thank you for the amazing class!
You're so welcome!
THANK YOU!!!
You're welcome!
great explanation, thank you so much.
You are welcome!
I enjoyed watching this video, so educative and informative. Thank so much!😍
You are so welcome!
Thanks! Love it!
You are welcome!
Thank you!
غمل جيد لم احتاج لتعلم الكثير من الانجليزية لاتمكن من فهم الشرح مفردات سهلة وانتقالات مرتبة وشرح يبسط المعلومات , من الصعب ان اجد محتوى بتلك الجودة فى اليوتيوب .
شكرا لك على المشاهدة! نحن نبذل قصارى جهدنا لجعل تعلمنا في متناول الجميع
Your teaching is fantastic bro
Thanks!
The way you Teach is very good 👍
Thank you! 😃
So informative, great video
Glad you enjoyed it
vEry HAPPy that I was able to find this tutorial. Very accommodating! THANK YOU!
You are welcome!
@@LearnitTrainingTO THE PHONE 🤳📱
You are a great teacher, Sir.
Love from Bangladesh.
Thanks and welcome
Thank you for this video. I really appreciate your effort and that the video is to the point.
Glad it was helpful!
Thank you for sharing! Great job!
Thanks for watching!
Stellar presentation. Thank you.
Glad you enjoyed it!