Get Familiar with Google Sheets
Data Entry 105:27
Selection04:18
Insert Delete Row Column06:53
Basic Formatting06:19
Copy Paste04:28
Travel Expense Report09:24
Printing07:38
Getting Start with Formulas
Formula Basic04:51
Absolute Relative Reference07:16
Named Range Cell05:32
Named Range Range03:11
Text Functions
Arabic Roman02:13
Concatenate05:04
Text with Concatenate05:29
Fixed02:24
Join03:32
Left Right Mid Len03:49
Lower Upper Proper01:50
Replace03:40
Rept02:10
Split02:09
Find Search05:15
Value Function03:37
Trim function02:47
Exact function02:23
Subsitute03:22
Advance Text function08:08
Date Functions
Date Basic07:39
Edate Eodate06:39
Days36003:48
NETWORKDAYS07:41
Workday intl08:52
Age06:57
Time Sheet14:26
Logical Functions
Logical Operators03:30
If05:11
Nested if04:08
AND04:20
Or03:28
Ifs02:45
Lookup Function
Address04:04
Choose04:03
Formula Text04:31
lookup12:32
Payslip Vlookup03:41
Financial Functions
Four Important Concepts for Financial Functions04:32
Present Value of Money04:16
Present Value of Lum Sum Amount FV02:44
Present Value of installment with lum sum amount04:02
Future Value 3 Examples09:28
PMT calculate Payment or installments06:58
Rate Calculation08:43
Nper Number of Period Calculation 2 examples07:14
Advance Financial Function
Deffered Loan Installment Payment Calculation04:18
Calculate Bond Price on Specified Yeild Rate05:57
Yield Calculation on Bond02:59
NPV05:10
Sumifs
Sum Sumif08:20
Sumifs04:30
Pivot Table
Introduction of Pivot Table07:03
Learn Pivot Table in Depth09:32
Use of Sum Average Count CountA function07:15
Groupin and Extract Data03:35
Calculated Field04:40
Google Forms
Introduction of Google Forms02:58
Google Form11:18
Google Form02:46
Google Form06:10
Introduction
