Course Summary
Skill Level : Beginner
Language : Hindi/English
Lessons : 49
Video Duration : 60 Mins
Course Features
Easy and interactive content
Get certified
Get new updates periodically
Learn from anywhere at your convenient time
Learn at your own pace
Learn more in less time
Course Overview
Google Sheets is a cloud based powerful Spreadsheet and is very easy to operate and even very easy to learn.
Organisations across multiple sectors are widely using Google Sheets in their operations.
Google Sheets skill is currently in demand in industry and it is a must have skill in today’s digital era.
This course will help you to get strong operating knowledge of Google Sheets.
By this course, you will be able to implement Google Sheets in your day to day operations and will also be able to work on important Google Sheets functions which can be used to design different formulas to automate your work.
FAQs
Introduction to Google Sheets
Course Introduction🔒
Creating a new Google Sheets🔒
Overview of Google Sheets🔒
Selection of Range 🔒
Introduction to Data Summary🔒
Basic tools of Google Sheets
Introduction to data formatting tools 🔒
Understanding data freezing tool 🔒
Understanding of sorting tools 🔒
Quick data formatting using alternate colours 🔒
Collaborating of Google Sheets with multiple users 🔒
Sharing Google Sheets publicly 🔒
Understanding the row/column protection and sheet protection 🔒
How to print/download/email Google Sheets 🔒
Removing duplicate records 🔒
How to split data 🔒
Understanding edit history 🔒
Adding hyperlinks 🔒
Understanding Filter tool 🔒
Useful keyboard shortcuts in Google Sheets 🔒
Opening/converting Excel file into Google Sheet 🔒
The intermediate tools of Google Sheets
Understanding data validation tool 🔒
Understanding Conditional formatting 🔒
How to add images in Google Sheets? 🔒
How to add comments and send Email from Google Sheets using commenting tool? 🔒
Changing of Google Sheets location within Google Drive 🔒
Publishing Google Sheets as web page 🔒
Google Sheets backup and restore 🔒
How to use find and replace tool 🔒
Location and calculations setting in Google Sheets 🔒
Addition of Prefix and Suffix to Numbers 🔒
Introduction to powerful Charts/Graphs tools in Google Sheets 🔒
Introduction to Google Sheets functions
Introduction to Google Sheets functions 🔒
Average Function 🔒
How to make changes in a formula using find and replace tool 🔒
Google translate Function 🔒
TODAY Function 🔒
TRANSPOSE Function 🔒
LEFT/RIGHT Function 🔒
MERGE Function 🔒
UPPER/LOWER Function 🔒
SORT Function 🔒
COUNT & COUNTA Function 🔒
UNIQUE Function 🔒
ROUND/ROUNDUP/ROUNDDOWN Function 🔒
IF Function 🔒
SUMIF Function 🔒
VLOOKUP Function 🔒
Array Formula 🔒
Course Content
Reviews From Our Learners
Vaishnavi Parmar
"This is great and extremely valuable knowledge for making software. This course is very detailed and easily understandable. With the help of this knowledge we can easily make could based tools using Google Sheets with security of Google, which is very difficult to make with other programing languages. Many thanks for the quality of your efforts!"
