Google Sheets Beginner Tutorial

Google Sheets Beginner Tutorial
2023 Update

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

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:
https://www.learnitanytime.com

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

Join Offsite for our online community of teachers and peers:
https://www.offsitebylearnit.com

Manuals: https://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.