Learn how to use Google Sheets to create spreadsheets and work with data.
๐ป Download course files:
โ๏ธ Course created by Barton Poulson from datalab.cc.
๐ Check out the datalab.cc YouTube channel:
๐ Watch more free data science courses at
โญ๏ธ 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:
Read hundreds of articles on programming:
And subscribe for new videos on technology every day:
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 โคโคโคโค
@Jos Rey p
i
could do xl
I’m in GM RN h
Same here
Nothing else to hide
@Daniel Simamora to late already copied and sent
This is great! I’ve just started studying data analytics and have been looking for a course covering this!!!
@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.
@Deepak Kumar tysm
@Megha Sharma 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.
@Paul Munro tysm
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.
I’m sure Google Sheets offers almost all the features Excel has to offer for example pivot tables, pi graphs, all the various charts, V-lookups, H-lookups. But my question is can you do macros in Sheets?
You could use google apps script to optimize google sheets automation.
This is such a great session! Thank you very much sir. All I can say, God bless you all!
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.. a life saver
Thank you so much
Youโre a star
thanks bro
Thank you!!
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 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.
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.
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.
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!
Thank you for this excellent course, I learned a lot!
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
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.
OUTSTANDING : clear, progressive, perfectly clear diction. One the best instructional videos on any subject I’ve seen. World class. Cannot believe this is free. ๐
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.
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!
Hi,
Thank you for the video. Would you please assist me here. I have a situation where I wanted to subtract the respective row value from grand total in a pivot by using calculated field. Is it possible?
Unbelievably helpful. I really want to thank this man