Google Sheets - Full Course

Learn how to use Google Sheets to create spreadsheets and work with data.

⭐️ 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

--

[leohraneliquis]

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

[jitinkumar]

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

[Sniprr]

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

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

[bennyblubman]

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

[siddheshdaphane]

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.

[robmac]

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

[AbhijeetKumar-pktg]

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

[thanhvanle]

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

[Theholly.]

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

[Lyesand]

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.

[vishwanathpratapsinghratho]

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.

[fluffyguy]

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.

[zenmonke]

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.

[JiingLiing]

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

[Maddy]

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

[jitendrashelar]

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

[hakimakbarzada]

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

[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!

[australiastories]

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.