Google Sheets Full Course Tutorial (2+ Hours)

Google Sheets Full Course Tutorial (2+ Hours)
2023 Update

Get Ad-Free Training by becoming a member today!

Who it's for: Anyone looking to gather, format, and interpret data in a spreadsheet.

What it is: Google Sheets is Google’s free, web-based spreadsheet application that mirrors the magic of Microsoft Excel, with some standout features and key differences as well.

What you'll learn: First, students will be shown how to navigate the app. Then, they’ll learn the basics like creating and sharing spreadsheets. Next, they’ll learn how to calculate data with functions and formulas, as well as how to filter and sort all their data. Finally, users will get some hands-on time with popular features like Pivot Tables, AutoFill, VLOOKUP, Macros, real-time collaboration, and more.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
Introduction 0:09
Accessing Google Sheets 0:52
Navigating in Cells and Menus 3:41
Keyboard Shortcuts 6:08
Editing Cell Contents 8:48
Templates 11:21
Using Explore 13:43
Opening and Saving Sheets 16:58
Using Google Drive with Google Sheets 19:38
Showing and Using the Formula Bar and Gridlines 22:11
Basic Formulas 24:10
Using Autofill to Copy Formulas 27:19
Using Autofill to Create Redundant Data 28:59
Simple Formulas 31:11
Formulas with Absolute References 34:27
Cut, Copy, and Paste 39:21
Inserting Rows and Columns 42:15
Wrapping Text, Rotating, and Aligning Cells 45:00
Cell Formatting 47:48
Hiding Rows and Columns 50:49
Freeze Panes and Full Screen View 54:47
Spell Check and Printing 56:54
Sharing and Emailing Sheets 1:00:07
Publishing to Web 1:02:53
Conclusion 1:04:46
Introduction 1:06:21
List, Format, and Sort 1:06:59
Multi-Column Sort 1:09:26
Filters 1:11:34
Conditional Filters and Filtered Views 1:14:31
Creating Charts 1:18:10
Editing Charts 1:21:01
Removing and Deleting Chart Data 1:24:17
Sparklines 1:26:42
Formatting with Alternating Row Colors 1:29:21
Pivot Tables 1:30:35
Pivot Charts 1:34:48
Named Ranges 1:37:28
IF Functions 1:42:18
Nested Functions 1:45:22
VLOOKUP 1:48:27
SUMIF and AVERAGEIF 1:51:56
SUMIFS 1:55:55
AVERAGEIFS 1:58:31
IFERROR 2:01:02
LEFT and RIGHT 2:03:25
CONCATENATE 2:06:01
Sharing Files 2:08:06
Real-Time Authoring 2:09:50
Google Sheets Add-Ons 2:11:49
Introduction to Google Apps Scripts 2:13:44
Conclusion 2:16:02

#googlesheets #googlesheetstutorial #googleworkspace #googleworkspacetutorial

(C) 2023 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.

[joseginogonzalezortiz]

This has been tremendous help! It made my view in google sheet as fun! I'm no longger intimidated! More power to your channel. Elissa, you're a gifted trainer and a gift to the community!

[chesscrater]

Thank you for making this video. I have officially fallen in love with this program at roughly 16:30 in this video. I have no idea why. People say that Excel Spreadsheets are easier to use, but I like the standardization that google has placed into this program. I also appreciate how recently this video was made. I should be able to use google sheets with greater ease after viewing this entire video. The problem is that it is a 2 hour long video, and my attention span does not allow for 2 hour videos typically. It will max out at 25 minutes probably. I'm going to have to look at the featured playlist next time. I can watch more videos that way. Thanks.

[AnasAlbadawi-fkrw]

This is so underrated, love it!
Thanks for making this available!

[AndresUparela]

It really went from beginner to advanced haha. I struggled a lot in the end, but it was a great learning experience.Thanks a lot!

[kaljak]

this is fantastic!! I'd watched to the end and this video is really easy to understand. Thumbs up 5/5!

[International-Love]

Thanks Elissa for delivering such an insightful session on Google Spreadsheets!

[nickarrigo]

great tut! Thanks for providing this.

[KarenGravatt]

Really appreciate this course!! Thank you

[koxovwy]

Grazie, mi ha aiutato molto il tuo corso!

[orlandomorales]

Great videos, Thanks. But at 1:45:45 you said "greater than" (>) when the symbol on the sheets is "smaller than" (<). I'm not good at this and it took me a while to understand what was going on.

[donahnyakundi]

Thanks for this it was you explain very well making it was to understand

[znetflooring]

Cant wait to watch this, I been scouring the internet for something I am not sure exists. :fingers_crossed:

[muhammadzubairkhan]

Really awesome tutorial....Thank you so much...

[arijitsen]

Thank you for providing us with such an awesome tutorial.

[anthonyarmstrong]

Tried to watch this 3 times, can’t get past the keyboard sounds and the use of the cursor finder to highlight items

[amiemadeit]

Would this be good for almost Junior in high school to learn sheets?

[vee]

How do I find the Explore button on a spreadsheet? Trip Data example. Thanks,

[jinanfathallah]

I wanna know how you highlight commans and stuff

[hdlchannel]

Hi, please can you bring in Adobe After Effects Course from Beginner to Expert? If yes please do that.

[andyvoloschin]

Hi Elissa! Thanks so much for this amazing Google Sheets Journey. However, I encountered a stumbling block: I couldn't locate the Explore button. Despite searching under Tools, it seems to have been relocated, as it wasn't there either. Do you happen to have an alternate access point you could share? Even the shortcut failed to work. What can I use as a replacement? Thank you!