Google Sheets Course

by

LearnVern

#1

See all ranking

Google Sheets Course

by

LearnVern

#1

See all ranking

with Certifications

of Recorded Content

4.7 Rated

Language

with Certifications

of Recorded Content

4.7 Rated

Read all Reviews

Language

About

Key Features

Content

FAQs

What's in it for You?

Key Features:

Topics you will learn

Introduction to GSuite
- - Setup Your Gmail Account
- - Getting Started with Google Drive
Getting Started with Google Spreadsheets
- - Basics of Google Spreadsheets
- - Assignment : Basics of Google Spreadsheets
- - Modifying Cells,Rows & Columns in Google Spreadsheets
- - Assignment : Modifying Cells,Rows & Columns in Google Spreadsheets
- - Modifying Spreadsheets
- - Assignment : Modifying Spreadsheets
- - Cell Placements in Google Spreadsheets
- - Quiz: Getting Started with Google Spreadsheets
Formatting in Google Spreadsheets
- - Cell Border Formatting in Google Spreadsheets
- - Assignment : Cell Border Formatting in Google Spreadsheets
- - Merge Cells in Google Spreadsheets
- - Hide/Unhide Rows and Columns in Google Spreadsheets
- - Cell Formatting in Google Spreadsheets
- - Assignment : Cell Formatting in Google Spreadsheets
- - Freeze/Unfreeze Rows and Columns in Google Spreadsheets
- - Explore Feature in Google Spreadsheets
- - Assignment : Explore Feature in Google Spreadsheets
- - Opening, Importing & Copying Files in Google Spreadsheets
- - Text Wrapping and Text Rotation in Google Spreadsheets
- - Assignment : Text Wrapping and Text Rotation in Google Spreadsheets
- - Using Google's Inbuilt Template Gallery
- - Quiz: Formatting in Google Spreadsheets
Formulas in Google Spreadsheets
- - Basic Math Formulas in Google Spreadsheets
- - Assignment : Basic Math Formulas in Google Spreadsheets
- - Sum' and 'Sumif' Formulas in Google Spreadsheets
- - Assignment : 'Sum' and 'Sumif' Formulas in Google Spreadsheets
- - Sumifs' and 'Sumproduct' Formulas in Google Spreadsheets
- - Assignment : 'Sumifs' and 'Sumproduct' Formulas in Google Spreadsheets
- - Count' Formulas in Google Spreadsheets
- - Assignment : 'Count' Formulas in Google Spreadsheets
- - If' Function in Google Spreadsheets
- - Assignment : 'If' Function in Google Spreadsheets
- - Basic Billing System with Nested 'If' in Google Spreadsheets
- - Creating Report Card with Help of Google Spreadsheets
- - Applying Alternating Colors to Google Spreadsheets
- - Conditional Formatting in Google Spreadsheets
- - Filter Data in a Google Spreadsheets
- - Assignment : Filter Data in a Google Spreadsheets
- - Quiz: Formulas in Google Spreadsheets
Basic Operation on Google Spreadsheets
- - Find & Replace in Google Spreadsheets
- - Assignment : Find & Replace in Google Spreadsheets
- - Cut, Copy, Paste, Undo, Redo in Google Spreadsheets
- - Assignment : Cut, Copy, Paste, Undo, Redo in Google Spreadsheets
- - File Menu and View Menu in Google Spreadsheet
- - Assignment : File and View Menu in Google Spreadsheet
- - Share, Email and Download Google Spreadsheet
- - Assignment : Share, Email and Download Google Spreadsheet
- - Create a Shortcut of Google Spreadsheets to Drive
- - Publish Google Spreadsheets to Web and to Print PDF
- - Quiz: Basic Operation on Google Spreadsheets
Advance Features of Google Spreadsheets
- - Check Version History of Google Spreadsheets
- - Insert Notes and Comments in Google Spreadsheets
- - Insert Check Box and URL/Link in Google Spreadsheets
- - Assignment : Insert Check Box and URL/Link in Google Spreadsheets
- - Sorting Data in Google Spreadsheets
- - Assignment : Sorting Data in Google Spreadsheets
- - Named Ranges, Protect Sheets & Ranges
- - Assignment : Named Ranges, Protect Sheets & Ranges
- - Quiz: Advance Features of Google Spreadsheets
Graphics & Illustrations in Google Spreadsheets
- - Insert Images in Google Spreadsheets
- - Assignment : Insert Images in Google Spreadsheets
- - Insert Peoples Chips in Google Spreadsheets
- - Insert Drawings in Google Spreadsheets
- - Assignment : Insert Drawings in Google Spreadsheets
- - Insert Charts in Google Spreadsheets
- - Assignment : Insert Charts in Google Spreadsheets
- - Quiz: Graphics & Illustrations in Google Spreadsheets
Working with Data in Google Spreadsheets
- - Data Validation in Google Spreadsheets
- - Assignment : Data Validation in Google Spreadsheets
- - Pivot Tables in Google Spreadsheets
- - Assignment : Pivot Tables in Google Spreadsheets
- - Data Cleanup Process in Google Spreadsheets
- - Assignment : Data Cleanup Process in Google Spreadsheets
- - Quiz: Working with Data in Google Spreadsheets
3rd Party Add-ons and App Script
- - 3rd Party Add-ons and App Script Feature in Google Spreadsheet
- - Assignment : 3rd Party Add-ons and App Script Feature in Google Spreadsheet
- - Import Data with Importrange Formula in Google Spreadsheet
- - Macros in Google Spreadsheet
- - Quiz: 3rd Party Add-ons and App Script
Course Summary

Course Summary
Interview Questions

Interview Questions
Career Guideline

Career Guideline

Course Offerings

Certificate you will get

NSDC Certificate of Partnership with LearnVern.

Help build strong resume.

Great add-on to get Internship.

Upgrade your Job with this certificate proof.

After this Course

Pre Requsites

Course is for

No results found.

FAQ's

Can LearnVern’s course help understand ‘what is Google Sheet’?

In LearnVern’s course, all features of the Google Sheet are covered. Through video-based explanations, students learn basics, tips and tricks, formulas and other details. The end-to-end coverage of the topic helps completely understand ‘what is Google Sheet’.
What are the top learnings from Google Sheet Course from LearnVern?

How to create Google Spreadsheet, edit, save and share it with others are some of the top learnings from Google Sheet Course. While basics include creating, saving and sharing part, the editing part is quite detailed as all formatting functions and formulas are taught as the tutorial moves to advanced teaching.
Who can join Google Spreadsheet Course at LearnVern?

Students, freelancers, entrepreneurs and any person who is interested in learning Google Sheet can join this course. A basic knowledge of MS Excel may help but it is not a prerequisite. The course is offered for free to all. So, anyone with access to iOS and Android devices can enroll for this course and learn Google Sheets easily.
Where can I learn Google Sheets flexibly?

Google Spreadsheet course is available for learning in a self-paced manner at LearnVern. This course is accessible on mobile devices. You can learn it at your chosen pace and schedule in your free time at home. There is an option for revisiting modules which you need to practice more; hence, the overall outcome is complete learning.
Why should I learn Google Sheets?

Google Sheets is one the applications available in G-suite or Google Workspace. Learning this application can help you in all spheres of life. As a homemaker, you can record expenses and earnings and make suitable decisions. If you are a freelancer, you can use it to track the work and payments. This simple skill is of great use in all sorts of professions. You can even share this sheet with other stakeholders and discuss it through the comments window provided. Thus, Google Sheets has become an essential skill to learn for the users who want to be career-ready.
Can I join the LearnVern Google Spreadsheet Course along with the job?

Yes, you can! This course is taught through a flexibly paced tutorial. The learners can join this course at their chosen time and pace. Since the course is to be done on mobile phones, you can join it outside the job timings.
What are the benefits of learning Google Spreadsheet from LearnVern?

LearnVern offers features that ensure complete learning. You can revisit tutorials multiple times to learn Google Sheets to perfection. The course is available for access on mobile devices, computers and TV screens too. The course is career-oriented in all aspects. A National Skill Development Certificate is provided as proof of your skills at the end of the course for a nominal fee.
Do I need to learn Excel first to join the Google Spreadsheet course from LearnVern?

Google Sheets is quite similar to Excel. So, it may help in learning this course quickly if you have prior knowledge of Excel. However, it is not mandatory.