Google Sheets Basic to Advance Course

Name: Google Sheets Basic to Advance Course
Rating: 4.4 (18 reviews)

Hands-on Practical Examples, Lots of Exercises, Practice Files, that will make you master in Google Sheets

Created byVeer Tutorial, Mahavir Bhardwaj

Last updated 3/2025

English

What you'll learn

Learn how to use Google Sheets from Scratch
All Advance Functions Vlookup, Filter, Finance etc
Create Forms for Collect Data directly in Google Sheets
Pivot Table for MIS Reporting in Depth

Course content

11 sections • 71 lectures • 7h 2m total length

Introduction7:38

Create First Google Sheets7:38
Insert, Delete, Rename, Hide, Un-hide Sheets4:36
Create First Data Table5:26
Selection of Data, Cell, Range4:17
All About Rows Columns Insert Delete6:52
Formatting of Sheets Cells Ranges6:18
Copy Paste, Paste Special4:27
Formatting Practice : Let's Make Travel Expense Report9:23
You can download the Travel Expense Report in PDF and Excel Format. You have to upload in Your Google Drive. Then open It as Google Sheets.
Complete the Same for your practice
Printing Google Sheets7:37

Convert Roman Numeral2:12
Join Texts Strings : Concatenate Function5:03
Join Texts with Number Date in Specified Format : Text with Concatenate Function5:28
Give Format to Numbers : Fixed Function2:24
Join Function3:31
Left Right MID Len Function3:48
Lower Upper Proper Function1:49
Replace Function3:39
Find Search Function5:14
Repeat Text in Cell: REPT Function2:09
Split Strings using Delimiter : Split Function2:08
Value Function3:36
Trim Function2:46
Exact Function2:22
Substitute Function3:21
Advance Text Functions Techniques8:07

Four Most Important Concept before start Financial Function4:31
Present Value of Money4:15
Present Value of Money of Lum Sum Amount2:43
Present Value of Lum Sum Amount with Installment4:01
Future Value with Three Examples9:27
Know Installment Amount of Loan using PMT Function6:57
Rate Calculation8:42
Number of Periods (NPER) Calculation7:13
Deferred Loan Installment Payment Calculation4:17
Calculate Bond Price or Face Value of Bond5:56
Yield Calculation on Bond2:58
NPV5:09
Introduction of Pivot Table7:02

Requirements

You require a Google Account and a computer or tablet or mobile
Most Important your DESIRE to learn

Description

Google Sheets becomes very popular spreadsheets program because First, it's FREE, Secondly, Cloud base simply login your account on any device and start working, above all Flexibility of uses, Getting improved day by day.

So keeping Google Sheets's importance in mind, you need get familiar with Feature & Function of Google Sheets as quickly as possible.

We bring this Google Spreadsheet course for you to get in depth knowledge of Google's Free Wonderful Program.

This course will begin from very basic level, once you complete you will be able to do complex calculations, make formats within minutes, create Dynamic MIS Reports, Use Google Forms, Create Dynamic Dashboards & So....

What you Learn?

We tried to cover almost all feature & Functions but majors are listed below: -

Pivot Table
Import of Data in Google Sheets from Excel
Google Forms
Formatting Tip & Tricks
Date & Time
Text
Lookups
Conditional Sum, Counting
Logical Operators
New Techniques will be uploaded time to time.

Who this course is for:

Any person who wants to become expert in Google Sheets
All big fortune companies now moving to Google Product So future is Good if you want to upgrade yourself

Google Sheets Basic to Advance Course

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 8min

Get Familiar with Google Sheets9 lectures • 57min

Getting Start with Formulas4 lectures • 21min

Google Forms with Google Sheets4 lectures • 23min

Learn Text Function16 lectures • 58min

Working with Date and Time7 lectures • 53min

Logical Functions6 lectures • 23min

Lookup5 lectures • 1hr 12min

Financial Functions13 lectures • 1hr 13min

Pivot Table in Google Sheets4 lectures • 25min

Requirements

Description

Who this course is for: