Google Sheets - Full Course

Подписаться 10 млн

Просмотров 1,7 млн

50% 1

Learn how to use Google Sheets to create spreadsheets and work with data.
💻 Download course files: drive.google.com/drive/folder...
✏️ Course created by Barton Poulson from datalab.cc.
🔗 Check out the datalab.cc RU-vid channel: / datalabcc
🔗 Watch more free data science courses at datalab.cc/
⭐️ Course Contents ⭐️
(Time codes coming soon.)
⌨️ Welcome
⌨️ Pictures first
⌨️ Anatomy of a spreadsheet
⌨️ Data types
⌨️ Formatting cells
⌨️ Tidy data
⌨️ Sharing files
⌨️ Sharing folders
⌨️ Entering data
⌨️ Importing data
⌨️ Copying & pasting data
⌨️ Notes
⌨️ Comments
⌨️ Chat
⌨️ Selecting & moving data
⌨️ Sorting data
⌨️ Filtering data
⌨️ Filter views
⌨️ Publishing files
⌨️ Version history
⌨️ REPT charts
⌨️ Bar charts with table data
⌨️ Bar charts with raw data
⌨️ Grouped bar charts
⌨️ Bar charts with highlighting
⌨️ Pie charts
⌨️ Histograms
⌨️ Line charts
⌨️ Timelines
⌨️ Sparklines
⌨️ Scatterplots
⌨️ Scatterplots with highlighting
⌨️ Automatic charts with Explore
⌨️ Publishing charts
⌨️ Cell references
⌨️ Counts, sums, & means
⌨️ Dates & times
⌨️ Selecting text
⌨️ Combining text & data
⌨️ Conditional formatting
⌨️ Next steps
🎉 Thanks to our Champion and Sponsor supporters:
👾 Wong Voon jinq
👾 hexploitation
👾 Katia Moran
👾 BlckPhantom
👾 Nick Raker
👾 Otis Morgan
👾 DeezMaster
👾 AppWrite
--
Learn to code for free and get a developer job: www.freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news

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

15 июн 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 422

@leohraneliquis4328 2 года назад

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

@manedwolf369 2 года назад

THANK YOU

@iconworld658 2 года назад

Thank you ♥️

@deeptimittal05 2 года назад

Thank you 💕💕

@ANAS577 2 года назад

THANK YOU!!!

@uttamsingh6705 2 года назад

Lol = lots of love ♥️

@jitinkumar7742 2 года назад

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 ❤❤❤❤

@danielniels22 2 года назад

okaay i will leave a trace here for a reminder 😂😅

@jitinkumar7742 2 года назад

@@danielniels22 😅 Thanx I guess!

@keshav.mishra 2 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FLJd1seO5U.html

@RohitSingh-yo2yl 2 года назад

same man

@aravindsingh08 2 года назад

That will never happen brother. Donation cannot be scheduled. It's always spontaneous.

@Snip3rr 2 года назад

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 ! 🙏☺️🤯

@SoundSpeeding 2 года назад

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.

@gasparcalix2095 Год назад

AHAHAHAHA!

@sarahcandatu5517 Год назад

I feel you :)

@studysleeporchill Год назад

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..

@breeservantt 11 месяцев назад

I'm with you, I'm so grateful though... 🤣🤣🤣

@AgnetaBlaumanis Год назад

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.

@bennyblubman9476 2 года назад

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

@robmac3958 2 года назад

OUTSTANDING : clear, progressive, perfectly clear diction. One the best instructional videos on any subject I've seen. World class. Cannot believe this is free. 🙏

@Lyesand11 2 года назад

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.

@Theholly1. Год назад

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...

@siddheshdaphane2932 2 года назад

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.

@R1vetingChronicles 3 дня назад

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

@jitendrashelar4123 2 года назад

This is such a great session! Thank you very much sir. All I can say, God bless you all!

@australiastories8042 Год назад

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.

@stevenwilson5556 2 года назад

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.

@thanhvanle3024 10 месяцев назад

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 >

@147Maddy 2 года назад

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!!!👍🏼😊

@hamzamehalli2825 2 года назад

i'm wondering if there is some projects where we can use all what we've learned here?

@riccardocosta1147 2 года назад

same here 2 months later!

@vishwanathpratapsinghratho5766 2 года назад

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.

@yesile 2 года назад

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.

@AbhijeetKumar-pk8tg 10 месяцев назад

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

@michalbotor Год назад

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!

@aiforagents 2 года назад

Best Google Sheets training on RU-vid hands down!

@hakimakbarzada Год назад

Thank you for your efforts and the work you do without charging us. Sending you peace and love from Afghanistan.

@zenmonke 2 года назад

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.

@freecodecamp 2 года назад

Just added to the description. Time codes coming soon.

@brighteyes6585 2 года назад

You teach very well, I feel like you meet people where they are.

@fluffyguy124 2 года назад

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.

@saketmodi6280 2 года назад

This is so awesome! Had no idea about the potential of GSheets

@financialchimes4546 Год назад

Please ask this lecturer to come back for other courses as well. He's just so great!

@learningstuff5679 2 года назад

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!

@heartstruckrecords Год назад

exactly 1 year ago this awesome course was uploaded, many thanks! I know it has helped me learn a lot of valuable information!

@shockinglight7913 2 года назад

Its literally brilliant!!! Not only is this free but is super helpful. Well done sir!

@AshishOmGourav 2 года назад

This is an extremely valuable resource for any beginner Data Professional!

@theresa7367 Год назад

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.

@learningstuff5679 2 года назад

Start to finish this course was awesome!

@petrdub7232 2 года назад

Thank you for this excellent course, I learned a lot!

@xavi2803 2 года назад

Y’all deserve a Nobel prize or sumn.. honestly

@dioa4934 Год назад

Unbelievably helpful. I really want to thank this man

@bilisumaambisa486 2 года назад

Love and respect from Ethiopia!!!

@LubulaAfritech 2 года назад

I am studing data analyst I have been looking for this . Thank you guys

@cf2813 Год назад

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.

@b.conscious 9 месяцев назад

is there any way to get a certificate for this course? some sort of knowledge assessment for completeing?

@akashj.8262 2 года назад

Watched full. Thanks to you all for the help!!

@alexmwaniki1069 2 года назад

Thank for the 3hr lesson. It was ver informative especially on visualization

@TheB1nary 2 года назад

This is great! I've just started studying data analytics and have been looking for a course covering this!!!

@meghasharma5463 2 года назад

Can you just tell what are important topics or courses to become a data analyst?

@DeepakKumar-pg7vx 2 года назад

@Megha Dutta Most important and powerful tools for data analyst is excel and power bi

@olumidesamuel7211 2 года назад

Can you please tell me how you were able to work on the file because I wasn't grant access to edit the file.

@meghasharma5463 2 года назад

@@DeepakKumar-pg7vx tysm

@TheB1nary 2 года назад

@@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.

@keredgilmore Год назад

OMG! I am sooo happy I came upon this video through my RU-vid 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!

@DubYuhGChoppa Год назад

As a guy who loves Google Sheets, I feel compelled to watch this whole video in full now

@TheGrudge80 2 года назад

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!

@okeefjohnson6237 2 года назад

it seems to be an update added , was just about to make that comment

@6em974 Год назад

This is an absolutely amazing video. Thank you so much!

@dima170343 5 месяцев назад

Really helpful course, personally for me it takes only one day to get into Google Sheets. Thank you very much!

@realvirtualdemand4222 Год назад

this is a great way for me to learn the basics. Always start with the basics

@diegomalaquias4053 2 года назад

Thanks, I was searching for something like this and then I received this notification.

@TheLudema 2 года назад

01:04:37 shift+space and shift+arrows , to Select Rows, Cells, Columns

@sk-ov2hl 2 месяца назад

Thanks to share this it's very helpful. I watching this video from the starting to the end within one take.❤

@gabriellecomanda8174 2 года назад

Came here to learn more about Google Sheets, didn't expect to learn about Ruth St. Denis! Lol great video, thank you so much for making this!

@natashasamuel9346 2 года назад

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

@kimbowayasin6940 2 года назад

Thanks Free Code for this wonderful course

@raiden542 2 года назад

I wanted to use Google sheets but didn't know how. Thanks for uploading this tutorial.

