Introduction
Numbers Customs Format08:51
Text
Cell Contain Text02:14
Special Symbols01:51
String Identical01:48
Join Text02:49
Format Text Values03:06
Remove Space01:50
Count Charactors01:23
Padding A Number04:11
Change Case01:42
Extract Charctor05:32
Remove Trailing Minus sign02:45
Ordinal Numbering08:05
First word Extract02:51
Extract String Except First Word03:27
Date
Introduction of Dates in Excel07:59
Date Autofil Tips and Formulas06:15
Convert Non Date String to Date02:58
Calculate Number of Days between two dates02:18
Calculate Number of Working Days between two dates03:35
Date Formulas03:01
Date Value Formula06:21
Network Days Formula02:58
Working Days between Two Dates – Advance Verision06:27
Offsetting a Date using only work Days03:51
Number of years between two dates02:55
Calculate Age of any person02:18
Calculate Days Remain in a year02:27
Weekday Determination02:07
Calculate last Day of the month01:35
Time
Display Time05:26
How to Sum of Hours02:26
Number of Hours02:17
Converting Decimal Hours, Minutes, Seconds into Time03:14
Rounding of Time Values02:43
Count
Basic of Count formulas06:07
Formula countif03:48
Mode03:23
Countif Text02:37
Examples of Count04:25
Sum, Sumif, Sumifs
Fomula – Sum06:35
Fomula – Sumif11:22
Fomula – SumIfs08:04
Lookup
Vlookup06:16
Hlookup02:40
Advance – Vlookup03:08
Use of Vlookup with If03:57
Use of Vlookup with Iferror Function03:25
Vlookup Exmaple – 103:06
Vlookup Exmaple – 207:39
Vlookup Exmaple – 306:06
Table
Introduction – Table21:33
Fill in the Gaps04:32
Advance Filter09:02
Database Function07:34
SubTotal04:58
Logical Formula
Logical Formula11:58
Security in Excel
Security : Part-104:13
Security : Part-203:57
Pivot Tables
Pivot Table : Part-109:28
Pivot Table : Part-201:38
Pivot Table : Part-302:49
Pivot Table : Part-403:25
Page Setup
Page Setup Header Footer06:50
Page Setup10:23
Introduction of Excel 2010
