Google Sheets Beginner Tutorial

Google Sheets Beginner Tutorial

Get Ad-Free Training by becoming a member today!
   / @learnittraining  

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, and more.

For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com

Enroll in our live, instructor-led Google Sheets classes:
https://bit.ly/3K2WnEK

For Private Group Trainings please visit:
https://www.learnit.com/private-group...

Start 0:00
Introduction 0:03
Start Page 0:28
Interface 2:10
Search the Menus 3:46
Navigating and Selecting Cells 5:51
Entering and Editing Data 8:37
Explore 11:49
Performing Simple Calculations 17:03
Saving 19:57
Introduction to Google Drive 21:04
Building Basic Formulas 24:22
Using Simple Functions 28:03
Copying Formulas and Functions with AutoFill 32:50
Relative vs Absolute Reference 37:15
Inserting Rows and Columns 43:30
Moving, Copying, and Pasting Data 46:57
Using AutoFill to Complete a Series of Values 49:54
Cell Formatting - Align, Text Rotation, Text Wrapping 53:07
Formatting Worksheet Data and Using Cell Design 57:19
Using Sheets Templates 1:00:29
Inserting, Deleting, Renaming, Moving, and Copying Worksheets 1:02:02
Freeze Panes 1:04:49
Currency Formatting 1:07:44
Hiding Rows and Columns 1:08:34
Spell Check 1:10:39
Using the Full-Screen View 1:12:00
Printing 1:12:55
Download Options 1:14:31
Publishing Sheets to the Web 1:15:16
Sending Sheets as Emails 1:16:21
Conclusion 1:18:14

#GoogleSheets

(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.