@meghasharma5463 2 года назад

Where it is being used? I mean where are these sheets used?

@dg9158 2 года назад

Omg thank you ! Just what I Needed ! 🙏🏻 You are a blessing of a youtuber

@meghasharma5463 2 года назад

Can you please tell me...what are the things require to be a data analyst when you have no programming experience and skills?

@dzikijohnny 2 года назад

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.

@youssefmohamed3809 2 года назад

Couldn't you use a substring function instead of the right and left + trim for the splitting of the first last names?

@Katiapunchh 4 месяца назад

❤❤❤❤❤ This video is wonderful, so easy to follow and so clear. Congratulations 🎉and god bless you a tons❤

@hovno964 Год назад

really helpful course. Very appreciate the effort put in it and thank you very much

@paolopapandrea Год назад

hey guys, your videos are amazing! I learned a lot watching your Python and JS tutorials. Are you planning to publish anything related to Google App Script as well? that would be super helpful!

@gior987 Год назад

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

@michalbotor Год назад

sparklines blew my mind. what a cool feature!

@aykunsozudogru5175 Год назад

This video is totally wholesome. Thank you!

@unizfrhn2803 2 года назад

I'm in tears. Why this channel so kind?

@katmusswoodwind 2 года назад

this is superb thank you - helping me prepare for a job which uses excel a lot! Wish me luck...

@katmusswoodwind 2 года назад

...I GOT THE JOB!! thanks for helping me prepare for the interview!!

@katmusswoodwind 2 года назад

...lol apparently my excel chops were way better than they were expecting at interview haha!

@vishnumarichi3493 2 года назад

His voice is really something else!!!

@amirghassabi5088 Год назад

That was amazing!!!!! Very usefulllllll video for students who want to start their career by using GSH. Thanks for ur effort

@thedebapriyakar 2 года назад

ABSOLUTELY EXCELLENT!!!!!!

@d_b4208 2 года назад

im starting this course this weekend!

@Value_Pilgrim 2 года назад

Is there a video on advanced features of Googlesheets? Like how to write macros? Financial modeling on sheets? Etc.

@shradhaingewar6168 2 года назад

I am gonna start and finish this by tomorrow 😍

@danielbrink9475 6 месяцев назад

Google Sheets is just so much simpler to pick up then Excel i have been bashing my head in with excel recently.

@JiingLiing Год назад

1:05:15 1:00:13 Chat 💬 1:02:53 Select all 1:04:19 ctrl + space

@markwanderley2029 Год назад

Thank you so much! Cheers from Brazil!

@user3820 2 года назад

I found an error. At 2:32:24 you are repeating the Data Types section. The Dates and Times section is skipped.

@chichagg 2 года назад

Dhanyawad datalab & freecodecamp🙏

@MSHL007 2 года назад

great tutorial Thank you!

@zoey_stout2021 2 года назад

I actually learned about Google sheets in my budget and computer science class

@anysha1083 2 года назад

find, left, right, trim function 2:40:00 bookmark for self

@eldergod7675 2 года назад

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 ❤

@paperdolls28 2 года назад

thank you for this very informative tutorial. God bless you.

@arthurtheaardvark13 Год назад

Really enjoyed this video, thanks so much!

@brianmorrison9168 2 года назад

Is there a way I can change the highlight colour and line thickness to show the current cell. The current blue outline is proving quite hard for me to see. thanks !

@ASTechWave 2 года назад

Well explained ❤❤❤

@ieraj7428 Год назад

This is a tremendous content, thank you so much!

@newsshorts7972 Год назад

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

@tanaykashyap2459 2 года назад

My first coop paycheck going to them!

@microsoftsarker 2 года назад

Thanks brother, it worked!!

@anajovanovic6645 2 года назад

Thanks! It was pleasure to watching, I learned a lot. I have question: How to move Facebook comments to spreadsheet?

@drgali7230 Год назад

Thank you for your time and efforts ❤️

@ulisesmatheus8439 2 года назад

Thanks, great xplanation!!!!!!!!!

@mouhammadali9605 2 года назад

Help! I am trying to use conditional formatting to highlight a cell that contains certain value in two different sheets . I am struggling with the formula, could someone please advise?