Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Google Sheets Beginner Tutorial
Play lesson

Google Sheets Full Course - Google Sheets Beginner Tutorial

4.0 (1)
21 learners

What you'll learn

This course includes

  • 5.3 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

Google Sheets Beginner Tutorial Get Ad-Free Training by becoming a member today! https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com 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. 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 Learnit is no longer associated with this channel/video. (C) 2025 Bomberry Productions Any illegal reproduction of this content will result in immediate legal action.

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere