Google Sheets Full Course Tutorial (2+ Hours)
Vložit
- čas přidán 5. 08. 2024
- Google Sheets Full Course Tutorial (2+ Hours)
2023 Update
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: learnitanytime.com/p/exercise...
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:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
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.
Exercise Files: learnitanytime.com/p/exercise-files-google-sheets-full-course-tutorial-2023
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!
Thank you for the kind words!
this is fantastic!! I'd watched to the end and this video is really easy to understand. Thumbs up 5/5!
👍👍👍👍👍
This is so underrated, love it!
Thanks for making this available!
Our pleasure!
Grazie , mi ha aiutato molto il tuo corso!
Prego!
Thanks Elissa for delivering such an insightful session on Google Spreadsheets!
Glad you enjoyed it!
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!
I think bx the voice is low and a bit fast. Not even a half second to process.
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.
We are glad you are having a great time learning!
great tut! Thanks for providing this.
You are welcome!
Really appreciate this course!! Thank you
You are welcome!
Thanks for this it was you explain very well making it was to understand
You're very welcome!
Thank you for providing us with such an awesome tutorial.
You are very welcome!
I wanna know how you highlight commans and stuff
Thank you so much
You're most welcome
Really awesome tutorial....Thank you so much...
You are most welcome
Great videos, Thanks. But at 1:45:45 you said "greater than" (>) when the symbol on the sheets is "smaller than" (
Good point!
thanks soooo much
You are welcome!
Cant wait to watch this, I been scouring the internet for something I am not sure exists. :fingers_crossed:
We hope you enjoy it!
👍 Thanks! 😍
Hope you'll do a comparable video(s) for Google Forms. ❤
We do! czcams.com/video/NTGh0fZjNkU/video.htmlsi=n8q-z93Wt2xX5r9Q
@@LearnitTraining 👍Thanks!
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!
Sadly, the 'Explore' tool was deprecated as of Jan 30, 2024.
Yes unfortunately Google removed this great tool.
i want you to do the google slides as well ❤
Here you go! czcams.com/video/06_EGPM4VDo/video.html
Hi, please can you bring in Adobe After Effects Course from Beginner to Expert? If yes please do that.
Working on it!
@@LearnitTraining thanks 🙏
I don't have "Explore" option at the bottom right of google sheet. What can be done?
Unfortunately, Google got rid of that feature
EXCUSE ME - BUT HOW CAN I PRINT THE COLUMN AND ROW LABELS? yes i want to print the letters on top of the columns and the numbers down the rows.
Thank you for the video but I can't find the Explore button for some reason, simply do not have it. Do you have an idea why?
Unfortunately Google got rid of the explore shortly after we released the video!
@@LearnitTraining Got it! Thanks!
when I try to download the exercises it downloads them in excel and not google sheets. I don't have a subscription to excel so I can't paste it over
Hello Smario 15!
To open an Excel file in Google Sheets, you can follow these steps:
Go to your Google Drive account and click on the “New” button.
Select “File upload” and choose the Excel file you want to open.
Once the file is uploaded, right-click on it and select “Open with” from the context menu.
Choose “Google Sheets” from the submenu.
Tried to watch this 3 times , can’t get past the keyboard sounds and the use of the cursor finder to highlight items
Noted!
I didn't mind it
I don't have an Explore button anywhere on my Google sheets, unless I have to unhide it first. Please help....
Hello Tik! Unfortunately that was a UI change from Google. You can still open it though with this keyboard shortcut: Ctrl + Alt + Shift + i
You can equally access the Explore tool on the menu under Tools.
Sir, ek Google sheet hai us me 4 salesman wise 4 sheet hai har salesman apne Naam Ki sheet me data daily update karke n dusre salesman ki sheet na dekh sake and all salesman sheet manager dekh ske Yeh manage google sheet me kese kare?
Hi, is knowledge your real name?
The drop down menus don't show when using Android tablet. You are only showing for using a laptop or PC
Noted!
🙏🙏
🙏🙏
This is beginner course or advanced?
It appears the Explore tool has been decommissioned? Anyone else experience the same difficulty?
Yes, unfortunately Google got rid of the explore tool
Explore tool is no longer in Sheets?
No, unfortunately they got rid of it. It quasi lives on in Gemini
I can't find the explore button and it also doesnt show up with the shortcut
Unfortunately Google removed the explore button
@@LearnitTraining Thank you!
i dont have the explore feature so i got lost at the charts
Yeah, unfortunately Google got rid of the explore button
hi can you help me on a project
You can get 1 on 1 consultatation at www.learnit.com
what is the cost?
This video is free to watch!
Has Google removed the Explore button? I cannot find it anywhere for the love of God
Yes, unfortunately Google has removed the explore button
2:11:32 old people watching this :0
We approach every video series as this is the first time the viewer is using the software. We try to make our videos friendly for everyone.
Just wondering, why use Microsoft Excel if you're doing a tutorial on Google Sheets? Just wondering if it's just preference or unintentional.
shawty clicking wayyy to hard on stuff
💯