Timestamps 0:00:00 Welcome 0:05:10 Pictures First 0:10:40 Anatomy of a Spreadsheet 0:15:48 Data types 0:23:02 Formatting Cells 0:30:00 Tidy Data 0:36:41 Sharing Files 0:38:39 Sharing Folders 0:42:04 Entering Data 0:46:34 Importing Data 0:49:31 Copy & Pasting Data 0:54:10 Notes 0:56:07 Comments 0:59:32 Chat 1:01:52 Selecting & Moving Data 1:06:19 Sorting Data 1:08:44 Filtering Data 1:11:06 Filtering View 1:14:13 Publishing Files 1:16:45 Version History 1:18:56 Rept Charts 1:21:35 Bar Charts with Table Data 1:24:54 Bar Charts with Raw Data 1:26:41 Grouped Bar Charts 1:33:16 Bar Charts with Highlighting 1:35:35 Pie Charts 1:43:34 Histograms 1:48:41 Line Charts 1:55:55 Timelines 1:59:21 Sparklines 2:06:48 Scatterplots 2:10:02 Scatterplots with Highlights 2:12:15 Automatic Charts with Explore 2:15:33 Publishing Charts 2:20:55 Cell References 2:27:43 Counts, Sums, & Means null: Dates & Time 2:39:27 Selecting Text 2:45:54 Combining Text & Data 2:52:42 Conditional Formatting 2:56:58 Next Steps
I swear when I start earning well, I will definitely donate something every year to Free Code Camp even if I don't require coding lessons in future. This channel is just ❤❤❤❤
We're just blessed to have these educators that share their knowledge around the world for free. Outside youtube, most of the course or classes are just out of my budget but here they are, providing us the essentials we need to start!! Not all heroes wear capes, indeed. Thank you so much.
Please stop with these outrageously good and free tutorials. I need some free time after work and all I find is this, and I can't ignore it because the subjects are soo good. There are no words to describe the quality of your content and the value you bring to the community ! Thank you so, so much ! 🙏☺️🤯
thanks for letting us know, I am wondering if I want to waste 3 hrs listening, an not gain nothing. with 7 Mill subs they must be doing something good..
OUTSTANDING : clear, progressive, perfectly clear diction. One the best instructional videos on any subject I've seen. World class. Cannot believe this is free. 🙏
You don't know how much I need this! The tuition fee for courses like this is insane in Vietnam, you can make a fortune by teaching people to use Excel and Word. You are true heroes! You have earned a solid subscriber >
First of all. Thank you for making environment so friendly and taking your responsibility seriously and completing the job gracefully! You deserve so much respect. He does what he says he is going to do and his ethics are of the highest quality...
13:08 use of freezing in sheet 27:21 snap to fit width 33:00 avoid merging cells, it may make things complex 1:03:36 ctrl+space = entire column 1:04:43 shipht+space = entire row 1:07:27 ascendind,descending 1:09:55 filter 1:21:00-2:20:00 charts (pending) 2:25:37 imp phormula 2:26:38 imp phormula 02:32:00 2:39:20 is repeated
Thank you so much for producing this. It's so hard finding free resources for these types of programs, and I'm so grateful that you take the time to make these videos.
Really grateful for this awesome free course! :) I did notice Data types was repeated at 2:32:12 where it should be been Dates & Times for the Using Formulas section.
I thought I knew everything there was to know about Google sheets... Thank you for an awesome training video... I watched it at 2 x speed and learnt 8 things that I wish I had known earlier!
OMG! I am sooo happy I came upon this video through my TH-cam search! I’m just starting a Dropshipping business and have never used a spreadsheet in my life. I need a good solid “quick” learn as I’m learning other aspects of my new biz venture. Can’t thank you enough as I begin to watch and learn!
Absolute masterpiece‼️Crystal clear and fantastic way of presentation! Got an idea of all the different possiblities what Sheets can accomplish! Please keep up the good work!!!👍🏼😊
Actually it is possible to format a single data point with different color or change the general appearance, no need to create a grouped column chart as stated in (1:35:00). I don't know which version of Google Sheets has been used for the tutorial, but it is possible right now (Nov 2021) :-) Thanks for this great tutorial, I really learned a lot!
actually thought Google Spreadsheets was complicated but this course let me see things in a new light and perspective, really showing that all it takes is the will to sit down and start learning
I already knew a lot of this, but man, sparklines were something I never knew about, and now I need to add them everywhere I can; I love visualizing data at a glance. Control + Tilde to toggle formulas is fun neat trick too. Thanks.
i'm only 30min in, but wow!, this course is so far a masterclass on how to structure your course to maximize the learning output and make it enjoyable too. fantastic!
thank you.... "because June was so good we wanted it twice" cracked me up 🤣🤣🤣. I appreciate the struggle of lecturers to create scenarios to illustrate something.
This course really needs an outline. I am no stranger to google sheets, so I dont know if this is an introduction that I dont need, or are there topics I am interested in.
Dude your voice is the most pleasant ever, have I heard you reading audiobooks anywhere? I could listen to it for hours EDIT: reminds me of The Stanley Parabol narrator's voice
Funny how you said University Professor like that actually mattered LOL...I would want a business person or someone who actually used the program or another spreadsheet for years...Universities are obsolete...you helped make them that way.
@@meghasharma5463 Hey there! I would start with a good foundational course - things like Google Professional Certificate in Data Analytics (Coursera) or IBMs (older but good) course on the same. Look to learning the fundamentals of sheets, SQL and cloud computing. And don't forget Tableau. Hope that helps.
Thank you...slower, just my pace. Good visuals to follow along, really able to see and hear with clarity as you maneuver. Very useful for gertting familiar with the basics and functionality of the Spreadsheet.
Not sure if there has been an update since but an easier way to change the color for a specific line of a bar chart would be to go to: chart editor>customize>series>format data point Then just choose your data point and change the color
I've thought about inputting my alphabetized list of my movies into Excel. I can also add the year, the duration, the director, and some of the big actors in the film.
Now (2023 version) individual points in scatterplot CAN be customized without making a new column. Chart editor --> Series --> Click the point you want to change on the chart --> "Format data point" comes up. Color, Shape, Size etc. can be customized there for the selected point.
Timestamps
0:00:00 Welcome
0:05:10 Pictures First
0:10:40 Anatomy of a Spreadsheet
0:15:48 Data types
0:23:02 Formatting Cells
0:30:00 Tidy Data
0:36:41 Sharing Files
0:38:39 Sharing Folders
0:42:04 Entering Data
0:46:34 Importing Data
0:49:31 Copy & Pasting Data
0:54:10 Notes
0:56:07 Comments
0:59:32 Chat
1:01:52 Selecting & Moving Data
1:06:19 Sorting Data
1:08:44 Filtering Data
1:11:06 Filtering View
1:14:13 Publishing Files
1:16:45 Version History
1:18:56 Rept Charts
1:21:35 Bar Charts with Table Data
1:24:54 Bar Charts with Raw Data
1:26:41 Grouped Bar Charts
1:33:16 Bar Charts with Highlighting
1:35:35 Pie Charts
1:43:34 Histograms
1:48:41 Line Charts
1:55:55 Timelines
1:59:21 Sparklines
2:06:48 Scatterplots
2:10:02 Scatterplots with Highlights
2:12:15 Automatic Charts with Explore
2:15:33 Publishing Charts
2:20:55 Cell References
2:27:43 Counts, Sums, & Means
null: Dates & Time
2:39:27 Selecting Text
2:45:54 Combining Text & Data
2:52:42 Conditional Formatting
2:56:58 Next Steps
THANK YOU
Thank you ♥️
Thank you 💕💕
THANK YOU!!!
Lol = lots of love ♥️
I swear when I start earning well, I will definitely donate something every year to Free Code Camp even if I don't require coding lessons in future. This channel is just ❤❤❤❤
okaay i will leave a trace here for a reminder 😂😅
@@danielniels22 😅
Thanx I guess!
th-cam.com/video/-FLJd1seO5U/w-d-xo.html
same man
That will never happen brother. Donation cannot be scheduled. It's always spontaneous.
After getting a job I will definitely donate. This is how students need to learn. Free of cost and from expert. Thank you for your every course.
We're just blessed to have these educators that share their knowledge around the world for free. Outside youtube, most of the course or classes are just out of my budget but here they are, providing us the essentials we need to start!! Not all heroes wear capes, indeed. Thank you so much.
Please stop with these outrageously good and free tutorials. I need some free time after work and all I find is this, and I can't ignore it because the subjects are soo good.
There are no words to describe the quality of your content and the value you bring to the community ! Thank you so, so much ! 🙏☺️🤯
I feel the same! I can't even find time to watch movies or tv shows these days, because there are so many good tutorials instead.
AHAHAHAHA!
I feel you :)
thanks for letting us know, I am wondering if I want to waste 3 hrs listening, an not gain nothing. with 7 Mill subs they must be doing something good..
I'm with you, I'm so grateful though... 🤣🤣🤣
OUTSTANDING : clear, progressive, perfectly clear diction. One the best instructional videos on any subject I've seen. World class. Cannot believe this is free. 🙏
Haven't even hit 10 minutes and he has shown the importance of graphs and will change how I use google sheets. Gonna be a great video
You don't know how much I need this! The tuition fee for courses like this is insane in Vietnam, you can make a fortune by teaching people to use Excel and Word. You are true heroes! You have earned a solid subscriber >
First of all. Thank you for making environment so friendly and taking your responsibility seriously and completing the job gracefully! You deserve so much respect. He does what he says he is going to do and his ethics are of the highest quality...
13:08 use of freezing in sheet
27:21 snap to fit width
33:00 avoid merging cells, it may make things complex
1:03:36 ctrl+space = entire column
1:04:43 shipht+space = entire row
1:07:27 ascendind,descending
1:09:55 filter
1:21:00-2:20:00 charts (pending)
2:25:37 imp phormula
2:26:38 imp phormula
02:32:00 2:39:20 is repeated
Thank you so much for producing this. It's so hard finding free resources for these types of programs, and I'm so grateful that you take the time to make these videos.
13:06 Freeze row 🧊
14:20 Sort sheet A-Z
15:00 Sum
17:12 %
17:33 Decrease decimal places
18:15 Accounting, Financial, Currency
20:30 Link
20:47 Stock price
21:33 Image
23:45 Font ✏️
27:53 Same size row
29:00 Wrap to 2 lines
40:19 Share
43:59 Data propogate 傳播
47:11 Import sheets to sheets
49:46 Excel > Google
51:32 Copy
53:45 Paste transpose
55:56 Insert note 🗒️
58:40 Insert comment
Really grateful for this awesome free course! :)
I did notice Data types was repeated at 2:32:12 where it should be been Dates & Times for the Using Formulas section.
Thank you for your efforts and the work you do without charging us. Sending you peace and love from Afghanistan.
You have set a high bar for others to follow. Outstanding presentation and clarity - like a good book, hard to stop watching.
Thank you so much.
Best Google Sheets training on TH-cam hands down!
The entire point of data analysis is to simplify things in a way that helps you reach your practical goals, you want to bring it into focus.
This is such a great session! Thank you very much sir. All I can say, God bless you all!
Thank you so much! Cheers from Brazil!
01:04:37 shift+space and shift+arrows , to Select Rows, Cells, Columns
I thought I knew everything there was to know about Google sheets... Thank you for an awesome training video... I watched it at 2 x speed and learnt 8 things that I wish I had known earlier!
OMG! I am sooo happy I came upon this video through my TH-cam search! I’m just starting a Dropshipping business and have never used a spreadsheet in my life. I need a good solid “quick” learn as I’m learning other aspects of my new biz venture. Can’t thank you enough as I begin to watch and learn!
Absolute masterpiece‼️Crystal clear and fantastic way of presentation! Got an idea of all the different possiblities what Sheets can accomplish! Please keep up the good work!!!👍🏼😊
i'm wondering if there is some projects where we can use all what we've learned here?
same here 2 months later!
Actually it is possible to format a single data point with different color or change the general appearance, no need to create a grouped column chart as stated in (1:35:00).
I don't know which version of Google Sheets has been used for the tutorial, but it is possible right now (Nov 2021) :-)
Thanks for this great tutorial, I really learned a lot!
it seems to be an update added , was just about to make that comment
Thanks for this course!! I will be doing this today. I have used this for my tutoring many times and it is a great idea to level up my skill set.
1:05:15
1:00:13 Chat 💬
1:02:53 Select all
1:04:19 ctrl + space
exactly 1 year ago this awesome course was uploaded, many thanks! I know it has helped me learn a lot of valuable information!
Y’all deserve a Nobel prize or sumn.. honestly
Its literally brilliant!!! Not only is this free but is super helpful. Well done sir!
actually thought Google Spreadsheets was complicated but this course let me see things in a new light and perspective, really showing that all it takes is the will to sit down and start learning
I already knew a lot of this, but man, sparklines were something I never knew about, and now I need to add them everywhere I can; I love visualizing data at a glance. Control + Tilde to toggle formulas is fun neat trick too. Thanks.
i'm only 30min in, but wow!, this course is so far a masterclass on how to structure your course to maximize the learning output and make it enjoyable too. fantastic!
I found so many basic information I needed here. wish I had found this channel a few years ago. thank you so much!
thank you.... "because June was so good we wanted it twice" cracked me up 🤣🤣🤣. I appreciate the struggle of lecturers to create scenarios to illustrate something.
Awesome presentation. I’ve been using sheets for a couple of years - and I still learnt something invaluable in every chapter! Thank you 🙏
This course really needs an outline.
I am no stranger to google sheets, so I dont know if this is an introduction that I dont need, or are there topics I am interested in.
Just added to the description. Time codes coming soon.
Really helpful course, personally for me it takes only one day to get into Google Sheets. Thank you very much!
I am studing data analyst I have been looking for this . Thank you guys
Thanks!
Thanks for donating
This is an extremely valuable resource for any beginner Data Professional!
Thanks to share this it's very helpful. I watching this video from the starting to the end within one take.❤
I'm in tears. Why this channel so kind?
Dude your voice is the most pleasant ever, have I heard you reading audiobooks anywhere? I could listen to it for hours
EDIT: reminds me of The Stanley Parabol narrator's voice
Thank you so much for this course. Eye opening. Just wonderful wonderful wonderful.
❤❤❤❤❤ This video is wonderful, so easy to follow and so clear. Congratulations 🎉and god bless you a tons❤
You teach very well, I feel like you meet people where they are.
Funny how you said University Professor like that actually mattered LOL...I would want a business person or someone who actually used the program or another spreadsheet for years...Universities are obsolete...you helped make them that way.
find, left, right, trim function 2:40:00
bookmark for self
That was amazing!!!!! Very usefulllllll video for students who want to start their career by using GSH. Thanks for ur effort
Unbelievably helpful. I really want to thank this man
This is great! I've just started studying data analytics and have been looking for a course covering this!!!
Can you just tell what are important topics or courses to become a data analyst?
@Megha Dutta Most important and powerful tools for data analyst is excel and power bi
Can you please tell me how you were able to work on the file because I wasn't grant access to edit the file.
@@DeepakKumar-pg7vx tysm
@@meghasharma5463 Hey there! I would start with a good foundational course - things like Google Professional Certificate in Data Analytics (Coursera) or IBMs (older but good) course on the same. Look to learning the fundamentals of sheets, SQL and cloud computing. And don't forget Tableau. Hope that helps.
Omg thank you ! Just what I Needed ! 🙏🏻 You are a blessing of a youtuber
Can you please tell me...what are the things require to be a data analyst when you have no programming experience and skills?
this is superb thank you - helping me prepare for a job which uses excel a lot! Wish me luck...
...I GOT THE JOB!! thanks for helping me prepare for the interview!!
...lol apparently my excel chops were way better than they were expecting at interview haha!
Start to finish this course was awesome!
Please ask this lecturer to come back for other courses as well. He's just so great!
sparklines blew my mind. what a cool feature!
Thank you...slower, just my pace. Good visuals to follow along, really able to see and hear with clarity as you maneuver. Very useful for gertting familiar with the basics and functionality of the Spreadsheet.
As a guy who loves Google Sheets, I feel compelled to watch this whole video in full now
This is so awesome!
Had no idea about the potential of GSheets
Thank you for the course. Really appreciate your knowledge sharing.
Great video, to understand the basics of Google Sheet ❤
One of the great videos for a complete journey
Thank for the 3hr lesson. It was ver informative especially on visualization
though still on it your delivery style is fantastic!!!!!
this is a great way for me to learn the basics. Always start with the basics
Thank you for providing us high quality material ❤
Thanks, I was searching for something like this and then I received this notification.
This video is totally wholesome. Thank you!
thank you for this very informative tutorial. God bless you.
Thank you so much you people will go to the highest level in heaven i swear i will donate monthly when i will start make money i love you so much ❤
Watched full. Thanks to you all for the help!!
Google Sheets is just so much simpler to pick up then Excel i have been bashing my head in with excel recently.
is there any way to get a certificate for this course? some sort of knowledge assessment for completeing?
I wanted to use Google sheets but didn't know how. Thanks for uploading this tutorial.
Where it is being used?
I mean where are these sheets used?
I actually learned about Google sheets in my budget and computer science class
Great class.
Keep up the good work.
I have nor been to class in a while.
Great class. Keep up the good work.
Thank You,
Natasha Samuel
His voice is really something else!!!
Family of 4 million now !!!!!!!!!!!!!!!!!!!!!!!!!!!!! yayyyyy
Dhanyawad datalab & freecodecamp🙏
im starting this course this weekend!
感謝製作此課程
Watched and I learned a lot. Thank you.
this is a gold mine, thank you
Thank you so much! Just commenting for the algorithm
Not sure if there has been an update since but an easier way to change the color for a specific line of a bar chart would be to go to:
chart editor>customize>series>format data point
Then just choose your data point and change the color
Is there a video on advanced features of Googlesheets? Like how to write macros? Financial modeling on sheets? Etc.
I found an error. At 2:32:24 you are repeating the Data Types section. The Dates and Times section is skipped.
Thanks Free Code for this wonderful course
Thank you it is very useful for beginning data analysts
I am gonna start and finish this by tomorrow 😍
I've thought about inputting my alphabetized list of my movies into Excel. I can also add the year, the duration, the director, and some of the big actors in the film.
I watched it completely in one go
2:32:13 Date & Time section was not included. After the Count, Sum & Mean section, the Data Type section was repeated.
Thank you for your time and efforts ❤️
This is so great a channel 😲.. woallah!!!
Now (2023 version) individual points in scatterplot CAN be customized without making a new column. Chart editor --> Series --> Click the point you want to change on the chart --> "Format data point" comes up. Color, Shape, Size etc. can be customized there for the selected point.
awesome! thanks
Really enjoyed this video, thanks so much!
Thank you so much! That’s really helpful. 🎉
Thank you for this excellent course, I learned a lot!
The Joy of Spreadsheets