Google Sheets for Beginners: The Complete Sheets Bootcamp

Name: Google Sheets for Beginners: The Complete Sheets Bootcamp
Rating: 4.4 (51 reviews)

The Ultimate Google Sheets bootcamp. Learn all the basics and intermediate functions of Google Sheets in under 4 hours

Created byRam Mohan

Last updated 3/2022

English

What you'll learn

All the basic functionality of Google Sheets
How the freely available Google Sheets can be an effective replacement for paid Excel
Hands on examples to help students learn Google Sheets more effectively
Features and functions that can help you work on spreadsheets more effectively

Course content

6 sections • 33 lectures • 3h 30m total length

Introduction - Please watch3:00
Introduction to the course and lecturer
Benefits of Google Sheets and How to use this course - Please watch5:54
A quick look at the features of Google Sheets and how to make full use of this course
How to register for a Google Sheets Account - Skip if you already have gmail3:02
Registering for a new Google Sheets account if you don't have a gmail account
How to create a new Google Sheet5:23
Creating a new Google Sheet

Inputting Data into Google Sheets4:44
The basics of entering data into Google Sheets
Overview of toolbar in Google Sheets10:54
An overview of the toolbar in Google Sheets
Templates in Google Sheets5:18
Templates and how to use the same in Google Sheets
Overview of Menu in Google Sheets11:51
A look at the various menu options in Google Sheets
Basics of Text, Number and Formatting in Google Sheets6:27
How to format text and numbers in Google Sheets
Cut Copy and Paste Operations in Google Sheets5:00
How to effectively use Cut, Copy and Paste operations in Google Sheets

Basic Functions in Google Sheets6:59
How to use functions in Google Sheets
Overview of Tab Operations in Google Sheets8:49
An overview of tabs and how to use them in Google Sheets
Overview of Row and Column Operations in Google Sheets6:40
Rows and Columns and the various operations associated with them in Google Sheets
Sample Functions in Google Sheets7:50
Functions and how to effectively use them in Google Sheets
Sample Functions in Google Sheets Continued10:28
Some more function examples in Google Sheets
Sharing in Google Sheets9:42
How to share and collaborate with Google Sheets

Version History in Google Sheets4:58
Version history and how to effectively retrieve and use older versions of a sheet in Google Sheets
Data Filtering and sorting in Google Sheets11:32
How to sort and filter in data in Google Sheets
More filtering options incl. Filter Views and Temporary Filters in Google Sheets6:38
More sort and filter options in Google sheets including filter views
Charts and Graphs in Google Sheets5:24
How to create charts and graphs in Google Sheets
File Operations in Google Sheets7:09
File Operations in Google sheets including exporting and importing data
Recovering Deleted Files in Google Sheets2:21
Managing and retrieving deleted files in Google Sheets
Conditional Formatting in Google Sheets5:38
How to utilize the conditional formatting operations of Google Sheets

Data Validation in Google Sheets6:17
How to validate data entry in Google Sheets
Pivot Tables in Google Sheets5:35
How to use pivot tables in Google Sheets
Creating Custom Functions in Google Sheets7:04
How to build and use custom functions in Google Sheets
Macros in Google Sheets6:23
Building, managing and using macros in Google Sheets
Using Forms in Google Sheets11:21
Using the form builder and integrating form results into Google Sheets

Sample Sheets in Google Sheets7:44
Sample sheets examples to show what is possible using Google Sheets
Things we did not cover to explore on your own5:32
Additional areas for students to explore on their own
Help and Shortcuts in Google Sheets3:10
How to be more productive using the Help and Keyboard shortcuts in Google Sheets
Goodbye and thank you0:55
Thank you for enrolling and taking this course
Bonus Material0:21

Requirements

Know the basics of working in Excel or other spreadsheet programs
The course will not cover the basics of Excel or Office or Windows (example, Copy paste shortcuts)

Description

Are you struggling to understand the basics of Google Sheets?
Are you finding it hard to transition from Excel or other spreadsheet programs to Google Sheets?

Then you have come to the right place!

Welcome to this Google Sheets Bootcamp course where you’ll learn all about Google Sheets.

This course has been designed for anybody looking to transition to Google Sheets from Excel or other spreadsheet programs. By the end of this course, you’ll be able to confidently use Google Sheets at an intermediate level

This course is designed to take you right from the basics and all the way to intermediate and advanced concepts of Google Sheets. Whether you’re a beginner just starting out on Google Sheets or already have some knowledge around Google Sheets, you are guaranteed to learn a lot throughout this course. Your knowledge of Google Sheets will be accelerated in just under 4 hours through step-by-step instructions and examples.

The ideal student for this course is somebody who already knows the basics of spreadsheets and wants to transition their skills to Google Sheets. There is no requirement to be a spreadsheet expert, the only requirement is to practice what you learn in order to ramp up your skills.

Feel free to browse the preview videos. This course has a 30 day no questions asked money back guarantee if you are not satisfied. So enroll now to learn all about Google Sheets!

Sample of reviews from students:

Henry - "Very informative. Thank you for sharing your knowledge about google sheets!"

Tharaka Perera - "Very good explaining. Highly recommended. Thank you!"

Joseph Ojo Oluwadimimu - "This course is explanatory and insightful"

Who this course is for:

Excel users taking their first step into migrating to Google Sheets
IT admins who are trying to reduce cost by moving away from Excel onto free Google Sheets.
Users learning to use Google Sheets more effectively as part of migrating away from Excel

Google Sheets for Beginners: The Complete Sheets Bootcamp

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 17min

Introduction to Google Sheets Operations6 lectures • 44min

Additional Sheets Functionality6 lectures • 50min

Intermediate Options and Functions in Google Sheets7 lectures • 44min

Advanced Functionality in Google Sheets5 lectures • 37min

Further Reading and Next Steps5 lectures • 18min

Requirements

Description

Who this course is for: