Google Sheets Beginner Tutorial

Google Sheets Beginner Tutorial
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
#googlesheets #googlesheetstutorial #googleworkspace #googleworkspacetutorial
(C) 2023 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[@LearnitTraining]

Exercise Files: learnitanytime.com/p/exercise-files-google-sheets-beginner-tutorial-2023

[@user-bz3wi9tv7d]

I love the steps & teaching style. Thanks. Got what I wanted.

[@LearnitTraining]

You are welcome!

[@joseginogonzalezortiz9126]

These are absolutely top tier quality tutorials! You can even teach my dog how to do these google sheet, and he will learn :)

[@LearnitTraining]

Happy to hear that! Hope your dog can do some formulas in Sheets for you! haha

[@Emma24442]

Thank u learnit training for your endles efforts. I've learned so much from the Learnit Training channel. The insights and depth of knowledge shared here have been absolutely invaluable. Thank you so much for your consistent efforts in providing quality, informative content. I'm grateful and look forward to continuing my learning journey here.

[@LearnitTraining]

Thank you so much for the kind words! We are glad we were able to help you so much!

[@CoachShaunie]

Thanks! I'm familiar with Google Sheets, but I learned some other features from the training.

[@LearnitTraining]

Glad it was helpful!

[@user-wx5yt4hu2f]

This was very helpful, thanks!

[@LearnitTraining]

Glad it was helpful!

[@liakat26]

Couldn't watch ontime though I got notification. Watching Now. Thanks from my heart

[@LearnitTraining]

You are very welcome!

[@user-we5rf4ql8c]

Получил достойный процент из связки спасибо

[@LearnitTraining]

Пожалуйста

[@chroekmakara101]

I always watch your videos and learn a lot from you. Thanks for your sharing. Can I request all of your videos to post on my channel in Cambodia? Because I want to share your teachings with the people of my country.

[@LearnitTraining]

Hello Chroek Makara! Thank you for the offer but we must decline. It would be best to share the link to our channel!

[@thuthutheinaung8042]

Dear teacher , May I know how to circle to see specific area ?

[@zhanebria]

Hi! I noticed that as I was going through the tutorial the "Using Explore 13:43" section of the video is no longer accurate and I have found that Google has removed the Explore feature from G Suite whether it be docs, sheets, etc. Any recommendations for approaching the creation of charts and pivot tables? I look forward to learning more, thank you so much! Update: I found that Google Gemini has been updated and it will allow you to upload your Google Sheets files to visualize your data. I will give it a try and hopefully this will be of help.

[@LearnitTraining]

Thank you for the great update! Let us know how it goes with Gemini!

[@zhanebria]

@@LearnitTraining Tried it out with Gemini and didn't work out successfully (I'm also still trying to familiarize myself with Gemini so I could've possibly not created a correct prompt) BUT I did go over your Google Sheets Advanced tutorial and found another way to get a chart created by highlighting cells and going to the insert tab up top and going to charts. So thank you very much!

[@PaulCaleb-ii7qi]

Hey! Please can you make a full crash course on Corel draw?

[@LearnitTraining]

We will look into it!

[@user-tt9bj7ow3m]

I have to have Microsoft Excel on my computer in order to access the Exercise Files? Or is there a way for me to open the files on Google Sheets? They are all XLXS files I see.

[@LearnitTraining]

You can open the the Excel files in Google Sheets

[@user-tt9bj7ow3m]

@@LearnitTraining Can you tell me how? I have all the files downloaded, but it asks what program to open it in and I can't find an option to open it on a browser. It suggests Notepad, but I know that won't work.

[@user-tc7me5nm3c]

I have downloaded the exercises to my PC, but when I try to open them it does not open into Google Sheets but tries to open in excel or liberofficecalc. How do I access them into G-sheets?

[@LearnitTraining]

To open a file in Google Sheets, you need to: Head to Google Sheets home page. Click the Open file picker icon (folder icon at the top right). Hit the “Upload” tab and then either drag the file into the provided Drag a file here section or click the Select a file from your computer button and choose the file you wish to upload. Select the file then tap that Open button at the lower left. Once your file uploads, right-click it, point to “Open With” on the context menu, and then select “Google Sheets”.

[@rumyfarjana2232]

😊😂😊

[@LearnitTraining]

😊