Advanced Excel
19 videos • 1,567 views • by IT Series
1
How to Create Drop Down List in MS Excel(Urdu/Hindi)
IT Series
Download
2
How to Add Elements in Drop Down List - MS Excel (Urdu/Hindi)
IT Series
Download
3
How to Create Multiple Dependent Drop Down Lists in MS Excel(Urdu/Hindi)
IT Series
Download
4
Force the user to enter whole value(Urdu/Hindi)
IT Series
Download
5
Accepting Dates Between a Particular Range(Urdu/Hindi)
IT Series
Download
6
How to Use COUNTIF Function in MS Excel (Urdu/Hindi)
IT Series
Download
7
How to Use SUMIF and AVERAGEIF Function in Excel(Urdu/Hindi)
IT Series
Download
8
SUMIFS and AVERAGEIFS Function(Urdu/Hindi)
IT Series
Download
9
Nested IF Function (Urdu/Hindi)
IT Series
Download
10
IF with AND OR Function (Urdu/Hindi)
IT Series
Download
11
PMT Function (Urdu/Hindi)
IT Series
Download
12
VLOOKUP Function (Urdu/Hindi)
IT Series
Download
13
Using VLOOKUP from Ribbon(Urdu/Hindi)
IT Series
Download
14
Advanced use of VLOOKUP Function (Urdu/Hindi)
IT Series
Download
15
VLOOKUP with TRIM Function(Urdu/Hindi)
IT Series
Download
16
HLOOKUP Function (Urdu/Hindi)
IT Series
Download
17
MATCH Function (Urdu/Hindi)
IT Series
Download
18
INDEX Function (Urdu/Hindi)
IT Series
Download
19
FV Function (Urdu/Hindi)
IT Series
Download