Beginners Google Sheets Tutorial - Lesson 1
HTML-код
- Опубликовано: 11 июл 2024
- Welcome to the first lesson in our series of Google Sheets tutorials for beginners! In this video, we'll cover the basics of using Google Sheets to create and edit spreadsheets.
We'll start by showing you how to create a new spreadsheet, including how to choose a template and customize the layout to suit your needs. Then, we'll walk you through entering and editing data in your spreadsheet, including how to format your cells and use basic formulas and functions to perform calculations.
Next, we'll cover some more advanced features, such as conditional formatting and sorting, that can help you analyze your data more effectively. We'll also show you how to collaborate with others on your spreadsheet, whether you're working with a team or sharing data with a client.
By the end of this lesson, you'll have a solid understanding of the basics of using Google Sheets. In future lessons, we'll dive deeper into more advanced features, such as pivot tables and macros, to help you take your spreadsheet skills to the next level.
So if you're new to Google Sheets and want to learn how to use it to organize your data and stay productive, this is the perfect place to start. Join us for Lesson 1, and let's get started!
Make of copy of the practice material: bit.ly/GoogleSheetsPracticeData
Google Sheets for Beginners Lesson 2: • Beginners Google Sheet...
Learn more about Formulas and Functions: • How to use Formulas an...
How to use Google Drive: Creating basic formulas in Google Sheets
0:00 Introduction to Google Sheets
1:25 Opening and navigating your Google Sheets
4:30 Creating a new blank spreadsheet in Google Sheets
6:19 Google Sheet layout
7:07 Rows, columns, ranges, and sheets in Google Sheets
10:28 Adding some data to your spreadsheet
12:40 Creating and formatting column widths and row height
15:21 How to format your sheet in Google Sheets
20:13 Adding borders and colors
21:29 Formatting for currency and decimal places in Google Sheets
22:30 Creating basic formulas in Google Sheets
30:23 Freeze rows or columns in Google Sheets
31:58 Basic Google Sheet functions
35:28 How to add a chart in Google Sheets
38:53 How to print your spreadsheet in Google Sheets
40:55 Download your spreadsheet as a PDF or Excel file
41:35 Sharing your spreadsheet with other
Game changer! I am a new small business owner and I have never worked with Excel or Google sheets...ever! My eduction in general is a bit limited not mention of have issues with ADHD for the last 40yrs; these videos have truly empowered me. Instead of presenting my work on paper written in pencil, I can now show things like our companies earnings in a clear and professional way. I am literally sitting here in tears. Thank you so much for these clear and easy to comprehend videos! ❤
I am so happy to hear these videos are helping you out!
I love that you go slow enough for us beginners and that we can follow along! THANK YOU!
Who else here cause you lied to your job about being able use Excel and now they want you to use it xD
😅😅😅😅😅😅😅 omg this is so funny😅
omg meee! lol
I'm so guilty 😂
Thank you so much for all of this. You start at the very beginning and pace it perfectly.
Excellent tutorial! Having the chapters as well is very helpful to go back and review a certain topic. Thank you so much for the clear and concise video.
Thank you for your detailed & explanatory teachings. You're a life saver for this times
This was great. Much better than another tutorial I watched just before!
That was fantastic! I really appreciate the time you have taken to present this !!!
LESSON 1 is AMAZING!!! Thank You!! It addresses all the instructions I have been trying to find, but I guess a lot of Instructors think is to Basic? But there ARE still people that don't know the Basics. How to resize columns and rows. How to use the Grids, how to merge, how to print! (it can be so frustrating) I know!, I know! Everyone already knows this. I DIDN'T! And thats exactly what I needed. Now I can start creating my first spread sheet! Love!!
Thank you to show us how to use the basic google sheet for the senior. It is a very good tool . Excellent tutorial !
Thank you Jamie for such a detailed tutorial. It is satisfactory.
Tutorial was great! Thank you so much for all your help. I learned a great deal and it really helps to follow along and do the tasks as you are doing them!
I always wanted to learn Google Sheets and it's a blessing to find this video! Thank you so much for making this.
Thank you! Always helpful and detailed. Best teacher in youtube.
Loved learning with you. Clear and understandable. :)
excellent tutorial, super easy and the way you deliver it super friendly. Thanks a lot!
Thank you so much, Jamie. This is by far the best tutorial I have come across for beginners.
You're very welcome!
Loved the tutorial. So helpful and went over everything I was wanting to learn. Loved how you explained everything
Great tutorial. Super easy to follow and very informational.
Very easy to follow. Great tutorial! Thank You
Awesome video! Really clear stuff!
Wish I had found you sooner! Thank you so much for your teaching methods...
Thanks Jamie! Your teaching and instructions for a beginner is easy to understand and follow.
You're very welcome!
Great info. Can't wait for more! Thank you
Thanks for watching!
Loved this tutorial! Thank you so much!
Great video! I've learned a lot from it. I was planning to just watch at least half of the video but ended up watching the whole thing. I will follow your videos from now on. Thank you!
I need to share this channel to my friends
Thank you so much. It was a wonderful refresher course for me plus I learnt other things I didn’t know. Thank you so much
Your video is very instructive! Well done! Thank you for this
Excellent tutorial! Thank you so much.
I learned so much, I really appreciate the effort you put into this tutorial! Thank you 😁
You're so welcome!
Completed. Now i can use Google sheet. Thanks a lot
Extremely helpful and thanks for linking the practice sheet.
Great Tutorial! Thank you so much!
Informative & understandable
This is my first time using your tutorials and I am new to understanding Google Sheets. You have a great pace and and make learning enjoyable. I learned a good amount and feel more comfortable using Google Sheets now. Of course I will be watching your other videos. All the best and again, Thank you!
Thank you! I really needed this.
Very easy to follow and I learned quite a bit, thank you.
Your first tutorial was so helpful! I was able to follow along and create my own sheet. I didn’t feel like I was being talked down to. Thanks.
Glad it was helpful!
I enjoyed this very much. Very easy to understand Thank you
You are a great teacher!
Thank you this was so helpful!
This was soooo helpful! Thank you!
Thanks, Jamie. Your instructions were great for a beginner.
You're welcome!
Thanks this helped me so much with my new job as personal assistant to a home builder/ architect
I'm happy I selected your video as the first serious attempt to learn this subject. Thank You.
Welcome!
This made me smile, I actually opened my own sheet ❤
thank you so much for this tutorial, it was so helpful and educative.
am a learner and so far am pleased with this, tutorial going through it for the second time ill be a master i can teach anyone else who is not familiar with google sheet❤
Your explanation and direction for a first timer attempting this is excellent sir. Appreciate you sharing your knowledge in such a clear manner 🙏
Thank you for this, i can't wait to lean more
You’re welcome!
thx a lot, that was so helpful
keep up good work for educating people through video. thanks a lot, I was having few knowledge.!!
Wow I learned so much. Thank you
Thank you for this vid! Very informative. I followed very well because your instructions and explanations are simple to understand. You also have a clear voice all throughout the vid.
You're very welcome!
Whoa this is amazing, thanks a lot for putting so much effort into this video
Glad you enjoyed it!
Excellent tutorial.
Damn this guy is a good teacher.. best online teacher for me so far
Amazing 😻
THANK YOU ...VERY INFORMATIVE
Thank you so much you are very good instructor. You speak, slow concise and you make a lot of sense for us. Older folks.
Glad to help!
Thanks!!
Thank you so much!
Wow this is so so helpful thank you for teaching us :)
Thank you for an excellent teaching experience.
You’re very welcome!
Thank you so much for this😊
Very helpful thanks
Thank you for all you do.
You are so welcome
really enjoyesd the the video.
This is brilliant teaching in such a simple way, Thank you sir.
Thank you!
Thank you so mach...🎉🎉🎉
Super helpful and presented so well.
Good job👍🏻
I subscribe immediately because everything I want to know is in your tutorial. I know longer have ask someone to show me how to do something
Hi, excellent teaching and very useful. Could you please give me the link to lesson 2?
I enjoyed this lesson. It was a great refresher, is there another lesson in the series?
Thank you
Do you have a view on adding files and folders in sheets.
Also, is there info on resizing a cell say in the middle of a sheet.
GREAT GREAT VIDEO!!!
Glad you enjoyed it!
Hello Sir, Great class I have tried so many instructors and you are the only one that breaks it down. I can't find part two could I get some assistance please?
Thank you!
You're welcome!
Wow wowwwww
I came here because I saw for the 1st time another video of your Google Sheets tutorials.
This was very informative. Do you have a Part 2 available?
Thank youuu
When I clicked on Print, the sheet became tiny. I watched on iPad and followed steps on computer. That was a great way to learn.
Is it possible to have an unnumbered row or rows at the top of a database? If I am inputting one row per students signed up for my course, the header row is always row 1 and that means when I look at the numbers to the left of column, A and scroll down to the last student I entered, that number is one greater than the number of students I have enrolled and I have to remember to subtract 1 from the total to get my total enrollment number. I am hoping there is a way for the number 1 to the left of column A to match the first student I enter.
First of all, thanks teach for helping me figure out babies first spreadsheet. I really appreciate it.
Secondly I'd like to ask if there's a consolidated resource for shortcuts like the one you showed at 5:58 with sheets.new ? How do you learn this kinda thing other than hearing it from a friend? Is there a name for it?
i didnt know i could move the apps around in the app launcher! TY!
Perfect pacing. Some tutorials are so rushed, I am constantly stopping and repeating. Your articulation is great and every word understandable. When I click print, the sheet data shrinks much smaller. Any ideas?
First 😀🎉
Thank you, I learned so much. Just a couple of issues. My google sheet shows the pound sign on the ribbon although I bought the computer in Australia and live in Australia. Yes I can change the sign on the sheet but not on the ribbon. Also when I right click on a row or column nothing happens. I have to go and click on Insert. Not a major issue, just for your information.
Regards
Fulvio Bagliani
I have a difficult time seeing the same view when I use my iPad Pro. It’s consistent with what I see on a laptop, but I do think there are different mobile views & not sure how to resolve?
Can you plz make the videos on particular google sheet functions
This video chang'd my life. thank you for making this masterpice. my wife leving me and traking my kids no longer bother me. skibi ohio
How do you add the numbers to the rows that count up?
Dear Sir,
I need your help in google sheet, how to insert blank row formula/automatically between data in google sheet.
For Example :
I have my working data on google sheet with 7 columns a thousand rows and in my 4th column has a city's name and I want to insert a blank row after the city's name change in my google sheet.
Excel has that option to select the whole sheet and insert a blank row but I am a new user of google sheet and it's difficult for me for my work.
I hope you help me for this matter
Please do you know about TALLY ERP??
I will like you ro make video about it sir
hi jamie, iam trying to follow the lecture but cant find the link to download your first data creating link? any help
My teacher at school had the entire high school class watch this video for computer applications.
👍